Excel Pivot Tables Tutorial - Data Analysis Skills for Consultants

In this Excel Tutorial on Pivot Tables you will learn a key data analysis skill for consultants. Pivot tables are a key feature of Microsoft Excel and Office 365 to conduct effective data analyses. This Excel Pivot Tables tutorial for beginners contains key tips to effectively use Pivot Tables at work. Learn how to use Pivot Tables with advanced Pivot Tables tips such as calculated fields and building dashboards with Pivot Tables in Microsoft Excel. This video explains Pivot Tables for dummies, learn Pivot Tables with this video.

Download the Pivot Tables data set from the video:
https://link.firmlearning.com/pivottables

Chapters
00:00 Power of Pivot Tables
01:16 Getting to know the data set
02:14 Creating the first Pivot Table
03:32 Using Values, Rows, Columns and Filters
09:37 Creating standardized tables with Pivot
11:39 Calculated Fields for advanced analyses
16:00 Building Dashboards with Pivot Tables

#excel #pivottable #dataanalysis