Skip to content

The Excel 101 Mastery Series: Self-Learn Combo (Advanced)

Categories: Excel
Share

About Course

Master the world’s most widely used data tool from scratch. This bundle is designed for students, fresh graduates, and working professionals who need a flexible, “learn-anytime” path to professional data literacy.

What Will You Learn?

  • In this level, you will learn how to:
  • Use INDEX & MATCH to perform advanced data lookups
  • Build and analyze data using Pivot Tables
  • Create simple, effective Excel dashboards
  • Lock cells to prevent accidental changes
  • Protect worksheets to control user access
  • Understand and use Macros to automate repetitive tasks
  • Use Power Query to import, clean, and transform data efficiently

Course Content

Level 3: Advanced

  • Index Match
    00:00
  • Pivot Table
    00:00
  • Dashboard
    00:00
  • Protect Sheet
  • Macros – Absolute Referencing
    00:00
  • Macros – Relative Referencing
    00:00
  • Power Query Part 1
    00:00
  • Power Query Part 2
    00:00