Microsoft Excel: Data Analysis with Excel Pivot Tables

Microsoft Excel: Data Analysis with Excel Pivot Tables, available at $199.99, has an average rating of 4.62, with 93 lectures, 5 quizzes, based on 65138 reviews, and has 253538 subscribers.

You will learn about Take your data analysis & EDA skills from ZERO to PRO with Excel Pivot Tables Learn how to use Pivot Tables and Pivot Charts to streamline and simplify your workflow in Excel Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course Explore fun, interactive, and highly effective lessons from a best-selling MS 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!) This course is ideal for individuals who are ANYONE who works with Excel on a regular basis (even if you've never used a Pivot Table!) or Microsoft Excel users who have basic skills but would like to become more proficient in data exploration and analytics or Students looking for a comprehensive, engaging, and highly interactive approach to training or Anyone looking to pursue a career in data analysis, analytics or business intelligence It is particularly useful for ANYONE who works with Excel on a regular basis (even if you've never used a Pivot Table!) or Microsoft Excel users who have basic skills but would like to become more proficient in data exploration and analytics or Students looking for a comprehensive, engaging, and highly interactive approach to training or Anyone looking to pursue a career in data analysis, analytics or business intelligence.

Enroll now: Microsoft Excel: Data Analysis with Excel Pivot Tables

Summary

Title: Microsoft Excel: Data Analysis with Excel Pivot Tables

Price: $199.99

Average Rating: 4.62

Number of Lectures: 93

Number of Quizzes: 5

Number of Published Lectures: 90

Number of Published Quizzes: 5

Number of Curriculum Items: 98

Number of Published Curriculum Objects: 95

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will Learn

Take your data analysis & EDA skills from ZERO to PRO with Excel Pivot Tables
Learn how to use Pivot Tables and Pivot Charts to streamline and simplify your workflow in Excel
Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course
Explore fun, interactive, and highly effective lessons from a best-selling MS 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!)

Who Should Attend

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

Target Audiences

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

Excel Pivot Tables are an absolutely essentialtool for anyone working in data analytics or business intelligence.

Pivot Tables 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 data analytics questions.

This course gives you a deep, 100% comprehensive understandingof 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 MS Excel skill set, or hoping to step up your analytics or business intelligence 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 our full course library? Search “Maven Analytics” to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learningcourses!

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 justLEARN 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.

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

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course Structure & Outline

Lecture 2: READ ME: Important Notes for New Students

Lecture 3: DOWNLOAD: Course Resources

Lecture 4: Getting to Know the IMDb Movie Database

Lecture 5: Setting Expectations

Chapter 2: Excel Pivot Table 101

Lecture 1: Why Pivot Tables?

Lecture 2: Structuring Source Data for Analysis in Excel

Lecture 3: Creating Your First Pivot Table

Lecture 4: IMPORTANT: Add to Data Model

Lecture 5: Navigating the Pivot Table Field List

Lecture 6: KNOWLEDGE CHECK: Manipulating the Pivot Table Field List

Lecture 7: Exploring Pivot Table Analyze & Design Options

Lecture 8: Selecting, Clearing, Moving & Copying Pivot Tables

Lecture 9: Refreshing & Updating Pivot Tables

Lecture 10: PRO TIP: Dealing with Growing Source Data

Lecture 11: Removing & Reviving Data from the Pivot Table Cache

Lecture 12: PRO TIP: How Excel Pivot Tables ACTUALLY Work

Lecture 13: HOMEWORK: Excel Pivot Table 101

Chapter 3: Formatting Data with Pivot Tables

Lecture 1: Changing Pivot Table Number Formats

Lecture 2: PRO TIP: Formatting Empty Pivot Table Cells

Lecture 3: Configuring Pivot Table Layouts & Styles

Lecture 4: PRO TIP: Using Tabular Pivot Tables to Create New Source Data

Lecture 5: Customizing Pivot Table Headers & Labels

Lecture 6: Applying Basic Conditional Formats to Pivot Tables

Lecture 7: PRO TIP: Adding Data Bars with Invisible Text

Lecture 8: Applying Advanced Conditional Formats to Pivot Tables

Lecture 9: HOMEWORK: Excel Pivot Table Formatting

Chapter 4: Sorting, Filtering & Grouping Data with Pivot Tables

Lecture 1: Sorting Data with Pivot Tables

Lecture 2: PRO TIP: Fixing Incorrect Alphabetical Sorting

Lecture 3: Filtering Data with Pivot Table Label & Selection Filters

Lecture 4: PRO TIP: Pivot Table Label Filters with Wildcards

Lecture 5: Filtering Data with Pivot Table Value Filters

