Excel for Analysts: Zero to Confident

Master formulas, lookups, pivot tables and charts by building four real reports.

  1. Welcome and the Excel mindset
  2. Formulas that matter: SUM, IF, XLOOKUP
  3. Pivot tables in 20 minutes
  4. Charts and your first dashboard

Pivot tables in 20 minutes

Select your table, Insert ? PivotTable. Drag Category to Rows, Amount to Values. Group dates by month.

Log in to track progress and earn a certificate.