IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > Microsoft Excel: Data Analysis with Excel Pivot Tables
Microsoft Excel: Data Analysis with Excel Pivot Tables by Udemy
Master Excel Pivot Tables for data analysis, EDA & business intelligence. Learn from a top MS Excel instructor!
Course Highlights
- 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!)
Skills you will learn!
Curriculum
5 Topics
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Getting to Know the IMDb Movie Database
Setting Expectations
14 Topics
Why Pivot Tables?
Structuring Source Data for Analysis in Excel
Creating Your First Pivot Table
IMPORTANT: Add to Data Model
Navigating the Pivot Table Field List
KNOWLEDGE CHECK: Manipulating the Pivot Table Field List
Exploring Pivot Table Analyze & Design Options
Selecting Clearing Moving & Copying Pivot Tables
Refreshing & Updating Pivot Tables
PRO TIP: Dealing with Growing Source Data
Removing & Reviving Data from the Pivot Table Cache
PRO TIP: How Excel Pivot Tables ACTUALLY Work
QUIZ: Excel Pivot Table 101
HOMEWORK: Excel Pivot Table 101
10 Topics
Changing Pivot Table Number Formats
PRO TIP: Formatting Empty Pivot Table Cells
Configuring Pivot Table Layouts & Styles
PRO TIP: Using Tabular Pivot Tables to Create New Source Data
Customizing Pivot Table Headers & Labels
Applying Basic Conditional Formats to Pivot Tables
PRO TIP: Adding Data Bars with Invisible Text
Applying Advanced Conditional Formats to Pivot Tables
QUIZ: Excel Pivot Table Formatting
HOMEWORK: Excel Pivot Table Formatting
12 Topics
Sorting Data with Pivot Tables
PRO TIP: Fixing Incorrect Alphabetical Sorting
Filtering Data with Pivot Table Label & Selection Filters
PRO TIP: Pivot Table Label Filters with Wildcards
Filtering Data with Pivot Table Value Filters
PRO TIP: Enabling Multiple Pivot Table Filters
Grouping & Segmenting Data with Pivot Tables
PRO TIP: Enabling & Disabling Automatic Date Grouping
Filtering Data with Pivot Table Slicers & Timelines
Breaking Out Pivot Table Report Filter Pages
QUIZ: Sorting Filtering & Grouping Data with Excel Pivot Tables
HOMEWORK: Sorting Filtering & Grouping Data with Excel Pivot Tables
18 Topics
Aggregating & Summarizing Data with Pivot Tables
PRO TIP: Avoiding the Pivot Table "Count Of" Trap
Defining Value Calculations with Pivot Tables
Calculating Pivot Table Values: % of Column/Row
Calculating Pivot Table Values: % of Parent
Calculating Pivot Table Values: Difference From
Calculating Pivot Table Values: Running Total
Calculating Pivot Table Values: Rank
Calculating Pivot Table Values: Index
KNOWLEDGE CHECK: Pivot Table Value Calculations
Defining Calculated Fields with Pivot Tables
Creating Calculated Fields in Pivot Tables vs. Source Data
PRO TIP: Pivot Table Calculations Using Count Columns (Part 1)
PRO TIP: Pivot Table Calculations Using Count Columns (Part 2)
Inserting Pivot Table Calculated Items (USE WITH CAUTION!)
Generating Solve Order & List Formulas Reports
QUIZ: Enriching Data with Pivot Table Calculated Values & Fields
HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields
13 Topics
Intro to Excel Pivot Charts
Pivot Chart Demo: Column Chart
Pivot Chart Demo: Pie & Donut Charts
Pivot Chart Demo: Clustered Bar Chart
PRO TIP: Preventing Charts from Resizing with Cells
Changing Pivot Chart Types
Pivot Chart Demo: Stacked Area Chart
Customizing Pivot Chart Layouts & Styles
Moving Pivot Charts to New Excel Worksheets
Applying Slicers & Timelines to Multiple Pivot Charts
Building Dynamic Dashboards with Pivot Tables & Pivot Charts
QUIZ: Visualizing Data with Excel Pivot Charts
HOMEWORK: Visualizing Data with Excel Pivot Charts
22 Topics
Setting Expectations
DOWNLOAD: Case Study Resources
Pivot Table Demo: Analyzing U.S. Voter Demographics
HOMEWORK: Analyzing U.S. Voter Demographics
Pivot Table Demo: Analyzing San Francisco Salary Data
HOMEWORK: Analyzing San Francisco Salary Data
Pivot Table Demo: Exploring Shark Attack Records
HOMEWORK: Exploring Shark Attack Records
Pivot Table Demo: Analyzing Stock Market Data
HOMEWORK: Analyzing Stock Market Data
Pivot Table Demo: Analyzing Major League Baseball Teams
HOMEWORK: Analyzing Major League Baseball Teams
Pivot Table Demo: Exploring San Diego Burrito Ratings
HOMEWORK: Exploring San Diego Burrito Ratings
Pivot Table Demo: Tracking Daily Weather Conditions
HOMEWORK: Tracking Daily Weather Conditions
Pivot Table Demo: Analyzing Spartan Race Facebook Posts
HOMEWORK: Analyzing Spartan Race Facebook Posts
Pivot Table Demo: Analyzing Apple App Store Data
HOMEWORK: Analyzing Apple App Store Data
Pivot Table Demo: Analyzing Wine Tasting Scores
HOMEWORK: Analyzing Wine Tasting Scores
1 Topic
BONUS LESSON
Microsoft Excel: Data Analysis with Excel Pivot Tables
Related Excel Courses
Thank You!
Your review has been submitted successfully.