Preview this course
₹149 ₹399 63% off
incl. GST
left at this price!
Sign up to buy Already a member? Log in

7-day money-back guarantee

Bestseller Recently updated Productivity

Excel Mastery: Beginner to Pro

Built for beginners who want to think in data — the no-experience-needed path to roles that pay for Excel.

4.0 (19 ratings) Created by Mariam Saleh
Beginner 88 lessons 21h 28m Updated Jul 2026 English
Preview this course
₹149 ₹399 63% off
incl. GST
left at this price!
Sign up to buy Already a member? Log in

7-day money-back guarantee

What you'll learn

Navigate Excel confidently and build clean, professional spreadsheets
Write formulas and functions — IF logic, lookups, text and date functions
Clean and prepare messy real-world data for analysis
Analyze data with sorting, filtering, Tables, and PivotTables
Master modern lookups: VLOOKUP, INDEX/MATCH, and XLOOKUP
Build interactive dashboards and choose the right chart every time
Automate work with Power Query, Power Pivot, DAX, and VBA macros
Use Copilot and ChatGPT for Excel — and verify their output

This course includes

21h 28m of on-demand content
88 lessons across 13 sections
Access on mobile and desktop
Certificate of completion
Certificate of Achievement
Lifetime access
Curriculum

Course content

13 sections · 88 lessons · 21h 28m

Welcome to Excel — Your First Day at Work Preview 14 min
Navigating Excel Like a Pro Preview 16 min
Data Entry Essentials Preview 16 min
Formatting Like a Professional 16 min
Working With Large Sheets 16 min
Managing Worksheets & Workbooks 16 min
Test Your Learning 10 min

Understanding Formulas 14 min
Essential Functions 14 min
IF Function Fundamentals 12 min
Relative vs Absolute References 16 min
Nested IF, IFS & SWITCH 16 min
AND, OR, NOT 15 min
Error Handling & Formula Auditing 16 min
Named Ranges 15 min
Text Functions 16 min
Date & Time Functions 18 min
Test Your Learning 10 min

Common Data Problems 16 min
Flash Fill Magic 14 min
Text to Columns 14 min
Remove Duplicates & Data Quality 16 min
Data Validation 16 min
Conditional Formatting 18 min
Test Your Learning 10 min

Sorting Data 14 min
Filtering Data 16 min
Excel Tables 16 min
Subtotals & Grouping 16 min
Pivot Tables Introduction 16 min
Advanced Pivot Tables 20 min
Pivot Charts 16 min
Test Your Learning 10 min

VLOOKUP Fundamentals (+ HLOOKUP) 16 min
Common VLOOKUP Mistakes & Fixes 16 min
INDEX & MATCH 16 min
XLOOKUP (Modern Excel) 16 min
Dynamic Lookup Systems 18 min
Test Your Learning 10 min

Conditional Aggregation: SUMIFS, COUNTIFS, AVERAGEIFS 16 min
Dynamic Arrays: FILTER, SORT, UNIQUE 18 min
SEQUENCE, RANDARRAY & Spill Techniques 18 min
LET — Cleaner, Faster Formulas 16 min
LAMBDA — Build Your Own Functions 18 min
Test Your Learning 10 min

Chart Fundamentals — Choosing the Right Chart 16 min
Column, Bar & Line Charts 16 min
Pie, Donut & Combo Charts 16 min
Modern Chart Types 16 min
KPI Design Principles 16 min
Interactivity: Slicers & Timelines 16 min
Dashboard Design Framework 18 min
Test Your Learning 10 min

Introduction to Power Query 16 min
Importing Data 18 min
Data Transformation 18 min
Merge & Append Queries 16 min
Automation Workflows 18 min
Test Your Learning 10 min

Why the Data Model? 16 min
Relationships & Star Schema Basics 18 min
Intro to DAX Measures 18 min
Power Pivot Dashboards 18 min
Test Your Learning 10 min

Recording Macros 16 min
VBA Basics 16 min
Variables & Loops 18 min
IF Statements & Logic in VBA 20 min
User Forms & Buttons 18 min
Automating Reports 18 min
Test Your Learning 10 min

Keyboard Shortcuts — Work at the Speed of Thought 18 min
Financial Functions & Modeling 20 min
Forecasting & Trends 20 min
What-If Analysis 18 min
Goal Seek & Solver 18 min
Protecting & Sharing Workbooks 18 min
Excel Best Practices 18 min
Interview & Real-World Tasks 18 min
Test Your Learning 10 min

Meet Copilot in Excel 16 min
Copilot for Formulas & Analysis 18 min
Copilot for Charts & Dashboards 16 min
ChatGPT as Your Excel Assistant 16 min
Verifying AI Output (Guardrails) 16 min
Test Your Learning 10 min

Final Capstone: NorthPeak Business Intelligence Dashboard 45 min
Appendix: Reference Library 15 min

Final Assessment & Certificate of Achievement

30 questions · 45 min · pass 70% · proctored

This course includes a Certificate of Achievement. Work through every lesson, then pass the timed, proctored final assessment to earn a verifiable certificate you can share on LinkedIn or add to your résumé.

  1. Enroll and complete all lessons
  2. Pass the final assessment (70% to pass)
  3. Earn your Certificate of Achievement

Requirements

  • No prior Excel experience needed — it starts from your first cell
  • Microsoft 365 / Excel on Windows (most lessons apply to Mac too)
  • A willingness to follow along with the NorthPeak Retail examples

Description

What you'll learn

A complete, story-driven Microsoft 365 Excel course that takes you from your very first cell to automated, AI-assisted business intelligence. Every one of the 74 lessons is set inside a real working year at NorthPeak Retail, a growing outdoor-gear company — so you learn each skill the moment you'd genuinely need it on the job.

The five levels

  1. Learn Excel (Sections 1–2) — foundations, confidence, formulas and functions.
  2. Clean & Analyze (Sections 3–4) — turn messy exports into trustworthy data, then sort, filter, Table, and pivot it.
  3. Lookups & Power Functions (Sections 5–6) — VLOOKUP, INDEX/MATCH, XLOOKUP, dynamic arrays, LET and LAMBDA.
  4. Dashboards, Automation & BI (Sections 7–10) — charts and dashboards, Power Query, Power Pivot and DAX, and VBA macros.
  5. Pro & AI (Sections 11–12) — senior-analyst polish, financial modeling, and using Copilot and ChatGPT for Excel the right way.

Capstone & reference

The course ends with a full capstone project — clean, model, automate and present a 100,000-row NorthPeak dataset as an executive dashboard — plus an appendix reference library of shortcuts, functions, and error fixes to keep open while you work.

Who this is for

Anyone who wants to truly master Excel — students, office professionals, analysts, and career changers. Start at zero; finish as the person everyone forwards their spreadsheets to.

Topics covered

beginners excel spreadsheets data-analysis microsoft-365 power-query business-intelligence
Your instructor
M

Mariam Saleh

Data Analytics & Excel Specialist · 9 yrs · Analytics Consultant, Brightline

4.0 course rating 1 courses

Mariam has spent nine years turning messy spreadsheets into decisions executives can trust. She trains analysts and operations teams to get genuinely fast in Excel — formulas, PivotTables, Power Query and dashboards — without ever reaching for a manual.

4.0 course rating · 19 ratings

J
Jermaine Lynch
11 months ago

It is okay. Helpful if you are starting out, though intermediate learners may not get as much from it.

Helpful?
  • Report this review
M
Mohamed McClure Jr.
1 year ago

Really solid course. A couple of sections felt a little rushed, but overall excellent value.

Helpful?
  • Report this review
J
Jillian Simonis Jr.
8 months ago

Five stars without hesitation. Everything is explained simply and there is real substance behind it.

Helpful?
  • Report this review
R
Roderick Bergnaum
1 year ago

It is okay. Helpful if you are starting out, though intermediate learners may not get as much from it.

Helpful?
  • Report this review

Frequently asked questions

Yes — once you enroll, the course is yours to revisit forever. New revisions and bonus lessons are added at no extra cost.

Yes — this course includes a Certificate of Achievement. Complete every lesson, then pass the timed, proctored final assessment to earn a shareable, verifiable certificate you can post on LinkedIn or include with job applications.

If the course isn't a fit, request a refund within 7 days of purchase — no questions asked.

Code, slides, and worksheets are downloadable on each lesson page. Videos stream from our CDN so you can watch on any device.

Each course states its level in the hero. If you're comfortable with the prerequisites listed, you're ready to start.

Students also bought

₹149 ₹399
Sign up to buy