Introduction to PivotTables in Excel

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

Excel Pivot Tables Data

Description

Learn everything you need to know about pivot tables in this comprehensive course. Go 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 analyze sales reports 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!

This course is project-based, so you will not be learning useless coding practices. At the end of this course, you will have real-world apps to use in your portfolio. We feel that project-based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.

You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level. Learning how to code is a great way to jump into a new career or enhance your current career. Coding is the new math, and learning how to code will propel you forward in any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.

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

      3:44

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

      3:18

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

      3:17

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

      6:11

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

      1:21

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

      2:02

    • Introduction to PivotTables in Excel | 2.3 Pivottables Basics

      2:53

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

      2:13

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

      4:18

    • Introduction to PivotTables in Excel | 2.6 Section Summary

      2:13

    • Introduction to PivotTables in Excel | 2.7 Challenge

      1:24

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

      1:01

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

      3:30

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

      6:04

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

      4:19

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

      5:41

    • Introduction to PivotTables in Excel | 3.6 Section Summary

      2:12

    • Introduction to PivotTables in Excel | 3.7 Challenge

      1:04

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

      8:46

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

      7:24

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

      9:22

    • Introduction to PivotTables in Excel | 4.4 Modify Source Data

      3:58

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

      8:38

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

      3:38

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

      3:03

    • Introduction to PivotTables in Excel | 4.8 Challenge

      1:47

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

      1:24

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

      3:41

    • Introduction to PivotTables in Excel | 5.3 Slicing Data Project

      5:41

    • Introduction to PivotTables in Excel | 5.4 Data Slicer Tools

      14:10

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

      8:04

    • Introduction to PivotTables in Excel | 5.6 Section Summary

      2:32

    • Introduction to PivotTables in Excel | 5.7 Challenge

      2:05

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

      2:31

    • Introduction to PivotTables in Excel | 6.2 Connect To Databases

      2:07

    • Introduction to PivotTables in Excel | 6.3 Import Data Sources

      3:59

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

      4:41

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

      3:17

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

      4:52

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

      4:36

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

      4:46

    • Introduction to PivotTables in Excel | 6.9 Section Summary

      4:01

    • Introduction to PivotTables in Excel | 6.10 Challenge

      2:02

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet