Skip to content
Online
Campus
ucademy.ca
  1. Campus
  2. Courses
  3. Excel for the Office: Pivot Tables, Lookups and Charts
Free courseBusiness & Administration

Excel for the Office: Pivot Tables, Lookups and Charts

Go beyond Excel basics: prepare data, build pivot tables, look up values with XLOOKUP, VLOOKUP and INDEX with MATCH, and present results in clear charts. Five short lessons and a quiz, with a certificate of completion.

60minutes
5lessons
1final quiz
Freecertificate of completion

What you’ll be able to do

  • Prepare a list for analysis with Excel tables, cleaning steps and data validation
  • Build a pivot table and use Rows, Columns, Values and Filters to answer questions
  • Group dates, show percentages and add a slicer to a pivot table
  • Write lookups with XLOOKUP, VLOOKUP and INDEX with MATCH, and handle missing values
  • Choose a chart type for the question and avoid charts that mislead
  • Check totals against the source and assemble a one-page summary

Curriculum

01

Course lessons

5 lessons · module quiz
  1. 01Preparing data for analysisLesson
  2. 02Your first pivot tableLesson
  3. 03Pivot tables that answer questionsLesson
  4. 04Lookups: XLOOKUP, VLOOKUP and INDEX with MATCHLesson
  5. 05Charts and a one-page summaryLesson
  6. 06QUIZExcel for the Office: Final QuizQuiz