🚀 Classroom and Online Training Course:
Master MS Office & Advanced Excel with VBA, AI, and
ChatGPT
Eligibility: Any One
Trainer (Completed 370+batches
successfully):
Mr.Ravi (12+Yrs of Exp) / Mr.Siva (12+Yrs of Exp) / Mr.Ram Teja (12+Yrs of
Exp)
Course 1: Master MS Office & Course Highlights
Group Training Fee: ₹4,000/- ➡️ Offer: ₹2,000/-
One-On-One Training Fee: ₹12,000/- ➡️ Offer: ₹6,000/-
Duration: 45 Days
Course 2: Master MS Office, Advanced Excel & Course Highlights
Group Training Fee: ₹6,000/- ➡️ Offer: ₹3,000/-
One-On-One Training Fee: ₹16,000/- ➡️ Offer: ₹8,000/-
Duration: 2 Months
Course 3: Master MS Office, Advanced Excel, and VBA & Course Highlights
Group Training Fee: ₹10,000/- ➡️ Offer: ₹5,000/-
One-On-One Training Fee: ₹20,000/- ➡️ Offer: ₹10,000/-
Duration: 2.5 Months
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)
Course Highlights:
- 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. LinkedIn Profile Creation
- 16. Live Classroom & Online Classes
- 17. Lifetime: Video Access
- 18. Artificial Intelligence (AI) (ChatGPT, CoPilot 🗣️💡)
- 19. Unlimited Lab
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
- Module 1: Text Basics
- Typing the text, Alignment of text
- Editing Text: Cut, Copy, Paste, Select All, Clear
- Find & Replace
- Module 2: Text Formatting and Saving File
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style
- Font Color, Use the Bold, Italic, and Underline
- Change the Text Case
- Line spacing, Paragraph spacing
- Shading text and paragraph
- Working with Tabs and Indents
- Module 3: Working with Objects
- Shapes, Clipart and Picture, Word Art, Smart Art
- Columns and Orderings - To Add Columns to a Document
- Change the Order of Objects
- Page Number, Date & Time
- Inserting Text boxes
- Inserting Word art
- Inserting symbols
- Inserting Chart
- Module 4: Header & Footers
- Inserting custom Header and Footer
- Inserting objects in the header and footer
- Add section break to a document
- Module 5: Working with Bullets and Numbered Lists
- Multilevel numbering and Bulleting
- Creating List
- Customizing List style
- Page bordering
- Page background
- Module 6: Tables
- Working with Tables, Table Formatting
- Table Styles
- Alignment option
- Merge and split option
- Module 7: Styles and Content
- Using Built-in Styles, Modifying Styles
- Creating Styles, Creating a list style
- Table of contents and references
- Adding internal references
- Adding a Footnote
- Adding Endnote
- Module 8: Merging Documents
- Typing new address list
- Importing address list from Excel file
- Write and insert field
- Merging with Outlook contact
- Preview Result
- Merging to envelopes
- Merging to label
- Setting rules for merges
- Finish & Merge options
- Module 9: Sharing and Maintaining Document
- Changing Word Options
- Changing the Proofing Tools
- Managing Templates
- Restricting Document Access
- Using Protected View
- Working with Templates
- Managing Templates
- Understanding building blocks
- Module 10: Proofing the Document
- Check Spelling As You Type
- Mark Grammar Errors As You Type
- Setting AutoCorrect Options
- Module 11: Printing
- Page Setup, Setting margins
- Print Preview, Print
4.Microsoft Power Point
- Module 1: Setting Up PowerPoint Environment
- New, Open, Close, Save, Save As
- Typing the text, Alignment of text
- Formatting Text: Font Size, Font Style
- Font Color, Use the Bold, Italic, and Underline
- Cut, Copy, Paste, Select All, Clear text
- Find & Replace
- Working with Tabs and Indents
- Module 2: Creating slides and applying themes
- Inserting new slide
- Changing layout of slides
- Duplicating slides
- Copying and pasting slide
- Applying themes to the slide layout
- Changing theme color
- Slide background
- Formatting slide background
- Using slide views
- Module 3: Working with bullets and numbering
- Multilevel numbering and Bulleting
- Creating List
- Page bordering
- Page background
- Aligning text
- Text directions
- Columns option
- Module 4: Working with Objects
- Shapes, Clipart and Picture, Word Art, Smart Art
- Change the Order of Objects
- Inserting slide header and footer
- Inserting Text boxes
- Inserting shapes, using quick styles
- Inserting Word art
- Inserting symbols
- Inserting Chart
- Module 5: Hyperlinks and Action Buttons
- Inserting Hyperlinks and Action Buttons
- Edit Hyperlinks and Action Button
- Word Art and Shapes
- Module 6: Working With Movies and Sounds
- Inserting Movie From a Computer File
- Inserting Audio file
- Audio Video playback and format options
- Video options, Adjust options
- Reshaping and bordering Video
- Module 7: Using SmartArt and Tables
- Working with Tables, Table Formatting
- Table Styles
- Alignment option
- Merge and split option
- Converting text to smart art
- Module 8: Animation and Slide Transition
- Default Animation, Custom Animation
- Modify a Default or Custom Animation
- Reorder Animation Using Transitions
- Apply a Slide Transition
- Modifying a Transition
- Advancing to the Next Slide
- Module 9: Using slide Master
- Using slide master
- Inserting layout option
- Creating custom layout
- Inserting place holders
- Formatting place holders
- Module 10: Slide show option
- Start slide show
- Start show from the current slide
- Rehearse timing
- Creating custom slide show
- Module 11: Proofing and Printing
- Check Spelling As You Type
- Setting AutoCorrect Options
- Save as video
- Save as JPEG files
- Save as PowerPoint Show file
- Print Preview, Print
5.MS EXCEL
- Module 1: Introduction to Excel
- Introduction to Excel interface
- Understanding rows and columns, Naming Cells
- Working with excel workbook and sheets
- Module 2: Formatting Excel Workbook
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style
- Font Color, Use the Bold, Italic, and Underline
- Wrap text, Merge and Centre
- Currency, Accounting and other formats
- Modifying Columns, Rows & Cells
- Module 3: Perform Calculations with Functions
- Creating Simple Formulas
- Setting up your own formula
- Date and Time Functions, Financial Functions
- Logical Functions, Lookup and Reference
- Functions Mathematical Functions
- Statistical Functions, Text Functions
- Module 4: Sort and Filter Data with Excel
- Sort and filtering data
- Using number filter, Text filter
- Custom filtering
- Removing filters from columns
- Conditional formatting
- Module 5: Create Effective Charts to Present Data Visually
- Inserting Column, Pie chart etc.
- Create an effective chart with Chart Tool
- Design, Format, and Layout options
- Adding chart title
- Changing layouts
- Chart styles
- Editing chart data range
- Editing data series
- Changing chart
- Module 6: Analyze Data Using PivotTables and Pivot Charts
- Understand PivotTables, Create a PivotTable
- Framework Using the PivotTable and PivotChart
- Create Pivot Chart from Pivot Table
- Inserting slicer
- Creating Calculated fields
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
