❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 18th, 2023]

This course provides an overview of Excel Pivot Tables and is designed to help users gain a comprehensive understanding of the powerful tool. It starts by introducing the fundamentals of Pivot Tables and presents the topics in short, fun, easy to follow videos. The course then moves into working with calculations/ formulas, the ever cool slicer, charting and concludes with some miscellaneous topics.

No previous experience with Excel is required to take this course, as long as the user is able to select cells on a spreadsheet, has a basic understanding of formulas in Excel, is able to navigate between sheets and is somewhat familiar with sorts and filters. The course was created using Excel 2019, but can be used with Excel 2016/ 2019 or Office 365 (primarily for PC/Windows). Mac users are welcome, but be aware their screen will be somewhat different.

By the end of the course, users will have the skills to read and analyze data, and be competent with Pivot Tables, which can give them the extra advantage in developing their career.

Course Syllabus

Course Intro and Format | Important! :)

Pivot Tables | The Fundamentals

Working with calculations in pivot tables

Intro to slicers

Pivot Table Charts

Miscellaneous, yet relevant topics :)

The 4 Minute Dashboard

Homework?? And thank you so very much!