Description

Learn everything you need to know about pivot tables in this comprehensive course. Go all the way from answering “what is a pivot table?” to building portfolio ready projects.

Build Projects Including:

1. Build your first basic pivot table to start.
2. Build an expense report from start to finish.
3. Learn how to perform sales report analysis with pivot tables and get that raise.
4. Learn to slice data with powerful data slicer tools and link slicers to multiple pivot tables.
5. Connect to databases to import your data sources and format large datasets.

And much more!

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

    3:44

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

    3:18

  • PivotTables in Excel | Introduction Of The Instructor | 1.3

    3:18

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

    6:11

• 2. 2. PivotTables Fundamental Projects
  • PivotTables in Excel | What We Learn In This Section | 2.1

    1:22

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

    2:01

  • PivotTables in Excel | Pivottables Basics | 2.3

    2:52

  • PivotTables in Excel | Pivottable Compliant Data Sources | 2.4

    2:12

  • PivotTables in Excel | Build A Basic Pivottable | 2.5

    4:18

  • PivotTables in Excel | Section Summary | 2.6

    2:13

  • PivotTables in Excel | Challenge | 2.7

    1:23

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

    1:01

  • PivotTables in Excel | Intro To Formatting Pivottables | 3.2

    3:30

  • PivotTables in Excel | Build An Expense Report | 3.3

    6:03

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

    4:18

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

    5:40

  • PivotTables in Excel | Section Summary | 3.6

    2:13

  • PivotTables in Excel | Challenge | 3.7

    1:04

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

    8:46

  • PivotTables in Excel | What Are Excel Tables | 4.2

    7:24

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

    9:21

  • PivotTables in Excel | Modify Source data | 4.4

    3:58

  • PivotTables in Excel | Format The Sales Report | 4.5

    8:38

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

    3:38

  • PivotTables in Excel | Section Summary | 4.7

    3:03

  • PivotTables in Excel | Challenge | 4.8

    1:47

• 5. 5. Slice and Dice Your Data
  • PivotTables in Excel | What Will We Learn In This Section | 5.1

    1:24

  • PivotTables in Excel | What is Slicing data | 5.2

    3:42

  • PivotTables in Excel | Slicing Data Project | 5.3

    5:41

  • PivotTables in Excel | Data Slicer Tools | 5.4

    14:10

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

    8:03

  • PivotTables in Excel | Section Summary | 5.6

    2:33

  • PivotTables in Excel | Challenge | 5.7

    2:05

• 6. 6. Connect to Databases
  • PivotTables in Excel | What Will We Learn In This Section | 6.1

    2:30

  • PivotTables in Excel | Connect To Databases | 6.2

    2:07

  • PivotTables in Excel | Import Data Sources | 6.3

    3:58

  • PivotTables in Excel | Use Pivottables To Refine | 6.4

    4:42

  • PivotTables in Excel | Consolidate Your Data Table | 6.5

    3:17

  • PivotTables in Excel | Format Large Data Sets | 6.6

    4:52

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

    4:36

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

    4:46

  • PivotTables in Excel | Section Summary | 6.9

    4:02

  • PivotTables in Excel | Challenge | 6.10

    2:02