Join SuperDataScience
Start Your Free Trial Today >>Pivot Tables are an absolutely essential tool for anyone working with data in Excel.
Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated questions.
This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Pivot Charts. I'll show you when, why, and how to use Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and exercises every step of the way.
We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:
Raw data structure
Table layouts & styles
Design & formatting options
Sorting, filtering, & grouping tools
Calculated fields, items & values
Pivot Charts, slicers & timelines
Interactive dashboards
We'll then explore and analyze datasets from a number of real-world case studies, including:
San Diego burrito ratings
Shark attack records from 1900-2016
Facebook Post data from Spartan Race
Major League Baseball team statistics
San Francisco employee salaries
Daily stock market data
IMDb movie ratings
And moreā¦
Whether you're looking for a quick primer, trying to persify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge.
I'm here to help you become an analytics ROCK STAR.
$35
/ MonthAccelerate your Career and boost your Earning Potential with our Expert Instructors & Community! What Youāll Unlock: - š 40+ Courses (over 200 hours!) - š 17 Specialized Career Paths - š Quizzes and Practice Activities - š Certificates for Courses & Career Paths - š Prizes for Learning - š§Ŗ Weekly Live Labs (plus recordings!) - šÆ Monthly Missions to practice even more - š¼ Monthly Career Booster Events - š¬ Full access to the SDS Community - ā” Monthly Speed Networking - š„ Monthly Resume Clinics - š„ Group Mentorship Program "In just a few months of learning at SDS, I landed a Data Analyst job!" ā Sanaz Afshar, California
$157
/ MonthAccelerate your Career and boost your Earning Potential with our Expert Instructors & Community! What Youāll Unlock: - š 40+ Courses (over 200 hours!) - š 17 Specialized Career Paths - š Quizzes and Practice Activities - š Certificates for Courses & Career Paths - š Prizes for Learning - š§Ŗ Weekly Live Labs (plus recordings!) - šÆ Monthly Missions to practice even more - š¼ Monthly Career Booster Events - š¬ Full access to the SDS Community - ā” Monthly Speed Networking - š„ Monthly Resume Clinics - š„ Group Mentorship Program Plus, Pro Plan perks just for you: - š A Personalized Career Path built around your goals - š§āš« 1-on-1 Mentoring Sessions every month - āļø Personalized Resume Reviews "In just a few months of learning at SDS, I landed a Data Analyst job!" ā Sanaz Afshar, California
Course content
Why PivotTables?
04:11
Structuring Your Source Data
02:01
Inserting Your First PivotTable
03:13
Navigating the Field List
07:44
PivotTable Options: "Analyze" & "Design"
01:34
Selecting, Clearing, Moving & Copying Pivots
05:15
Refreshing & Updating Pivots
07:30
Pro Tip: Dealing with Growing Source Data
06:50
How PivotTables ACTUALLY Work
03:40
Sorting Options
05:02
Pro Tip: Why Is My Alphabetical Sorting Wrong?
02:02
Label Filters & Manual Selections
08:16
Pro Tip: Using Label Filters with Wildcards
03:15
Value Filters
03:10
Pro Tip: Enabling Multiple Filters
02:42
Grouping Data
03:23
Pro Tip: Automatic Date Grouping
04:26
Using Slicers & Timelines to Filter Data
04:52
Breaking Out Report Filter Pages
04:14
"Summarize Values By" Options
04:46
Pro Tip: Avoiding the "Count Of" Trap
03:50
"Show Values As" Calculations
03:36
Show Values As: % of Column/Row
03:47
Show Values As: % of Parent
03:03
Show Values As: Difference From
04:42
Show Values As: Running Total
02:45
Show Values As: Rank
02:36
Show Values As: Index
08:07
Inserting Calculated Fields
06:31
Calculations in Pivots vs. Raw Data
04:32
Pro Tip: Calculating Using Counts
07:21
Pro Tip: Calculating Using Counts (Part 2)
04:20
Inserting a Calculated Item (Not recommended!)
06:12
The Solve Order & List Formulas Tools
04:55
Intro to PivotCharts
02:27
PivotChart Demo: Column Chart
04:14
PivotChart Demo: Pie/Donut Chart
05:47
PivotChart Demo: Clustered Bar Chart
03:26
Pro Tip: Prevent Charts from Resizing with Cells
04:46
Changing Chart Types on the Fly
03:18
PivotChart Demo: Stacked Area Chart
05:46
PivotChart Layouts & Styles
04:03
Moving PivotCharts to New Sheets
02:10
Applying Slicers & Timelines to Multiple Charts
05:02
Building a Dynamic Dashboard
13:23