Mastering Excel Pivot Tables and Pivot Charts

Name: Mastering Excel Pivot Tables and Pivot Charts
Rating: 4.5 (254 reviews)

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

Created byNasiru Musa

Last updated 12/2024

English

What you'll 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.

Course content

5 sections • 37 lectures • 2h 2m total length

Introduction & Course Content1:32
Getting your data ready for Pivot Table4:23
Format your data with headers and proper types, identify and fix issues like missing field names, blank or merged cells, then create a pivot table on a new worksheet.
Creating the Pivot Table3:31
Grouping and Ungrouping in Pivot Tables3:09
Collapsing and Expanding in Pivot tables1:37
Field Settings in Pivot Tables4:40
Introduction to Slicers in Pivot Tables7:18
Introduction to Timeline in Pivot Table6:42
End of Section Practice Exercise0:16
Solution to the Review Homework2:13
Review the solution to the homework for mastering excel pivot tables and pivot charts. Reinforce your understanding of pivot tables and pivot charts through this focused review.

Date Filters in Pivot tables6:04
Explore date filters in pivot tables, using the row labels dialog and options like is between and is after, with examples from 2010–2012 and all dates in the period.
Value Filters in Pivot Tables3:37
Label Filters in Pivot Tables3:52
Explore label filters in pivot tables to filter text using begins with and contains, refine regions and countries, and learn how to clear filters.
End of Section Practice Exercise0:58
Solution to the Review Homework6:40

Selecting, Clearing, Moving & Copying Pivot Tables3:38
Refreshing & Updating Pivot Tables3:29
Layout group on the ribbon4:18
Layout in Pivot tables0:52
change the pivot table layout by adjusting the form and how fields, columns, and rows appear, and apply banded rows or conditional formatting for readability.
Style options in Pivot Tables2:11
Apply and combine pivot table style options to format your pivot table, including row headers, column headers, and banded rows or columns, and choose different style designs.
Calculated field in Pivot Tables1:48
Calculated field items in Pivot Tables3:24
End of Section Practice Exercise0:56
Solution to the Review Homework7:10

Introduction to Conditional formatting in Pivot Tables1:02
Discover how conditional formatting in pivot tables highlights trends and key values with bars, colors, and icons, using predefined rules or formulas to analyze data.
Highlight cells rules1:34
Apply conditional formatting to a pivot table by using highlight cells rules to identify low profits. Highlight cells less than 70 million with chosen color and explore other rule options.
Top Bottom rules1:21
Data bars, Color Scales and Icon Sets2:00
New rule, clear rules and manage rules3:51
End of Section Practice Exercise0:50
Solution video to the review exercise7:01

Requirements

Basic navigation of the excel environment
Microsoft Excel 2007-2019 or Office 365 (ideally for PC/Windows)

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.

Who this course is for:

Anyone who works with Excel on a regular basis and wants to refresh or update their skills.
Anyone wishing to work in data analysis, where proficiency with Excel is necessary,
Students whose academic work requires proficiency in Excel

Mastering Excel Pivot Tables and Pivot Charts

What you'll learn

Explore related topics

Course content

Basics of the Pivot Table10 lectures • 35min

Applying Filters in Pivot Tables5 lectures • 21min

More on the Pivot Table Ribbon9 lectures • 28min

Conditional Formatting in Pivot Tables7 lectures • 18min

Pivot Charts6 lectures • 21min

Requirements

Description

Who this course is for: