IIRF Online > Office Productivity > Google > Google Sheets > Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Google Sheets Pivot Tables by Udemy
Learn how to quickly create powerful reports and data analysis using Pivot Tables and Graphs in Google Sheets in seconds
Course Highlights
- Learn to create POWERFUL PIVOT TABLES in Google Sheets in minutes
- Lifetime access to course material and practice activities from an experienced Udemy instructor
- Learn powerful methods of analysis to turn your data into INSIGHT and INTELLIGENCE
- Learn to create Google Sheet GRAPHS from Pivot Table data with a few clicks of the mouse
- Create CUSTOM calculations that can be added to your Pivot Tables TRANSFORMING the analysis of your data
- Create CUSTOM GROUPINGS of data to display your data in new ways
- Learn conditional formatting to HIGHLIGHT the key information in your data
Skills you will learn!
Curriculum
4 Topics
Introduction to the Course
About the Course
Please download the Training Data Sets
Setup the Training Data Files
7 Topics
Introduction to Google Sheets Pivot Tables
Correctly Structure your Data
Creating Pivot Tables
Working with Multiple Dimensions
Working with Multiple Measures
Practical Activity
Practical Activity Completed
8 Topics
Introduction to Methods of Aggregation
Different Methods of Aggregation
Combining Methods of Aggregation
CountUniques and Median Calculations
Custom Calculations
Grouping of Data
Practical Activity
Practical Activity Completed
5 Topics
Introduction to Comparison Charts
Creating Comparison Charts
Creating Stacked Comparison Charts
Practical Activity
Practical Activity Completed
9 Topics
Introduction to Trend / Time Analysis Section
Time Analysis Calculations
Practical Activity Time Analysis Calculations
Practical Activity Completed
Custom Date Field Calculations
Trend Line Charts
Trend Area Charts
Practical Activity Trend Analysis
Practical Activity Trend Analysis Completed
8 Topics
Introduction to Filter Section
Create Text Filters
Create Numeric Filters
Create Date Filters
Filters and Charts
Filters using Slicers
Filters Practical Activity
Filters Practical Activity Completed
5 Topics
Introduction to Contribution Analysis
Contribution Analysis and Tables
Contribution Analysis and Charts
Practical Activity
Practical Activity Contribution Analysis Completed
6 Topics
Introduction to the Human Resource Section
Please download the training data
Frequency Analysis and Grouping
Grouping and Charts
Practical Activity Frequency Analysis
Completed Frequency Analysis Activity
5 Topics
Introduction to Conditional Formatting
Conditional Formatting using Rules
Conditional Formatting using Color Scales
Practical Activity Conditional Formatting
Completed Conditional Formatting Activity
1 Topic
Course Conclusion
Complete Introduction to Google Sheets Pivot Tables
Related Google Sheets Courses
Thank You!
Your review has been submitted successfully.