< 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

PivotTables in Excel | Introduction | 1.1

2 Views 0 Likes 0 Comments

Comment
Leave a comment (supports markdown format)