❗The content presented here is sourced directly from Youtube 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 2+ hour Excel tutorial video provides a detailed overview of Pivot Tables for beginners. In this course, learners will gain an understanding of the importance of cleaning data to be used in Pivot Tables. They will learn how to prepare data by removing blank rows and duplicates, clear formatting in Excel, merging and splitting columns, and converting numbers stored as text.
Learners will also learn how to create and format Excel tables and how to create Pivot Tables from scratch or by using the Recommended Pivot Tables option. Different Pivot Table layout options and how to lock the report layout will be discussed. Learners will also learn how to add Pivot Table fields, ways to summarize data, and how to group data.
The course includes downloadable course files so learners can follow along and practice what they are learning. By the end of the course, learners will have a comprehensive understanding of Pivot Tables in Excel.
