< Introduction to PivotTables in Excel

43 casts | 2:57:50 for the total course

created by Mammoth Interactive INC

• 1. Introduction to the Course
  • Introduction to PivotTables in Excel | 1.1 Introduction To The Course

  • Introduction to PivotTables in Excel | 1.2 Why Should You Learn Pivot tables

  • Introduction to PivotTables in Excel | 1.3 Introduction Of The Instructor

  • Introduction to PivotTables in Excel | 1.4 Course Requirements (what Software, Experience)

• 2. PivotTables Fundamental Projects

  • Introduction to PivotTables in Excel | 2.1 What We Learn In This Section

  • Introduction to PivotTables in Excel | 2.2 What Is A Pivot Table

  • Introduction to PivotTables in Excel | 2.3 Pivottables Basics

  • Introduction to PivotTables in Excel | 2.4 Pivottable Compliant Data Sources

  • Introduction to PivotTables in Excel | 2.5 Build A Basic Pivottable

  • Introduction to PivotTables in Excel | 2.6 Section Summary

  • Introduction to PivotTables in Excel | 2.7 Challenge

• 3. Format PivotTables

  • Introduction to PivotTables in Excel | 3.1 What Will We Learn In This Section

  • Introduction to PivotTables in Excel | 3.2 Introduction To Formatting Pivottables

  • Introduction to PivotTables in Excel | 3.3 Build An Expense Report

  • Introduction to PivotTables in Excel | 3.4 Format The Expense Report Pivottable

  • Introduction to PivotTables in Excel | 3.5 Finalize The Expense Report Pivottable

  • Introduction to PivotTables in Excel | 3.6 Section Summary

  • Introduction to PivotTables in Excel | 3.7 Challenge

• 4. Excel Tables

  • Introduction to PivotTables in Excel | 4.1 What Will We Learn In This Section

  • Introduction to PivotTables in Excel | 4.2 What Are Excel Tables

  • Introduction to PivotTables in Excel | 4.3 Sales Report Analysis With Pivottables

  • Introduction to PivotTables in Excel | 4.4 Modify Source Data

  • Introduction to PivotTables in Excel | 4.5 Format The Sales Report

  • Introduction to PivotTables in Excel | 4.6 Complete The Sales Report Analysis

  • Introduction to PivotTables in Excel | 4..7 Section Summary

  • Introduction to PivotTables in Excel | 4.8 Challenge

• 5. Slice and Dice Your Data

  • Introduction to PivotTables in Excel | 5.1 What Will We Learn In This Section

  • Introduction to PivotTables in Excel | 5.2 What Is Slicing Data

  • Introduction to PivotTables in Excel | 5.3 Slicing Data Project

  • Introduction to PivotTables in Excel | 5.4 Data Slicer Tools

  • Introduction to PivotTables in Excel | 5.5 Link Slicers To Multiple Pivottables

  • Introduction to PivotTables in Excel | 5.6 Section Summary

  • Introduction to PivotTables in Excel | 5.7 Challenge

• 6. Connect to Databases

  • Introduction to PivotTables in Excel | 6.1 What Will We Learn In This Section

  • Introduction to PivotTables in Excel | 6.2 Connect To Databases

  • Introduction to PivotTables in Excel | 6.3 Import Data Sources

  • Introduction to PivotTables in Excel | 6.4 Use Pivottables To Refine Data

  • Introduction to PivotTables in Excel | 6.5 Consolidate Your Data Table

  • Introduction to PivotTables in Excel | 6.6 Format Large Data Sets

  • Introduction to PivotTables in Excel | 6.7 Slicer And Timeline In Large Data Sets

  • Introduction to PivotTables in Excel | 6.8 Refresh And Drill Down From Databases

  • Introduction to PivotTables in Excel | 6.9 Section Summary

  • Introduction to PivotTables in Excel | 6.10 Challenge