MODULE 2 - EXCEL ESSENTIALS​

MODULE 3 -EXCEL FORMULAS

• Lesson 9 – Excel Formula Basics
• Lesson 10 – Logical Formulas in Excel
• Lesson 11 – Math Formulas in Excel
• Lesson 12 – Lookup and Reference Formulas in Excel
• Lesson 13 – Stats Formulas in Excel
• Lesson 14 – Text Formulas in Excel
• Lesson 15 – Date and Time Formulas in Excel
• Lesson 16 – Formulas Mix and Match (10 Examples)

EXCEL VBA COURSE

MODULE 1

• Lesson 1 – Introduction to VBA Language and the VB Editor
• Lesson 2 – Recording/Decoding Macros in Excel
• Lesson 3 – Running Macros in Excel
• Lesson 4 – Writing Your First VBA Code

MODULE 2

• Lesson 5 – Understanding Errors in VBA

MODULE 3

• Lesson 6 – Working with Cells and Ranges using VBA
• Lesson 7 – Working with Worksheets
• Lesson 8 – Workbooks using VBA

MODULE 4

• Lesson 9 – Using Variables in VBA
• Lesson 10 – Using Object Variables in VBA
• Lesson 11 – Using Message Boxes in VBA

MODULE 5

• Lesson 12 – With Statement Loop
• Lesson 13 – If-Then Else Loop
• Lesson 14 – Select Case Loop

MODULE 6

• Lesson 15 – Do While/Until Loop
• Lesson 16 – For Next Loop
• Lesson 17 – For Each Loop

MODULE 7 

• Lesson 18 – Creating Custom Functions in VBA
• Lesson 19 – Error Error Everywhere - How to Handle it
• Lesson 20 – Using Event Procedures to run macros

MODULE 8 

• Lesson 21 – Userform - Basics + Deep Dive
• Lesson 22 – Using Array in VBA
• Lesson 23 – Working with Charts using VBA
• Lesson 24 – Show and Hide Elements using VBA
• Lesson 25 – Update Charts/Dashboards with a Single Click

MODULE 9 

• Lesson 26 – Creating Mouse Rollover Effect using VBA
• Lesson 27 – Creating Chart Animations using VBA
• Lesson 28 – Creating Add-ins using VBA
• Lesson 29 – Creating an Application using VBA
• Lesson 30 – Working with Files and Folders
• Lesson 31 – Generating Word Reports using VBA
• Lesson 32 – Generating PDF Reports using VBA

BONUS

Pre-made Excel Templates

• Accounts Payable Ledger
• Attendance Sheet in Excel
• Content-calendar
• Gantt-chart_L
• Loan comparison calculator
• Make Salary Sheet in Excel
• MIS BOX Chart Report
• MIS Progress Report Chart
• Pivot-Tables-and-Dashboard-in-Excel
• Profit & Loss Statement
• Project-timeline
• Quotation in Excel
• Salary Slip
• Sales Funnel
• Stock Mainteance Report
• Stock Managment Software
• Student calendar
• To-do-list
• Work-schedule
• Sales Invoice Tracker

FREQUENTLY ASKED QUESTIONS