🚀 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