Microsoft Excel – Data Analysis with Excel Pivot Tables by Maven Analytics, Chris Dutton
What you’ll discover
Excel Pivot Tables can take your data analysis skills from ZERO to PRO.
Learn how to utilize Pivot Tables and Pivot Charts in Excel to simplify and completely alter your workflow.
Learn exclusive Pivot Table ideas, tools, and case studies that you will not find in ANY other course, guaranteed.
Discover engaging, dynamic, and highly effective Excel classes from a best-selling teacher.
Get LIFETIME access to project files, quizzes, homework assignments, and one-on-one professional assistance.
Ten real-world Pivot Table case studies (weather, shark attacks, wine tastings, burrito evaluations, and more!) will put your talents to the test.
DESCRIPTION OF THE ENTIRE COURSE:
Excel Pivot Tables are a must-have tool for everyone who works with data in Excel.
Pivots in Excel allow you to quickly examine and analyze raw data, exposing significant insights and trends that might otherwise be lost in the noise. In other words, they provide you with answers. Whether you’re investigating product sales, determining which marketing approaches resulted in the highest conversion rates, or asking how condo prices have trended over the last decade, Excel Pivot Tables deliver quick, precise, and straightforward answers to even the most complex analytics inquiries.
This course will provide you with a thorough grasp of Excel Pivot Tables and Excel Pivot Charts. I’ll teach you when, why, and how to utilize Excel Pivot Tables, as well as introduce sophisticated sorting, filtering, and calculating capabilities and walk you through interactive, hands-on demos and Excel exercises.
We’ll start by going over everything you need to know to get started with Excel Pivot Tables, such as:
Excel’s raw data structure
Styles and layouts for pivot tables
Options for design and formatting
Tools for sorting, filtering, and grouping
Fields, objects, and values that have been calculated
Slicers, pivot charts, and timelines
Excel dashboards that are interactive
We’ll then look at and evaluate Excel datasets from a variety of real-world case studies, such as:
Ratings for San Diego burritos
Shark attack statistics from 1900 to 2016.
Spartan Race Facebook Post Data
Statistics for Major League Baseball teams
Salary Structure in San Francisco
Data from the daily stock market
IMDb movie reviews
App ratings in the Apple App Store
Ratings and descriptions of wines
1.2GB in size
Related Courses From : Microsoft Excel – Data Analysis with Excel Pivot Tables by Maven Analytics, Chris Dutton