Complete Introduction to Google Sheets Pivot Tables
5.0 /5- Offered byUDEMY
Complete Introduction to Google Sheets Pivot Tables at UDEMY Overview
Duration | 3 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Complete Introduction to Google Sheets Pivot Tables at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Learn from 3 downloadable resources & 11 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Complete Introduction to Google Sheets Pivot Tables at UDEMY Course details
- For Google Sheet users who want to learn Pivot Tables
- For Excel users who want to learn how to use Google Sheets
- For Google Sheets users who want to learn to analyze and report data
- 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
- Google Sheets offers many of the features of traditional spreadsheet products & is becoming an extremely popular tool for data analysis and reporting
- Google Sheets makes it easy to setup and share data and information within the cloud
- In this course we explore one of the most POWERFUL features of Google Sheets which is Pivot Tables
- You will learn how to EASILY create powerful Pivot Tables and Graphs using a FEW CLICKS of the mouse
- This course is primarily for people who want to learn how to get Google Sheets to do the work for them, without haivng to write complicated formulas or functions to achieve data analysis
Complete Introduction to Google Sheets Pivot Tables at UDEMY Curriculum
Introduction
Introduction to the course
About the course
Set up the training data files
Create reports with pivot tables
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
Methods of Aggregation and Grouping
Introduction to Methods of Aggregation
Different Methods of Aggregation
Combining Methods of Aggregation
CountUniques and Median Calculations
Custom Calculations
Grouping of Data
Practical Activity Completed
Comparisons Charts
Introduction to Comparisons Charts
Creating Comparison Charts
Creating Stacked Comparison Charts
Practical Activity Completed
Trend/ Time Analysis Section
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
Filters - Asking questions of your data
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
Complete Introduction to Google Sheets Pivot Tables at UDEMY Faculty details
Other courses offered by UDEMY
Complete Introduction to Google Sheets Pivot Tables at UDEMY Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?