Analyzing Data With Pivot Tables in Excel - Online Course


January 2022

Analyzing Data With Pivot Tables in Excel - Online Course

If you are new to pivot tables, this guide will walk you through your first pivot table. If you are a pivot table pro, the guide provides a deep dive into many cool techniques for pivot tables.

Bill Jelen, MrExcel

category: Pivot Table
covers: Excel

Product Details
  • 2 hours
  • Publisher: Holy Macro! Books

Bill Jelen has rolled all of his favorite Excel Pivot Table tips and techniques into a new guide on the Retrieve platform.

If you are new to pivot tables, this guide will walk you through your first pivot table.

If you are a pivot table pro, the guide provides a deep dive into many cool techniques for pivot tables.

If there’s something specific you’d like to follow or learn, just ask the search bar—it will take you right to it. If you get stuck or need some advice directly from me you can ask me anything with a direct message.

Watch Video

  • Setting Up Your Data for Pivot Tables
  • Creating Your First Pivot Table
  • Top Ten Report
  • Year over Year Report
  • Cool Uses for Pivot Tables
  • Join Data from Two Tables
  • More Data Model Tricks
  • Filtering With Slicers
  • Uses for GetPivotData
  • Calculations in Pivot Tables
  • Adding More Data / Formatting the Report
  • Filtering Dates with Timeline Slicers
  • Slicer from Two Data Sets
  • Pivot Charts / Artificial Intelligence
  • Pivot Table on a Map

Where to Buy

MrExcel on Retrieve

Online course from MrExcel.

MrExcel on Retrieve

Get all four Excel guides for a reduced price when you bundle them together.


Related Products


Advanced Excel Techniques - Online Course

January 2022

Understanding data is crucial, and the easiest place to start is with Microsoft Excel. In this guide, I've compiled advanced skills and formulas in Excel that you should know to analyze and understand your data easier and faster.


Saving Time with Excel - Online Course

January 2022

Be more efficient in Excel with these time-saving techniques in Excel.


Ace Your Job Interview Where You Have to Know Excel - Online Course

January 2022

You have a job interview this afternoon where you have to know Excel? This short video course will teach you enough Excel skills to get through the interview.