Home / Course catalog / Excel level 2 – 3 Weekly summa... (Bus_Excel_02-03)

Business tools

Excel level 2 – 3 Weekly summaries with pivot tables (Bus_Excel_02-03)


Description

This module helps learners build weekly and monthly summaries quickly without manual counting or heavy copy‑paste. It directly addresses the need to generate meeting summaries, payment follow‑up recaps, and planning or occupancy summaries by using pivot tables that can be refreshed when new data arrives.

Content
  • Introduction to Pivot Tables - Preparing Your Data
  • How to creaete pivot tables
  • Pivot tables
  • Optional : Sorting a pivot table
  • Optional : Group pivot table data
  • Put Your Pivot Table to Work
  • Optional : How to add and use a pivot table calculated field
  • Pivot Charts
Completion rules
  • All units must be completed