Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Complete Excel Pivot Tables Course: Beginner to Advanced
Rating: 4.5 out of 5(516 ratings)
2,261 students

The Complete Excel Pivot Tables Course: Beginner to Advanced

Learn and Master Pivot Tables in Excel with this Beginner to Advanced course from Microsoft experts, Simon Sez IT!
Created bySimon Sez IT
Last updated 3/2023
English

What you'll learn

  • Cleaning and preparing your data
  • How to create PivotTables
  • Using the fields pane and adding fields and calculated fields
  • How to use the value field settings
  • Formatting numbers in PivotTable
  • Different ways to summarize data
  • Grouping and ungrouping PivotTable data and dealing with errors
  • Using multiple fields and dimension
  • Methods of aggregation
  • Choosing and locking the report layout
  • How to format PivotTables and apply styles
  • Basic to advanced sorting and filtering
  • Creating PivotCharts and adding sparklines and slicers
  • Selecting the right chart to present your data
  • Adding slicers and timelines and applying them to multiple tables
  • Combining data from multiple worksheets for a PivotTable
  • All about the GETPIVOTDATA function
  • How to use 3D maps from a PivotTable
  • Adding new data to the original source dataset
  • Updating your data in a PivotTable and PivotChart
  • Using conditional formatting in a PivotTable
  • How to create amazing dashboards

Course content

28 sections • 123 lectures • 15h 11m total length

  • Course Introduction5:10
  • WATCH ME: Essential Information for a Successful Training Experience2:11

    Access essential setup tips and downloadable exercise and instructor files for the complete excel pivot tables course, and learn to unzip files and adjust playback settings.

  • DOWNLOAD ME: Course Exercise Files0:23
  • DOWNLOAD ME: Course Support Files0:23
  • What are Pivot Tables and Why are They Useful?6:12

    Pivot tables provide a dynamic, interactive way to summarize large datasets, letting you move fields, sort by totals, filter top results, and reveal trends with pivot charts.

  • Section Quiz

Requirements

  • 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.
  • Basic to intermediate knowledge of Microsoft Excel is beneficial.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**


Data analysis is essential in today’s data-driven world. Data is crucial in understanding businesses, analyzing trends, and forecasting your business needs. It is crucial that you have the relevant skills to handle and analyze data efficiently.


PivotTable is a vital Excel skill for big data analysis and visualization jobs. PivotTables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating datasets, letting you analyze the information in a clear and effective manner.


This course will discuss the importance of cleaning your data before creating your first PivotTable. You will also learn how to create PivotCharts and format your PivotTables and charts. We teach you how to make the most of this powerful data analysis tool by using some of its advanced features, including advanced sorting, slicers, timelines, calculated fields, and conditional formatting.


This course is aimed at those brand new to PivotTables and also intermediate users looking to expand their Excel skills. You can download the Excel data files that the instructor uses in the tutorials so you can readily follow along.


This course covers:

  • Cleaning and preparing your data

  • How to create PivotTables

  • Using the fields pane and adding fields and calculated fields

  • How to use the value field settings

  • Formatting numbers in PivotTable

  • Different ways to summarize data

  • Grouping and ungrouping PivotTable data and dealing with errors

  • Using multiple fields and dimension

  • Methods of aggregation

  • Choosing and locking the report layout

  • How to format PivotTables and apply styles

  • Basic to advanced sorting and filtering

  • Creating PivotCharts and adding sparklines and slicers

  • Selecting the right chart to present your data

  • Adding slicers and timelines and applying them to multiple tables

  • Combining data from multiple worksheets for a PivotTable

  • All about the GETPIVOTDATA function

  • How to use 3D maps from a PivotTable

  • Adding new data to the original source dataset

  • Updating your data in a PivotTable and PivotChart

  • Using conditional formatting in a PivotTable

  • How to create amazing dashboards


This course bundle includes:

  1. 13+ hours of video tutorials

  2. 100+ individual video lectures

  3. Certificate of completion

  4. Course and exercise files to follow along

Who this course is for:

  • 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
  • Beginner Excel users who want to learn how to use Pivot Tables

Report abuse