2015
Udemy
Igor Ovchinnikov
1:10
English

From creating your first pivot table in Excel, to becoming a pivot table expert there is a path of learning and experimenting. Microsoft Excel is one the most widely used data analysis tools in business today. Excel pivot tables is undeniably the most powerful part of Excel. If you have ever had a data set to analyze and spent time wondering what you can do with it, then Excel pivot tables is your friend and this Excel course is for you.

Section 1: First Things First
Welcome!
Navigating Udemy Course Interface
Learning Tips
Section 2: Without Any Further Ado
Let's Begin
Importance Of Good Data
Adding Data To The Data Source
Using Excel Table As A Data Source
Adding Data To An Excel Table
Section 3: Let's Play With Some Of The Tools
Design Contextual Tab Overview
Defer Layout Update
Pivot Table Builder Overview
Section 4: Grouping Fields
Grouping Dates
Grouping Numbers
Grouping By Selection
Section 5: Filtering
Slicing Your Report
Timeline
Section 6: Expanding Our Knowledge
Counting With Pivot Tables
Pivot Tables As Data Extraction Tool
Look Ma - No Data Source!
Show As....
Calculated Field
Calculated Item
Recommended Pivot Tables
Pivot Charts
Section 7: Data Analasys: List Of Woman-Owned Retail Businesses Of Seattle
Data Fix: Homework Assignment
Data Fix: Solution
Analysis - Homework
Count By Congressional District Report
Top Ten Zip Codes Report
Top Ten Industries Report
Small Businesses Count Report
Fax or No Fax Report
Count By Month And Year Report
Section 8: Data Analysis: Per Capita GDP By State
Data Fix: Homework
Data Fix: Solution
Average-Highest-Lowest Report - Homework
Average-Highest-Lowest Report - Solution
Percent Of DC Report - Homework
Percent Of DC Report - Solution
USA Overall vs. DC Report - Homework
USA Overall vs. DC Report - Solution
Percent Difference From 1997 Report - Homework
Percent Difference From 1997 Report - Solution
Additional Thoughts On The Data Set
Section 9: Data Analysis: USA Car Crash Data
Data Set Fix - Homework
Data Set Fix - Solution
Additional Thoughts On Car Crash Data
Accidents & Fatalities Monthly Report - Homework
Accidents & Fatalities Monthly Report - Solution
Accidents & Fatalities By Age - Homework
Accidents & Fatalities By Age - Solution
By Age And Gender - Homework
By Age And Gender - Solution
Drug-Related By Gender - Homework
Drug-Related By Gender - Solution
Section 10: Wrapping up!
Thank you

Download File Size:1.04 GB

---