Data Analytics with Google sheets

0 (0 Ratings)

Data Analytics with Google sheets

Categories Data analytics, Most Popular

Wishlist

About Course

Data analytics using google sheets

Course Curriculum

Introduction & Motivation
introduction to data analysis

Why you should learn Data Analytics

07:03
Why Google Sheets is the Perfect Starting Point for Data Analysis

04:17

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

Data Adventure Phase 2 [Formatting]
Better formatting better insights

Data Adventure Phase 3 [Data Visualization]
Better Visualization > Better Insights

Data Adventure Phase 4 [Dashboarding]
How to design a dashboard that deliver the message

Data Adventure Phase 5 [Advanced]
Dynamic slicers and tabular dashboard using sumif()

Student Ratings & Reviews

No Review Yet

Free

Free access this course

Level

Intermediate
Total Enrolled

246
Last Updated

October 29, 2025
Certificate

Certificate of completion

Data Analytics with Google sheets

About Course

What I will learn?

Course Curriculum

Introduction & Motivation introduction to data analysis

Why you should learn Data Analytics

Why Google Sheets is the Perfect Starting Point for 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]

Analyze sales data using pivot tables [2]

Analyze sales data using pivot tables [3]

Pivot tables Assignment

Data Adventure Phase 2 [Formatting] Better formatting better insights

Formatting 1 [Number formatting]

Formatting 2 [Positive/Negative customization]

Formatting 3 [Arrows]

Formatting Assignment

Root Cause Analysis

Root Cause Analysis

Data Adventure Phase 3 [Data Visualization] Better Visualization > Better Insights

Data visualization 1 [Power of data visualization]

Data visualization 2 [Important concepts]

Data visualization 3 Line Chart

Data Visualization 4 Waterfull Chart

Data visualization 5 Column/Bar chart

Data Visuallization 6 Pie chart

Data Visuallization 7 Scatter plot

Charts Assignment

Data Adventure Phase 4 [Dashboarding] How to design a dashboard that deliver the message

Dashboard Design 1 [Introduction]

Create a Dashboard [Implementation]

Dashboard design 3 [Slicers]

Design Dasboard

Dynamic Dashboard [Dynamic Range]

More on filter by condition

Dynamic Dashboard [Dynamic Slicer]

Dynamic Dasboard

Data Adventure Phase 5 [Advanced] Dynamic slicers and tabular dashboard using sumif()

Advanced[SUMIF Part 1]

Advanced[SUMIF Part 2]

Tabular Dashboard [1]

Tabular Dashboard [2]

Advanced[SumIF]

Student Ratings & Reviews

Material Includes

Requirements

Target Audience

Shopping cart

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

Data Adventure Phase 2 [Formatting]
Better formatting better insights

Data Adventure Phase 3 [Data Visualization]
Better Visualization > Better Insights

Data Adventure Phase 4 [Dashboarding]
How to design a dashboard that deliver the message

Data Adventure Phase 5 [Advanced]
Dynamic slicers and tabular dashboard using sumif()