Pivot Tables Courses and Certifications

Microsoft Master Certification

10887 ratings at CreativeLive

Excel-focused Microsoft certification program covering formulas, charts, pivot tables, macros, and reporting, alongside exams for Excel, PowerPoint, Word, and Outlook.

• CreativeLive
• Self-Paced
• Paid Course

Simon Sez IT

Pivot Table Excel Tutorial

1 rating

A beginner walkthrough of turning raw Excel data into refreshable PivotTables and PivotCharts with slicers.

• YouTube
• 52 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

Use Excel PivotTables and Power Query to import, transform, group, and summarize categorical and quantitative data as frequency distributions.

• YouTube
• 36 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Data Analysis - PivotTables, Power Query, Formulas and Charts

Learn to import sales data with Power Query, build PivotTable reports with formulas, chart trends, and refresh analyses when new data arrives.

• YouTube
• 36 minutes
• Self-Paced
• Free Video

ExcelIsFun

PivotTables & Slicers - Create Dashboards & Summary Reports

Build Excel PivotTable dashboards, frequency distributions, and percentage reports using slicers and Show Values As.

• YouTube
• 29 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As

Use PivotTables, slicers, and Show Values As calculations to build and interpret flexible cross-tabulated reports.

• YouTube
• 40 minutes
• Self-Paced
• Free Video

ExcelIsFun

PivotTables Instantly Update When Source Data Change - Just Like Formulas - Excel Magic Trick 1900

Master Excel's revolutionary PivotTable Auto Refresh feature that instantly updates when source data changes, eliminating manual refreshes and making PivotTables behave like formulas.

• YouTube
• 13 minutes
• Self-Paced
• Free Video

PwC

Problem Solving with Excel

5 ratings

Solve business problems in Excel: use formulas and subtotals, VLOOKUP and text cleansing, logical functions, pivot tables, index match, and statistical and financial formulas.

• Coursera
• 4 weeks, 5 hours a week
• Self-Paced
• Paid Course

Data Analysis in Excel

5298 ratings at DataCamp

Exploring PivotTables You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Data Visualization in Excel

4524 ratings at DataCamp

Building basic Charts You will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types.

• DataCamp
• 3 hours
• Self-Paced
• Free Trial Available

Career Certificate

Excel Level II: Intermediate

3755 ratings at Noble Desktop

Use VLOOKUP, XLOOKUP, IF, SUMIFS and COUNTIFS, summarize databases with PivotTables, split and join text, and restrict entries with data validation.

• Noble Desktop
• 6 hours
• Self-Paced
• $299.00

Career Certificate

Excel Level III: Advanced

1952 ratings at Noble Desktop

Build nested IF and INDEX-MATCH formulas, run Goal Seek and data tables, extend pivot tables with calculations and pivot charts, record macros, and use dynamic arrays.

• Noble Desktop
• 6 hours
• Self-Paced
• $299.00

Data Analysis for Beginners: Excel & Pivot Tables

Learn Excel for data analysis: split text to columns, import external data, build structured tables and named ranges, and create pivot tables with filters and slicers.

• Zero To Mastery
• 2 hours
• Self-Paced
• Paid Course

Introduction to Data Analysis Using Excel

10511 ratings at Coursera

Learn to analyze data in Excel: import various file formats, use IF, nested IF, VLOOKUP and HLOOKUP, filter data, and build pivot tables, histograms and scatter plots.

• Coursera
• 4 weeks, 6 hours a week
• Self-Paced
• Paid Course

Simon Sez IT

Microsoft Excel PivotTables Explained

Learn to build and customize Excel PivotTables to reorganize, summarize, format, group, and analyze large datasets, with a practical exercise.

• YouTube
• 49 minutes
• Self-Paced
• Free Video