Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 6.5 hours on-demand video
  • 22 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel - Data Analysis with Excel Pivot Tables

Master Excel Pivot Tables & data analysis with real-world cases from a best-selling Excel instructor (Excel 2010-2019)
Bestseller
Rating: 4.6 out of 54.6 (23,444 ratings)
121,874 students
Created by Maven Analytics, Chris Dutton
Last updated 1/2021
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Take your data analysis skills from ZERO to PRO with Excel Pivot Tables
  • Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel
  • Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
  • Test your skills with 10 real-world Pivot Table case studies (weather, shark attacks, wine tastings, burrito ratings, and more!)
Curated for the Udemy for Business collection

Requirements

  • Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
  • Mac users are welcome, but note that the Pivot Table interface varies across platforms
  • Basic experience with Excel functionality (charts & formulas a plus!)

Description

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course:

"This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT"

-Monique C.

"Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!"

-Paul M.

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well."

-Ernie A.

__________

FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, 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 condo prices have trended over the past 10 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel 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 in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering, & grouping tools

  • Calculated fields, items & values

  • Pivot Charts, slicers & timelines

  • Interactive Excel dashboards

__________

We'll then explore and analyze Excel 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

  • Apple Store mobile app ratings

  • Wine ratings and descriptions

__________

Whether you're looking for a quick Excel Pivot Table primer, trying to diversify 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. Enroll today and start your journey to becoming an Excel analytics pro!

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

