Excel Pivot Tables

Who should attend

  • Microsoft Excel (2010, 2013, 2016), ideally for PC
  • Mac users are welcome, but note that the Pivot Table interface varies across platforms
  • Basic experience with Excel functionality (charts & formulas a plus!)
Team Pass by Learnit

Excel Pivot Tables

From $0
Two, 2-hour Modules (9am - 11:30am PT)

This live online interactive Excel Pivot Tables course will take you from beginning to advanced data analysis techniques. Participants will learn how to properly organize data; analyze and summarize data quickly using data mining techniques, VLOOKUP and PivotTables; develop savvy visualizations with PivotCharts; and analyze data across multiple worksheets and data sets through PowerPivot and data modeling.

Course ID
EXCELPbuip
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Module 1: Creating and Managing Pivot Tables Pivot Tables Basics

Learning Outcomes:

1. Organize and clean data in spreadsheets for pivotable analysis

2. Managing and updating pivotable source data to display new values.

3. Editing pivotable report formats and settings

  • Organizing Data
  • Inserting Pivot Tables
  • Data Categories
  • List Design Guidelines Data Normalizing Strategies
  • Common Data Mining Techniques
  • Standardizing Data
  • Adding Related Data with VLOOKUP Function Managing Pivot Tables
  • Naming Pivot Tables
  • Refreshing and Changing Pivot Table Data
  • Layering Fields of Data
  • Filtering and Slicing Pivot Table Data
  • Functions and Number Formats
  • Show Details of Specific Pivot Table Results Creating Pivot Charts
  • Pivoting Data Fields
  • Basic Chart Formatting
  • Filtering and Slicing Pivot Chart Data

Module 2: Advanced Pivot Table Strategies Custom Pivot Table Design

Learning Outcomes:

1. Use PowerPivot to connect data sources

2. Format default layout for pivotable reports

3. Create a data model and pull data in from various tables for pivotable analysis

  • Analysis Tables vs. Data Lists
  • Choosing Report Layouts
  • Using and Creating Table Styles
  • Subtotals and Grand Totals
  • Pivot Table Options
  • Calculated Fields and Items Power Pivot?
  • Data Modeling Basics
  • Adding Data to Model
  • Creating Relationships
  • Designing Measures
  • Adding Custom Columns
  • Using Basic DAX Expressions?Power Pivot Tables
  • Creating Power Pivot Tables
  • Preview of Power Query & Power BI

Skills covered

No items found.