On demand · Intermediate

Excel for business analysis

From raw data to clear answers

4 lessons

Turn messy spreadsheets into reliable answers. Clean data, summarise it with pivot tables and present the result in a chart your manager understands at a glance.

What you will be able to do

  • Clean and structure raw data
  • Summarise data with pivot tables
  • Choose the right chart for the message

Course content

Welcome

  1. Start with a questionReading · Preview

Working with data

  1. Clean your data firstReading + Activity
  2. Summarise with pivot tablesReading

Wrap up

  1. Choose the right chartReading