Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

Overview

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779 What you'll learn:

Create Pivot Tables with a just a few clicks, simply and quickly.Maintain and expand Pivot Tables.Update data sources, and maintain formatting during refreshes.Create Pivot Charts in a few simple clicks.Know and use about the more advanced features, and create advanced Pivot Tables.Find out how much powerful it is, and how quickly it can improve your data analysis.

Review:

"The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right.

And going thru the exercises after each one is great. I only have one word for the teacher and the way he's presenting the course WOW!!!" -- Daniel SandbergThis course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.Please note:

This course is not affiliated with, endorsed by, or sponsored by Microsoft.It sounds difficult, but in fact can be done in just a few clicks.

We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.After only thesefirst few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you.

We will go into advanced options that most people don't even know about, but which are very useful.By the end, you will be an Expertuser of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly,and you'll beable to help others with their data analysis.

Syllabus

• Introduction to Pivot Tables
Overview of Pivot Tables
Benefits of using Pivot Tables in Excel
• Creating Pivot Tables
Preparing data for Pivot Tables
Steps to create a basic Pivot Table
Field list and areas (Rows, Columns, Values, Filters)
• Customizing Pivot Tables
Changing summary calculations (Sum, Average, Count)
Sorting and filtering data within Pivot Tables
Grouping data
• Design and Layout Options
Pivot Table styles and formatting
Customizing the layout (Compact, Outline, Tabular)
Using the Design tab for visual customization
• Advanced Pivot Table Techniques
Calculated fields and items
Using slicers and timelines for dynamic filtering
Analyzing data with GetPivotData function
• Handling Multiple Data Sources
Creating Pivot Tables from multiple tables/ranges
Exploring the Data Model in Excel
Relationships between data tables
• Pivot Charts
Introduction to Pivot Charts
Creating and customizing Pivot Charts
• Common Challenges and Troubleshooting
Dealing with common Pivot Table errors
Best practices for maintaining and updating Pivot Tables
• Case Studies and Practical Applications
Real-world scenarios demonstrating Pivot Table applications
• Review and Mastery Test
Comprehensive review of key concepts
Mastery test to assess understanding and application
• Additional Resources and Further Reading
Links to online resources for continued learning
Recommended books and courses for advanced study

Taught by

Phillip Burton • 800,000+ students so far and I Do Data Limited

Subjects

Data Science