0 (0 Ratings)
Data Analytics with Google sheets
About Course
Data analytics using google sheets
What I will learn?
- learn how to get actionable insights out of data
- learn data storytelling to convince others with your insights
- learn all google sheet tips and tricks for data analysis
Course Curriculum
Introduction & Motivation
introduction to data analysis
Data Adventure Phase 1 [Pivot Tables]
Your Data adventure starts here, Be ready to receive a quest every video from your manager to solve with data analytics techniques
-
Analyze sales data using pivot tables [1]
04:47 -
Analyze sales data using pivot tables [2]
07:10 -
Analyze sales data using pivot tables [3]
06:28 -
Pivot tables Assignment
Data Adventure Phase 2 [Formatting]
Better formatting better insights
-
Formatting 1 [Number formatting]
04:32 -
Formatting 2 [Positive/Negative customization]
04:40 -
Formatting 3 [Arrows]
03:52 -
Formatting Assignment
-
Root Cause Analysis
11:33 -
Root Cause Analysis
Data Adventure Phase 3 [Data Visualization]
Better Visualization > Better Insights
-
Data visualization 1 [Power of data visualization]
12:47 -
Data visualization 2 [Important concepts]
09:07 -
Data visualization 3 Line Chart
17:13 -
Data Visualization 4 Waterfull Chart
01:29 -
Data visualization 5 Column/Bar chart
10:49 -
Data Visuallization 6 Pie chart
05:05 -
Data Visuallization 7 Scatter plot
04:07 -
Charts Assignment
Data Adventure Phase 4 [Dashboarding]
How to design a dashboard that deliver the message
-
Dashboard Design 1 [Introduction]
02:26 -
Create a Dashboard [Implementation]
14:35 -
Dashboard design 3 [Slicers]
14:35 -
Design Dasboard
-
Dynamic Dashboard [Dynamic Range]
04:27 -
More on filter by condition
01:10 -
Dynamic Dashboard [Dynamic Slicer]
15:00 -
Dynamic Dasboard
Data Adventure Phase 5 [Advanced]
Dynamic slicers and tabular dashboard using sumif()
-
Advanced[SUMIF Part 1]
04:32 -
Advanced[SUMIF Part 2]
03:40 -
Tabular Dashboard [1]
12:39 -
Tabular Dashboard [2]
04:06 -
Advanced[SumIF]
Student Ratings & Reviews
No Review Yet
Free
Free access this course
-
LevelIntermediate
-
Total Enrolled877
-
Last UpdatedNovember 9, 2025
-
CertificateCertificate of completion
Hi, Welcome back!
Material Includes
- Real life projects
- Live workshops
- Datasets for practice
- Materials used in the course
Requirements
- Please don't share the materials/datasets/assignment with anyone, Thanks!
Target Audience
- If you want to make a positive impact on business using data then this course is for your