0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Excel

Advanced PivotTables in Excel

Take your data analysis skills to new heights with this Advanced course on Pivot Tables in Excel

4.7
(398 ratings) 863 students



Enroll now


What you will learn

How to create amazing looking dashboards using Pivot Tables
Advanced data analysis techniques
How to do a PivotTable (a quick refresher)
How to format a PivotTable, including adjusting styles
Advanced Sorting and Filtering in PivotTables
How to use 3D Maps from a PivotTable
How to update your data in a PivotTable and Pivot Chart
Advanced Sorting and Filtering in PivotTables

Who should take this training

Prerequisites

  • Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows.
  • All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
  • Intermediate knowledge of Microsoft Excel.

Target audience

  • Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge. People looking to perform Data Analysis using Excel

About this training

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel.

In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting.

This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel. If you are new to Excel, try out one of the Simon Sez IT Beginner Excel courses also available on Udemy.

This course includes:

  1. 7+ hours of video tutorials

  2. 50 individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion

This course was recorded using Excel from Office 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013, 2016, and 2019.

 

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 550

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 1040 $ 963

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 1590 $ 1272

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction
1. Introduction to Advanced PivotTables 03:49 mins
2. PivotTables Recap 12:44 mins
Course Introduction
PivotTables Recap
2. Importing Data
1. Importing data from a text file 09:58 mins
2. Importing data from Access 08:20 mins
Exercise 01 04:46 mins
Sales Data
3. Preparing Data for Analysis
1. Cleaning Data 17:40 mins
2. Tabular Data 16:06 mins
Exercise 02 03:18 mins
Sample Sales Data
4. Creating and Manipulating PivotTables
1. Creating and Manipulating a PivotTable 12:27 mins
2. Combining Data from Multiple Worksheets 12:02 mins
3. Grouping and Ungrouping 11:02 mins
4. Report Layouts 10:53 mins
5. Formatting Error Values and Empty Cells 08:27 mins
Exercise 03 01:35 mins
Sample Sales Data - Grouping
Sample Sales Data - Error Values
Sample Sales Data - Clean
Consolidating
5. Formatting PivotTables
1. PivotTable Styles 11:39 mins
2. Custom Number Formatting 16:25 mins
Exercise 04 01:44 mins
Sample Sales Data - Styles 1
Sample Sales Data - Styles 2
Sample Sales Data - Custom Number Formatting
6. Value Field Settings
1. Summarizing Values By 11:25 mins
2. Show Values As 09:12 mins
Exercise 05 01:47 mins
Sample Sales Data - Summarizing Values
Sample Sales Data - Show Values As
7. Sorting and Filtering
1. Advanced Sorting 08:41 mins
2. Advanced Filtering 14:04 mins
Exercise 06 02:17 mins
Sample Sales Data - Sorting
Sample Sales Data - Filtering
Tech Sales - Filtering
8. Interacting with PivotTables
1. Inserting and formatting Slicers 13:52 mins
2. Inserting and formatting Timelines 07:06 mins
3. Connecting Slicers to multiple PivotTables 08:10 mins
4. Using Slicers in Protected Workbooks 05:36 mins
Exercise 07 02:21 mins
Tech Sales - Slicers
Tech Sales - Timeline
Tech Sales - Connecting Slicers
Tech Sales - Protection
9. Calculations
1. Creating a Calculated Field 08:25 mins
2. Creating a Calculated Item 08:10 mins
3. Solve Order and List Formulas 10:38 mins
4. GETPIVOTDATA 09:26 mins
Exercise 08 06:41 mins
Tech Sales - Calculated Fields
Tech Sales - Calculated Items
Orders and Returns - Solve Order
Sample Sales Data - GETPIVOTDATA
10. Pivot Charts
1. Creating a Pivot Chart 11:31 mins
2. Formatting a Pivot Chart - Part 1 15:43 mins
3. Formatting a Pivot Chart - Part 2 15:29 mins
4. Creating a Map Chart using Pivot Data 12:02 mins
5. Dynamic Chart Titles 13:50 mins
6. Include a Sparkline with your PivotTable 10:40 mins
Exercise 09 07:46 mins
Tech Sales - Pivot Charts
Tech Sales - Formatting Pivot Charts 1
Tech Sales - Formatting Pivot Charts 2
Power Stations - Map Charts
Tech Sales - Dynamic Chart Labels
Tech Sales - Sparklines
11. Conditional Formatting
1. Highlighting Cell Rules 09:33 mins
2. Graphical Conditional Formats 10:07 mins
3. Conditional Formatting and Slicers 06:29 mins
Exercise 10 02:26 mins
Tech Sales - Highlighting Cells
Tech Sales - Graphical Conditional Formats
Tech Sales - Conditional Formatting with Formulas
12. Dashboards
1. Creating an Interactive Dashboard - Part 1 23:12 mins
2. Creating an Interactive Dashboard - Part 2 13:55 mins
3. Updating Data 04:24 mins
Exercise 11 03:26 mins
Tech Sales - Dashboard
Tech Sales - Completed Dashboard
Tech Sales - Updating Data
13. Course Close
Course Close 00:38 mins

Request more information

Similar courses

Join our mail list for news