Coming soonBusiness, Finance & CareerGrowth

Excel for Managers — Pivot Tables, Dashboards, Automation

Stop being intimidated by Excel. Six sessions take you from VLOOKUP to a one-click monthly dashboard your CEO actually opens. Includes Power Query and a touch of Power Pivot.

About this course

Most managers use 5% of Excel and miss the part that turns a spreadsheet into an actual analysis platform. We cover what real analysts use daily: pivot tables that don't break when data changes, Power Query for cleaning messy CSVs from any source, INDEX/MATCH/XLOOKUP, and a final dashboard project — all the KPIs your team cares about, on one tab, refreshable in one click.

What you'll cover

1
Excel re-orientation — clean data, clean output
Tables vs ranges. The 5 worst Excel habits. Naming, formatting, structure.
2
Lookups that actually work — XLOOKUP and friends
VLOOKUP why it's dying. XLOOKUP, INDEX/MATCH. Approximate vs exact.
3
Pivot tables — beyond drag-and-drop
Pivot caches, calculated fields, slicers. The 'show as %' tricks.
4
Power Query — clean any CSV
Connect, transform, refresh. The ETL pipeline inside Excel.
5
Charts that don't lie
Bar, line, combo. Why pie charts are usually wrong. Sparklines.
6
Dashboard project — start to finish
Build a real monthly dashboard. KPIs. Refreshable. CEO-ready.

Who it's for

Managers preparing reports for executives, business analysts moving up, finance team members, and operations professionals.

Prerequisites

Comfortable with basic Excel (you've used SUM, COUNT, IF). Excel 2019 or later, Microsoft 365 ideal.

Skills you'll build

Excel
Power Query
pivot tables
XLOOKUP
dashboards
Power Pivot
data analysis
Microsoft 365

Who we're looking for

Open call · Apply to teach

Required skills

Excel
Power Query
pivot tables
XLOOKUP
dashboards
Power Pivot
data analysis
Microsoft 365

Experience

3+ years professional experience

Languages

English or Arabic (both a plus)

Time commitment

8 sessions × 90 min over 6 weeks

Compensation

80% of seat revenue (Tahout takes 20%)

If your CV matches, apply to teach. We use AI to rank applicants by fit, then admin reviews and approves the right instructor(s).