Microsoft Excel - Data Analysis with Excel Pivot Tables (Udemy.com)

Master Excel Pivot Tables & data analysis with real-world cases from a best-selling Excel instructor (Excel 2010-2019)

Created by: Maven Analytics

Produced in 2022

icon
What you will 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!)

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 98 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a excel course? Or looking for more detail on Maven Analytics's Microsoft Excel - Data Analysis with Excel Pivot Tables? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course 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, Excel Maven & Maven Analytics)
__________
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.
__________
P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Maven Analytics" and complete the courses below to become a business intelligence ROCKSTAR:
  1. Excel Pro Tips for Power Users
  2. Advanced Excel Formulas & Functions
  3. Data Visualization with Excel Charts & Graphs
  4. Data Analysis with Excel PivotTables
  5. Excel Power Query, Power Pivot & DAX
  6. Up & Running with Power BI Desktop
  7. Publishing to Power BI Service
  8. SQL Database Analysis for Beginners
  9. Advanced MySQL for Analytics & Business Intelligence
*** Course access includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee!***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

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Maven Analytics

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 190 countries develop the most sought-after analytics skills, through on-demand courses, personalized 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 is a professional BI developer, certified Microsoft expert, and best-selling Udemy instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.
He founded Excel Maven and Maven Analytics in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 100,000+ students in more than 185 countries. He has developed award-winning data analytics and visualization tools, which have been featured by Microsoft, the New York Times, and the Society of American Baseball Research.
Current Udemy courses include:
- Advanced Excel Formulas & Functions (English & Spanish)
- Data Visualizat

icon
Reviews

4.9

100 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Dmitry Yakimchik on 2 weeks ago

The course was nice. It has taught how to use Pivots properly.A half star was removed for repeating actions in case studies (section 7).

By Aafreen Alam on a month ago

This course was just what I needed. Learnt more than what I had originally expected to.

By Wayne Scott on 2 months ago

This course not only provided technical skill building on Pivot Tables it also insight on how data could be used to answer questions and reveal questions the one could not think of asking.

By Daniel Siow on 2 months ago

Gave a full rating as I learned much with many interesting homework to practice what I have gained. Just one small shortcoming is that the screenshot table are so small in the answer session, I can hardly read it. Perhaps to provide the answers and screenshots in a separate PDF attachment for ease of viewing and zooming.

By Bob Korndorffer on 5 months ago

I had taken a course that was named to be the same course. But it actually was not. The biggest difference made this course much more valuable. Both explained the very basics of how to display a pivot table. But this course gave much more emphasis to analysis and conclusions. The sample data sets were maybe 10 times more than those available in the other course. This yielded much more practice with variations of analyses. In my case, the repetition of basic keystrokes to get to the myriad of pivot facilities was valuable. It seemed like I used them so repetitively that I now know how to do the great variety of analyses available, and if I don't, I know how to find the facility I'm looking for. This was simply a more in depth exposure to the topic. Thanks.

By Kristi Sults on 2 months ago

The course includes very useful information; is practical and easy to follow. Besides teaching Excel and sharing his pro-tips, Chris also gives an insight into the way of thinking of an analyst.

By Greg Zschaschel on 2 months ago

Yes, course is excellent. I enjoy listening to Chris and his style of instruction is very easy for me to follow!

By Ali Qutaiba Saeed on 3 months ago

if i have to say how good this course is, regarding ( explanation , simplicity , valuable information , replied to questions and clarifications ....etc ) it will take me a page.Thanks Maven for this amazing course, and surely i will go for your full excel courses.

By Alan Chelko on a week ago

Excellent course:-super clear step-by-step (and extremely relevant) instructions-learning by doing and repetition-the final case studies beats the material into your head-also, something which shouldn't be taken for granted -- native English speaker who spoke clearly throughout

By Mateusz Wojnach on 3 weeks ago

Defiantly worth recommending this course :) . I had knowledge about Pivot Tables, but thanks to this course I learned a few important tricks :) Thanks Chris,

By Krishnakant Gurjar on 2 months ago

Smoothly created content by Chris and Maven team very helpful courses for skill building . You can practice it while learning. Thank you for the lectures and courses.???..Cheers

By Vaibhav Nanda on a week ago

The course is well paced and gives you the opportunity to practice the concepts covered with well designed exercises. I highly recommend to anybody who wants to increase their knowledge on excel and pivot tables.