< Introduction to PivotTables in Excel

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

created by Mammoth Interactive INC

• 1. 1. Introduction
  • PivotTables in Excel | Introduction | 1.1

  • PivotTables in Excel | Why Should You Learn Pivottables | 1.2

  • PivotTables in Excel | Introduction Of The Instructor | 1.3

  • PivotTables in Excel | Course Requirements (what software, experience...) | 1.4

• 2. 2. PivotTables Fundamental Projects

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

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

  • PivotTables in Excel | Pivottables Basics | 2.3

  • PivotTables in Excel | Pivottable Compliant Data Sources | 2.4

  • PivotTables in Excel | Build A Basic Pivottable | 2.5

  • PivotTables in Excel | Section Summary | 2.6

  • PivotTables in Excel | Challenge | 2.7

• 3. 3. Format PivotTables

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

  • PivotTables in Excel | Intro To Formatting Pivottables | 3.2

  • PivotTables in Excel | Build An Expense Report | 3.3

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

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

  • PivotTables in Excel | Section Summary | 3.6

  • PivotTables in Excel | Challenge | 3.7

• 4. 4. Excel Tables

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

  • PivotTables in Excel | What Are Excel Tables | 4.2

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

  • PivotTables in Excel | Modify Source data | 4.4

  • PivotTables in Excel | Format The Sales Report | 4.5

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

  • PivotTables in Excel | Section Summary | 4.7

  • PivotTables in Excel | Challenge | 4.8

• 5. 5. Slice and Dice Your Data

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

  • PivotTables in Excel | What is Slicing data | 5.2

  • PivotTables in Excel | Slicing Data Project | 5.3

  • PivotTables in Excel | Data Slicer Tools | 5.4

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

  • PivotTables in Excel | Section Summary | 5.6

  • PivotTables in Excel | Challenge | 5.7

• 6. 6. Connect to Databases

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

  • PivotTables in Excel | Connect To Databases | 6.2

  • PivotTables in Excel | Import Data Sources | 6.3

  • PivotTables in Excel | Use Pivottables To Refine | 6.4

  • PivotTables in Excel | Consolidate Your Data Table | 6.5

  • PivotTables in Excel | Format Large Data Sets | 6.6

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

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

  • PivotTables in Excel | Section Summary | 6.9

  • PivotTables in Excel | Challenge | 6.10