Skip to content
Sabaqاردو

Excel Pivot Tables (Leila Gharani)

By Leila Gharani

Course audio
Course audio: English
Level
Intermediate
Length
11 lessons · 2.2 hours

What you'll be able to do

  • Build and reshape pivot tables quickly
  • Combine several sheets or tables with the Data Model
  • Add pivot charts, slicers and date grouping
  • Format pivot reports that are easy to read

About this course

Eleven focused pivot table tutorials from Leila Gharani, about 2 hours. It starts with pivot tables explained in ten minutes, then consolidating and cleaning several sheets into one pivot table, building a pivot from multiple tables with the Data Model, pivot charts with slicers, icons in slicers, advanced techniques, grouping dates and handling missing dates, features people miss, common mistakes and how to fix them, and formatting pivot tables so reports look professional. Ideal for office staff, accountants and analysts in Pakistan who build monthly summaries and want to stop doing them by hand.

Before you start: Excel basics

Syllabus

11 lessons · 2:11:50 in total

  1. 1Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)13:22
  2. 2Consolidate & Clean Multiple Excel Sheets in One Pivot Table9:06
  3. 3Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel10:40
  4. 4Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names11:48
  5. 5How to Use Symbols and Icons Instead of Text in Excel Slicers11:22
  6. 6Advanced Pivot Table Techniques (to achieve more in Excel)11:47
  7. 7Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!11:02
  8. 8Master Excel Pivot Table Dates: Grouping, Missing Dates & Power Pivot13:54
  9. 9Common Excel Pivot Table Features People Miss (and you?)12:45
  10. 10Pivot Table Mistakes You're Probably Making (And How to Fix Them!)9:45
  11. 11Stop Sending Ugly Pivot Tables to Your Boss16:19

What to take next

Related courses

Videos by Leila Gharani, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Lessons listed from the official YouTube playlist. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request