Lecture 6: PRO TIP: Enabling Multiple Pivot Table Filters

Lecture 7: Grouping & Segmenting Data with Pivot Tables

Lecture 8: PRO TIP: Enabling & Disabling Automatic Date Grouping

Lecture 9: Filtering Data with Pivot Table Slicers & Timelines

Lecture 10: Breaking Out Pivot Table Report Filter Pages

Lecture 11: HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables

Chapter 5: Enriching Data with Pivot Table Calculated Values & Fields

Lecture 1: Aggregating & Summarizing Data with Pivot Tables

Lecture 2: PRO TIP: Avoiding the Pivot Table "Count Of" Trap

Lecture 3: Defining Value Calculations with Pivot Tables

Lecture 4: Calculating Pivot Table Values: % of Column/Row

Lecture 5: Calculating Pivot Table Values: % of Parent

Lecture 6: Calculating Pivot Table Values: Difference From

Lecture 7: Calculating Pivot Table Values: Running Total

Lecture 8: Calculating Pivot Table Values: Rank

Lecture 9: Calculating Pivot Table Values: Index

Lecture 10: KNOWLEDGE CHECK: Pivot Table Value Calculations

Lecture 11: Defining Calculated Fields with Pivot Tables

Lecture 12: Creating Calculated Fields in Pivot Tables vs. Source Data

Lecture 13: PRO TIP: Pivot Table Calculations Using Count Columns (Part 1)

Lecture 14: PRO TIP: Pivot Table Calculations Using Count Columns (Part 2)

Lecture 15: Inserting Pivot Table Calculated Items (USE WITH CAUTION!)

Lecture 16: Generating Solve Order & List Formulas Reports

Lecture 17: HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields

Chapter 6: Visualizing Data with Excel Pivot Charts

Lecture 1: Intro to Excel Pivot Charts

Lecture 2: Pivot Chart Demo: Column Chart

Lecture 3: Pivot Chart Demo: Pie & Donut Charts

Lecture 4: Pivot Chart Demo: Clustered Bar Chart

Lecture 5: PRO TIP: Preventing Charts from Resizing with Cells

Lecture 6: Changing Pivot Chart Types

Lecture 7: Pivot Chart Demo: Stacked Area Chart

Lecture 8: Customizing Pivot Chart Layouts & Styles

Lecture 9: Moving Pivot Charts to New Excel Worksheets

Lecture 10: Applying Slicers & Timelines to Multiple Pivot Charts

Lecture 11: Building Dynamic Dashboards with Pivot Tables & Pivot Charts

Lecture 12: HOMEWORK: Visualizing Data with Excel Pivot Charts

Chapter 7: Excel Pivot Table Case Studies

Lecture 1: Setting Expectations

Lecture 2: DOWNLOAD: Case Study Resources

Lecture 3: Pivot Table Demo: Analyzing U.S. Voter Demographics

Lecture 4: HOMEWORK: Analyzing U.S. Voter Demographics

Lecture 5: Pivot Table Demo: Analyzing San Francisco Salary Data

Lecture 6: HOMEWORK: Analyzing San Francisco Salary Data

Lecture 7: Pivot Table Demo: Exploring Shark Attack Records

Lecture 8: HOMEWORK: Exploring Shark Attack Records

Lecture 9: Pivot Table Demo: Analyzing Stock Market Data

Lecture 10: HOMEWORK: Analyzing Stock Market Data

Lecture 11: Pivot Table Demo: Analyzing Major League Baseball Teams

Lecture 12: HOMEWORK: Analyzing Major League Baseball Teams

Lecture 13: Pivot Table Demo: Exploring San Diego Burrito Ratings

Lecture 14: HOMEWORK: Exploring San Diego Burrito Ratings

Lecture 15: Pivot Table Demo: Tracking Daily Weather Conditions

Lecture 16: HOMEWORK: Tracking Daily Weather Conditions

Lecture 17: Pivot Table Demo: Analyzing Spartan Race Facebook Posts

Lecture 18: HOMEWORK: Analyzing Spartan Race Facebook Posts

Lecture 19: Pivot Table Demo: Analyzing Apple App Store Data

Lecture 20: HOMEWORK: Analyzing Apple App Store Data

Lecture 21: Pivot Table Demo: Analyzing Wine Tasting Scores

Instructors

Maven Analytics
Empowering everyday people with life-changing data skills
Chris Dutton
Best-Selling Instructor, Founder @ Maven Analytics

Rating Distribution

1 stars: 194 votes
2 stars: 476 votes
3 stars: 4381 votes
4 stars: 21708 votes
5 stars: 38379 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu