Complete Introduction to Google Sheets Pivot Tables
- Description
- Curriculum
- FAQ
- Reviews
**** Lifetime access to course materials and practice activities. ****
This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5.
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.
This course will achieve the following:
-
Learn to CORRECTLY STRUCTURE your data
-
Create Pivot Tables to SUMMARIZE and AGGREGATE your data
-
Using Different Methods of Calculation – Sum,Count, Unique Count, Average, Median, Max, Min
-
Create your own POWERFUL custom calculations
-
Create Time / Trend Analysis
-
Time / Trend Analysis graphs
-
FILTER and ASK QUESTIONS of your data
-
Contribution Analysis – percentages
-
Contribution Analysis – graphs
-
Analyze Human Resource data – Create powerful reports
-
Learn to GROUP Age and Salary data
-
Apply CONDITIONAL FORMATTING to data
-
5
Introduction to Google Sheets Pivot TablesIntroduction to the creating Pivot Tables section
-
6
Correctly Structure your Data
In this lesson you will learn how to correctly structure your data for analysis with Pivot Tables
-
7
Creating Pivot Tables
In this lesson you will learn how to create Pivot Tables to summarize and aggregate your data
-
8
Working with Multiple Dimensions
In this lesson you will learn how to add new Dimensions to Rows and Columns
-
9
Working with Multiple Measures
-
10
Practical ActivityIn this practical activity you will create basic pivot tables to summarize and aggregate data.
-
11
Practical Activity Completed
The completed activity for the creating Pivot Tables exercise
-
12
Introduction to Methods of Aggregation
Introduction to the Methods of Aggregation section of the course
-
13
Different Methods of Aggregation
In this lesson you will learn how to calculate averages, min and max methods of aggregation
-
14
Combining Methods of Aggregation
In this lesson you will learn how to combine average, max, min and sum aggregations into one table
-
15
CountUniques and Median Calculations
In this lesson you will learn how to use the Median and CountUnique summarization methods
-
16
Custom Calculations
In this lesson you will learn how to use the Calculated Field option to create your own custom calculations.
-
17
Grouping of Data
In this lesson you will learn how to group items in Pivot Tables
-
18
Practical Activity
Practical activity to practice different methods of aggregation.
-
19
Practical Activity Completed
The completed activity for the methods of aggregation practical activity
-
20
Introduction to Comparison Charts
Introduction to Comparison Charts
-
21
Creating Comparison Charts
In this lesson you will learn how to create column and bar charts to display Pivot Table data
-
22
Creating Stacked Comparison Charts
In this lesson you will learn how to use the stacked and 100% options for the column and bar charts.
-
23
Practical Activity
A practical activity to create comparison charts
-
24
Practical Activity Completed
-
25
Introduction to Trend / Time Analysis Section
Introduction to the Trend Analysis section
-
26
Time Analysis Calculations
In this lesson you will learn how to use the Pivot Table Group Date function to easily create reports displaying Year, Year and Quarter, Year and Month, and many more
-
27
Practical Activity Time Analysis Calculations
Practical activity to practice creating reports using different date options.
-
28
Practical Activity Completed
The completed practical activity for date calculations
-
29
Custom Date Field Calculations
In this lesson learn how to create your own custom fields for Year, Month, WeekDay and others.
-
30
Trend Line Charts
In this lesson you will learn how to use the Line charts to display trend data and analysis
-
31
Trend Area Charts
In this lesson you will learn how to display and analyze trends using area graphs
-
32
Practical Activity Trend Analysis
Practical activity for trend analysis and charts
-
33
Practical Activity Trend Analysis Completed
The completed practical activity for trend analysis
-
34
Introduction to Filter Section
Introduction to the Filter section
-
35
Creating Manual Filters
In this lesson you will learn how to manually add and apply filters to your Pivot Tables
-
36
Creating Filters using Conditions
In this lesson you will learn how to use the conditions filter
-
37
Filter Pivot Tables with Fields outside the Pivot Table
Learn to use fields that are not part of the Pivot Table to filter the Pivot Table
-
38
Filters and Charts
In this lesson you will learn how to create interactive charts using the Pivot Table filter option
-
39
Filters using Slicers
-
40
Filters Practical Activity
Practical activity for the Filters section
-
41
Filters Practical Activity Completed
The completed practical activity for Filters
-
42
Introduction to Contribution Analysis
Introduction to the Contribution Analysis section
-
43
Contribution Analysis and Tables
In this lesson you will learn how to easily create percentage calculations for Tables
-
44
Contribution Analysis and Charts
In this lesson you will learn how to display the percentages in charts
-
45
Practical Activity
In this practical activity you will practice creating tables and charts with percentage calculations
-
46
Practical Activity Contribution Analysis Completed
The completed activity for contribution analysis
-
47
Introduction to the Human Resource Section
Introduction to the Human Resource data analysis section
-
48
Please download the training data
-
49
Frequency Analysis and Grouping
In this lesson you will group the Age field to easily create groupings for analysis
-
50
Grouping and Charts
In this lesson you will learn how to work with frequency analysis and display the results using charts
-
51
Practical Activity Frequency Analysis
In this practical activity you will practice creating grouping tables and charts
-
52
Completed Frequency Analysis Activity
This is the completed activity for the Human Resource data section
-
53
Introduction to Conditional Formatting
Introduction to the Conditional Formatting section
-
54
Conditional Formatting using Rules
Learn to use conditional formatting to highlight important data
-
55
Conditional Formatting using Color Scales
-
56
Practical Activity Conditional Formatting
Practical activity to practice using conditional formatting
-
57
Completed Conditional Formatting Activity
This video runs you through the completed conditional formatting activity
