Microsoft Excel - Data Analysis with Excel Pivot Tables
4.7 /5- Offered byUDEMY
Microsoft Excel - Data Analysis with Excel Pivot Tables at UDEMY Overview
Duration | 7 hours |
Total fee | ₹4,099 |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Excel - Data Analysis with Excel Pivot Tables at UDEMY Highlights
- Compatible on Mobile and TV
- Earn a Cerificate on successful completion
- Get Full Lifetime Access
- Course Instructor: Maven Analytics
Microsoft Excel - Data Analysis with Excel Pivot Tables at UDEMY Course details
- 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
- 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!)
- Excel Pivot Tables are an absolutely essential tool 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.
- It provide fast,accurate and intuitive solutions to even the most complicated data analytics questions.
- This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts.
-
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
Microsoft Excel - Data Analysis with Excel Pivot Tables at UDEMY Curriculum
Getting Started
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Getting to Know the IMDb Movie Database
Setting Expectations
Excel Pivot Table 101
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
HOMEWORK: Excel Pivot Table 101
Formatting Data with Pivot Tables
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
HOMEWORK: Excel Pivot Table Formatting
Sorting, Filtering & Grouping Data with Pivot Tables
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
HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables
Enriching Data with Pivot Table Calculated Values & Fields
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
HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields
Visualizing Data with Excel Pivot Charts
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
HOMEWORK: Visualizing Data with Excel Pivot Charts
Excel Pivot Table Case Studies
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
Wrapping Up
Resources & Next Steps
More from Maven Analytics
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?