Log On/Register  

855.838.5028

Excel 2013: Pivot Tables

Duration: 1 Day
Module Price: $130

Module 1: Creating and Managing Pivot Tables 

Pivot Tables Basics 

  • 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 

  • 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 
  • Using OLAP Tools 
  • Creating Sets 

Preview: Power Maps, Power View &  Power BI  

Module 1: Creating and Managing Pivot Tables 

Pivot Tables Basics 

  • 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 

  • 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 
  • Using OLAP Tools 
  • Creating Sets 

Preview: Power Maps, Power View &  Power BI  

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):