Skip to content

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

Categories: Excel
Share
Share Course
Page Link
Share On Social Media

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