Beginner to Advanced Excel Pivot Tables and Pivot Charts

Learn everything you need to know to improve your analysis skills in using Excel Pivot Tables and Charts.

4.17 (9 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
85
students
2 hours
content
Mar 2024
last update
FREE
regular price

What you will learn

Learn how to create and use the various features of the Pivot Table

Learn what Excel Pivot Table can do for you in data analysis

Master Excel Pivot Table step by step with hands on engaging homework at the end of each section

Discover how to make and utilise Pivot Charts for Analysis in Excel.

Description

Excel Pivot Tables are a must-have tool for anyone who works with data in Excel.

Pivot tables allow you to quickly summarize and analyze data, revealing trends and valuable insights into your data that you would not have discovered otherwise. Excel Pivot tables will provide quick, accurate, and intuitive answers to the most difficult analytics questions.

This course will provide a thorough understanding of Excel Pivot Tables through a hands-on approach , ensuring that skills learned can be immediately applied to any Excel data analysis tasks.

I will start by taking you through everything you need to know in Excel Pivot tables which will include:

1) The data structure in Excel

2) Pivot Table layouts & styles

3) Design & formatting options

4) Sorting, filtering, & grouping tools

5) Calculated fields, items & values

6) Pivot Charts, slicers & timelines

The course is structured so that, depending on your learning needs, each section can be completed independently.

I chose to use both Excel 2007 and 365 to demonstrate that the course is applicable to any version of Excel.

If you want to improve your Excel skills or become someone who can turn data into meaningful insights, this course is for you. Enrol in this course and start your journey to becoming an Excel data analysis expert.

Hope to see you in class.




Content

Basics of the Pivot Table

Getting your data ready for Pivot Table
Creating the Pivot Table
Grouping and Ungrouping in Pivot Tables
Collapsing and Expanding in Pivot tables
Field Settings in Pivot Tables
Introduction to Slicers in Pivot Tables
Introduction to Timeline in Pivot Table
End of Section Practice Exercise
Solution to the Review Homework

Applying Filters in Pivot Tables

Date Filters in Pivot tables
Value Filters in Pivot Tables
Label Filters in Pivot Tables
End of Section Practice Exercise
Solution to the Review Homework

More on the Pivot Table Ribbon

Selecting, Clearing, Moving & Copying Pivot Tables
Refreshing & Updating Pivot Tables
Layout group on the ribbon
Layout in Pivot tables
Style options in Pivot Tables
Calculated field in Pivot Tables
Calculated field items in Pivot Tables
End of Section Practice Exercise
Solution to the Review Homework

Conditional Formatting in Pivot Tables

Introduction to Conditional formatting in Pivot Tables
Highlight cells rules
Top Bottom rules
Data bars, Color Scales and Icon Sets
New rule, clear rules and manage rules
End of Section Practice Exercise
Solution video to the review exercise

Practice Exercise HR Dataset

Introduction to the exercise
Exercise Video 1
Exercise Video 2
Exercise Video 3

Creating Dashboards in Pivot Tables

Introduction to Excel pivot table dashboards
Dashboard exercise video 2
Dashboard exercise video 3
Dashboard exercise video 4
Dashboard exercise (putting it all together)

Pivot Charts

Introduction to Pivot Charts
Inserting Pivot Charts
Combining pivot charts
Changing chart types in pivot charts
Basic data filtering in pivot charts
Formatting in pivot charts
End of Section Practice Exercise
Solution video to the review exercise

Case Study Exercises

Case Study 1 : US Mass Shootings Dataset
Case Study 2 : Olympics Athletes Dataset
Case Study 3 : US Police Officer Deaths Dataset
Case Study 4 : Work Safety Dataset

Screenshots

Beginner to Advanced Excel Pivot Tables and Pivot Charts - Screenshot_01Beginner to Advanced Excel Pivot Tables and Pivot Charts - Screenshot_02Beginner to Advanced Excel Pivot Tables and Pivot Charts - Screenshot_03Beginner to Advanced Excel Pivot Tables and Pivot Charts - Screenshot_04

Charts

Price

Beginner to Advanced Excel Pivot Tables and Pivot Charts - Price chart

Rating

Beginner to Advanced Excel Pivot Tables and Pivot Charts - Ratings chart

Enrollment distribution

Beginner to Advanced Excel Pivot Tables and Pivot Charts - Distribution chart
4375798
udemy ID
10/31/2021
course created date
11/23/2022
course indexed date
Bot
course submited by