🎉 12th Anniversary Offer! Get 50% off all courses 🎉

Need Help? call us free

+91 63029 64834

Choose the MS-Office & Advanced Excel course

Eligibility: ANY ONE

Learn the code from expert trainers

Our trainers have over 15+ years of industry experience, bringing extensive knowledge and expertise to our training programs.

No 1 Training with Trainers Top MNCs

Amazon, Google, Microsoft, and Infosys...

Our trainers are working in top MNC Companies

SIVASOFT TECHNOLOGIES PRIVATE LIMITED - India’s Leading Classroom and Online Training Company (2012-)





🚀 Offline / In-Person Classroom and Online Training Course: Master MS Office & Advanced Excel with VBA, AI, and ChatGPT

Eligibility: Any One

Trainer: Mr.Ravi (15+Years of Experience: Completed 250+batches successfully)

Duration: 2 Months

Group Training Fee (Master MS Office & Advanced Excel, AI, and ChatGPT): ₹7000/- ➡️ Offer: ₹3500/-

Group Training Fee (Master MS Office & Advanced Excel with VBA, AI, and ChatGPT): ₹11000/- ➡️ Offer: ₹5500/-

One-On-One Training Fee (Master MS Office & Advanced Excel, AI, and ChatGPT): ₹14000/- ➡️ Offer: ₹7000/-

One-On-One Training Fee (Master MS Office & Advanced Excel with VBA, AI, and ChatGPT): ₹22000/- ➡️ Offer: ₹11000/-

Course Curriculum:

  • 1. FUNDAMENTALS
  • 2. INTERNET CONCEPTS
  • 3. MS WORD
  • 4. MS POWERPOINT
  • 5. MS EXCEL
  • 6. MS ACCESS
  • 7. MS OUTLOOK or GMAIL
  • 8. ADVANCED EXCEL
  • 9. VBA (VISUAL BASIC FOR APPLICATIONS)
  • 10. EMAIL ID CREATION
  • 11. FREE ENGLISH TYPING (Rapid) COURSE
  • 12. FREE COURSE COMPLETION CERTIFICATE
  • 13. FREE RESUME PREPARATION
  • 14. SUBMITTING RESUME IN NAUKRI, MONSTER, INDEED AND SO ON
  • 15. Live Classroom & Online Classes
  • 16. Lifetime: Video Access
  • 17. AI
  • 18. ChatGPT

1.FUNDAMENTALS
  • Primary Parts
  • Generations
  • Input & output devices
  • Memory hierarchy table
  • Software vs Hardware
  • Paint
  • On screen keyboard and magnifier
  • Desktop Properties
  • Folder Creation & deletion
  • Recycle Bin
  • Notepad
  • Editing Text: Cut, Copy, Paste, Select All, Clear Find & Replace
  • Typing the text, Alignment of text
  • Storage Devices
  • Windows short cut keys
2.Internet Concepts
  • What is Internet?
  • Browsing
  • Search engines
  • Text chatting
  • Creating e-mail, sending e-mail & Email attachments
  • Online job searching,interviews
  • Online tickets booking,shopping
  • Downloading files, websites
  • Downloading Movies, Audio & Images
  • Uploading Movies, Audio & Images
  • Audio & Video chatting etc.
  • Creating and Using Social Media like facebook, Instagram, x, Youtube and so on
3.Microsoft Word
  • Introduction to Ms - Word
  • File Open, Close
  • Save and Save as difference
  • Page Setup, Setting margins, Print Preview, Print
  • Format Painter
  • Change case
  • Paragraph Specification
  • Font-color, highlight
  • Bullets, numbering and custom bullets
  • Sorting
  • Borders & shading
  • Indent increase / Decrease
  • Styles Applying and Create New Styles
  • Find, Go to, Replace
  • Select objects and similar formatting
  • Insert pictures, shapes
  • Hyperlinks and Bookmarks
  • Maths paper typing
  • Insert Text box
  • Insert Object
  • Create resumes
  • Spelling and Grammar check
  • Page orientation, Size and Margins
  • Mail Merge
  • Insert Date and Time
  • Insert Table and Formatting tables
4.Microsoft Power Point
  • Introduction to Ms-power point
  • Create Designing Slides
  • Create Custom Animations
  • Sound effects & BG Design
  • Create Timing Presentation
  • Slide Shows Presentation
  • Creating of business power point with brief explanation
  • Creating a Basic Presentation
  • Building Blocks of a Presentation
  • Working with Text
  • Working with Themes and Styles
  • Working with Charts, Graphs & Tables
  • Working with Media Clips and Animation
  • Adding Music and Video
  • Save as video
  • Packaging and Publishing your Presentation
5.MS EXCEL
  • About Excel sheet
  • Warp text in cell
  • Merge, merge and center, merge across
  • Cell Alignments 9
  • Fundamental operations with Excel
  • Sheet insert, delete, rename, color
  • fill Down
  • Select, move the cells in a sheet
  • Calculate Interest
  • Calculate
  • Sorting and filter
  • Create Graphs
  • Hide and unhide
  • Save as pdf
6.MS OUTLOOK or GMAIL
  • purpose
  • importance
  • tips and tricks
  • Creating Accounts
  • Spam Emails
  • Inbox, Compose, Trash, Spam, Labels and So on
7.MS ACCESS
  • Introduction to MS Access
  • Table in Design view
  • Table by Using Wizard
  • Data base,Tables Creations
  • Forms,reports,queries
7.Advanced Excel
  • Vlookup and Hlookup
  • Sumif, count if function
  • Attendence sheet calculations
  • Conditional formatting
  • Fill series, growth
  • Go to special
  • Cell Data types
  • Pivot table
  • Insert excel sheet to word
  • Define name
  • Date functions
  • Maths functions
  • Advanced filter
  • Text to column
  • Remove duplicates
  • Consolidations
  • Goal Seek, pmt function
  • Record macro
  • Payroll
  • Print settings
  • Protect worksheet
8.VBA (VISUAL BASIC FOR APPLICATIONS)
  • About Macro
  • Crate and run Macro
  • Save Macros
  • Difference between macro and vba
  • Insert Developer tab
  • VBA introduction
  • The concepts of variables
  • Explicit variables
  • Values to variables
  • Formatting Cells
  • Delete or insert sheets
  • User input for calculations
  • Arithematic Operations
  • MsgBox Function
  • If then else
  • If and if, Else if
  • For loop , Do loop
  • Select case
  • Insert values to cells
  • Insert List Box, Combo Box
  • Create buttons, check box
  • User forms
  • Create , delete file
  • Adding and subtracting dates
  • BMI Calculator
  • EMI calculator
  • Prime number Tester
  • Create Custom functions