About course

This comprehensive certification program is designed to help you master Excel and Power BI from fundamentals to advanced dashboarding. Through hands-on projects, real datasets, and practical assignments, you will develop job-ready data analysis and reporting skills.

Curriculum

5 Chapters · 15 Lessons

  1. 1

    Getting Started with Excel

    1. (Included in full purchase)

      Interface overview, ribbons & keyboard shortcuts

    2. (Included in full purchase)

      Entering & formatting data (cells, rows, columns)

    3. (Included in full purchase)

      Number formatting, alignment, borders & cell styles

  2. 2

    Formulas & Basic Functions

    1. (Included in full purchase)

      SUM, AVERAGE, MIN, MAX, COUNT

    2. (Included in full purchase)

      Relative vs Absolute References ($A$1)

    3. (Included in full purchase)

      Introduction to the IF function

  3. 3

    Working with Data

    1. (Included in full purchase)

      Sorting & filtering datasets

    2. (Included in full purchase)

      Conditional formatting with rules & color scales

    3. (Included in full purchase)

      Creating basic charts: bar, line and pie

  4. 4

    Tables & Data Organization

    1. (Included in full purchase)

      Convert Data Range into Table

    2. (Included in full purchase)

      Structured references & table formulas

    3. (Included in full purchase)

      Find & Replace, data validation & dropdowns

  5. 5

    Lookup Functions

    1. (Included in full purchase)

      VLOOKUP & HLOOKUP — syntax and use cases

    2. (Included in full purchase)

      XLOOKUP — the modern, flexible alternative

    3. (Included in full purchase)

      Troubleshooting #N/A and common lookup errors