Who this course is for:

  • ANYONE who works with Excel on a regular basis (even if you've never used a Pivot Table!)
  • Excel users who have basic skills but would like to become more proficient in data exploration and analysis
  • Students looking for a comprehensive, engaging, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence

Featured review

Fulbert Fulko
Fulbert Fulko
12 courses
5 reviews
Rating: 5.0 out of 55 months ago
Pretty quick yet very condensed course tackling pivot tables. Chris can be a bit hasty sometimes, but that's when the 'pause' button comes in handy. Every bit of information was clearly said and shown, some of it even repeated 3 times or more during the whole course. Big positive for the last section, when we finally can use our newly learned skills in many different types of datasets. I learned exactly what I wanted, thank you!

Course content

8 sections • 90 lectures • 6h 50m total length

  • Preview03:26
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resources
    00:19
  • Preview02:21
  • Preview01:14

  • Why Pivot Tables?
    04:10
  • Structuring Source Data for Analysis in Excel
    02:00
  • Creating Your First Pivot Table
    03:13
  • IMPORTANT: Add to Data Model
    00:29
  • Navigating the Pivot Table Field List
    07:43
  • KNOWLEDGE CHECK: Manipulating the Pivot Table Field List
    00:28
  • Exploring Pivot Table Analyze & Design Options
    01:33
  • Selecting, Clearing, Moving & Copying Pivot Tables
    05:14
  • Refreshing & Updating Pivot Tables
    07:30
  • PRO TIP: Dealing with Growing Source Data
    06:49
  • Preview05:41
  • PRO TIP: How Excel Pivot Tables ACTUALLY Work
    03:39
  • QUIZ: Excel Pivot Table 101
    5 questions
  • HOMEWORK: Excel Pivot Table 101
    01:08

  • Changing Pivot Table Number Formats
    02:12
  • PRO TIP: Formatting Empty Pivot Table Cells
    01:41
  • Configuring Pivot Table Layouts & Styles
    05:30
  • PRO TIP: Using Tabular Pivot Tables to Create New Source Data
    02:20
  • Customizing Pivot Table Headers & Labels
    01:16
  • Applying Basic Conditional Formats to Pivot Tables
    06:51
  • PRO TIP: Adding Data Bars with Invisible Text
    02:13
  • Preview06:51
  • QUIZ: Excel Pivot Table Formatting
    4 questions
  • HOMEWORK: Excel Pivot Table Formatting
    00:51

  • Sorting Data with Pivot Tables
    05:01
  • PRO TIP: Fixing Incorrect Alphabetical Sorting
    02:01
  • Filtering Data with Pivot Table Label & Selection Filters
    08:15
  • PRO TIP: Pivot Table Label Filters with Wildcards
    03:15
  • Filtering Data with Pivot Table Value Filters
    03:10
  • Preview02:42
  • Grouping & Segmenting Data with Pivot Tables
    03:23
  • PRO TIP: Enabling & Disabling Automatic Date Grouping
    04:25
  • Filtering Data with Pivot Table Slicers & Timelines
    04:51
  • Breaking Out Pivot Table Report Filter Pages
    04:13
  • QUIZ: Sorting, Filtering & Grouping Data with Excel Pivot Tables
    6 questions
  • HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables
    00:56

  • Aggregating & Summarizing Data with Pivot Tables
    04:45
  • PRO TIP: Avoiding the Pivot Table "Count Of" Trap
    03:49
  • Defining Value Calculations with Pivot Tables
    03:35
  • Calculating Pivot Table Values: % of Column/Row
    03:47
  • Calculating Pivot Table Values: % of Parent
    03:02
  • Calculating Pivot Table Values: Difference From
    04:42
  • Calculating Pivot Table Values: Running Total
    02:44
  • Calculating Pivot Table Values: Rank
    02:36
  • Calculating Pivot Table Values: Index
    08:06
  • KNOWLEDGE CHECK: Pivot Table Value Calculations
    00:20
  • Defining Calculated Fields with Pivot Tables
    06:30
  • Creating Calculated Fields in Pivot Tables vs. Source Data
    04:32
  • PRO TIP: Pivot Table Calculations Using Count Columns (Part 1)
    07:20
  • PRO TIP: Pivot Table Calculations Using Count Columns (Part 2)
    04:19
  • Inserting Pivot Table Calculated Items (USE WITH CAUTION!)
    06:11
  • Generating Solve Order & List Formulas Reports
    04:54
  • QUIZ: Enriching Data with Pivot Table Calculated Values & Fields
    7 questions
  • HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields
    01:19

  • Intro to Excel Pivot Charts
    02:26
  • Pivot Chart Demo: Column Chart
    04:13
  • Pivot Chart Demo: Pie & Donut Charts
    05:46
  • Pivot Chart Demo: Clustered Bar Chart
    03:25
  • PRO TIP: Preventing Charts from Resizing with Cells
    04:45
  • Changing Pivot Chart Types
    03:18
  • Pivot Chart Demo: Stacked Area Chart
    05:46
  • Customizing Pivot Chart Layouts & Styles
    04:03
  • Moving Pivot Charts to New Excel Worksheets
    02:09
  • Applying Slicers & Timelines to Multiple Pivot Charts
    05:01
  • Building Dynamic Dashboards with Pivot Tables & Pivot Charts
    Preview13:22
  • QUIZ: Visualizing Data with Excel Pivot Charts
    6 questions
  • HOMEWORK: Visualizing Data with Excel Pivot Charts
    01:05

  • Setting Expectations
    01:45
  • DOWNLOAD: Case Study Resources
    00:10
  • Pivot Table Demo: Analyzing U.S. Voter Demographics
    10:33
  • HOMEWORK: Analyzing U.S. Voter Demographics
    00:43
  • Pivot Table Demo: Analyzing San Francisco Salary Data
    13:06
  • HOMEWORK: Analyzing San Francisco Salary Data
    00:40
  • Pivot Table Demo: Exploring Shark Attack Records
    10:31
  • HOMEWORK: Exploring Shark Attack Records
    00:54
  • Pivot Table Demo: Analyzing Stock Market Data
    Preview12:25
  • HOMEWORK: Analyzing Stock Market Data
    00:34
  • Pivot Table Demo: Analyzing Major League Baseball Teams
    14:16
  • HOMEWORK: Analyzing Major League Baseball Teams
    00:55
  • Pivot Table Demo: Exploring San Diego Burrito Ratings
    16:40
  • HOMEWORK: Exploring San Diego Burrito Ratings
    00:43
  • Pivot Table Demo: Tracking Daily Weather Conditions
    12:41
  • HOMEWORK: Tracking Daily Weather Conditions
    00:40
  • Pivot Table Demo: Analyzing Spartan Race Facebook Posts
    14:37
  • HOMEWORK: Analyzing Spartan Race Facebook Posts
    00:39
  • Pivot Table Demo: Analyzing Apple App Store Data
    18:39
  • HOMEWORK: Analyzing Apple App Store Data
    01:17
  • Pivot Table Demo: Analyzing Wine Tasting Scores
    Preview17:13
  • HOMEWORK: Analyzing Wine Tasting Scores
    01:02

  • BONUS LECTURE: More from Maven Analytics
    00:55

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 138,601 Reviews
  • 427,746 Students
  • 19 Courses

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.

Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.

Chris Dutton
Founder, Maven Analytics
Chris Dutton
  • 4.6 Instructor Rating
  • 128,157 Reviews
  • 427,746 Students
  • 6 Courses

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor.

As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world.

A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.