Excel Beginner to Advance Course

Description

EXCEL Beginner to Advance Course

Course Modules ​​

EXCEL – Basics, Essentials & Formulas

MODULE 1 – EXCEL BASICS (for Beginners)

• Lesson 1 – Getting Started with Excel
• Lesson 2 – Data Entry, Data Editing, and Number Formatting
• Lesson 3 – Data Formatting
• Lesson 4 – Working with Cells and Ranges in Excel
• Lesson 5 – Managing Worksheets

MODULE 2 – EXCEL ESSENTIALS​

• Lesson 6 – Introduction to Excel Tables
• Lesson 7 – Auto-fill, Custom Lists, and Flash Fill
• Lesson 8 – Number Formatting in Excel

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)

Advanced Microsoft 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
• MIS Report Water Drop Chart
• Pivot-Tables-and-Dashboard-in-Excel
• Profit & Loss Statement
• Project-timeline
• Quotation in Excel
• Salary Slip
• Sales Funnel
• Stock Maintenance Report
• Stock Management Software
• Student calendar
• To-do-list
• Work-schedule
• Sales Invoice Tracker