Self-paced course
Google Sheets for Data Analytics
Master spreadsheets to analyze, organize, and store data. Learn how to process datasets, use functions for calculations, create pivot tables, and visualize your results with charts and graphs.
4.7
1,154 reviews
Get started
2,527
students enrolled
Perfect for
Intermediate
Time to invest
10+ mins/day
Study AId
AI mentor, peers

Join students

enrolled

Our top grads now work for

Learning roadmap

13 lessons 30+ tasks
1
Spreadsheet — the Basic Tool for Analytics
2
Data Importing
3
Basic Data Types
4
Formulas and Built-In Functions
5
Cell Reference Types
6
Data Cleaning
7
Text Processing
8
Working with Ranges
Lessons
Conditional Range Functions
Sales Analytics Task
Named Ranges
Sales Analytics with Named Ranges Task
Filters
Filtering Sales Data Task
Sorting
Sorting Sales Data Task
SORTN Cases
Show Highest or Lowest Values Task
Conditional Formatting
Formatting Data Task
Finding Top-5 Task
Summary
9
Table Relationships
Lessons
Linking Tables
VLOOKUP Function
Get Employee Data Part Task
More Cases with VLOOKUP
Get Employee Data Part Task
VLOOKUP Advanced
Sales Data Collection Task
HLOOKUP Function
Get Employee Data Part Task
Summary
10
Pivot Tables
Lessons
Aggregation of Data
The Basic Pivot Table
Two Aggregations
Pivot Table with Multiple Categories: Example 1
Pivot Table with Multiple Categories: Example 2
Pivot Table with Filters
Summary
Category Analysis Task
Reviews by Customers Task
11
Data Visualization
Lessons
Types of Data Visualizations
Visualization of Dynamics: Line Charts
Visualization of Distributions: Histograms
Visualization of Counting and Aggregations
Visualization of Relationships
Selling Price Distribution Task
Rating by Category Task
Rating by Color Task
Geo Charts
Population of EU countries Task
Best and Worst Practices in Visualization
Useful Links
Summary
12
Data Exporting and Sharing
Lessons
Export Data in Different Formats
Share your Spreadsheet with Others
Collaborative Work and Version Control
Google Sheets Functions Quiz
Summary
13
Google Sheets Summary
Lessons
Excel vs. Google Sheets
Pros and Cons of Spreadsheets
The Role of Spreadsheets in Data Analytics
AI Tools
Module Summary Task Overview
ABC Analysis
Module Task Description
Module task
Summary
Tech Check Questions

Choose your plan, get hands-on

Get full access to courses and tools that make learning fun and effective.
All-in-one platform
80% hands-on tasks
Real-life projects
Helpful community
AI Buddy support
Where do you start?
Right here. Knowely is a one-stop shop that gets you from zero to Pro at your own pace. No more time wasted on looking for resources, because we have everything you need.
Learn with 80% practice
Code directly on the platform
Move faster with our AI Mentor
Browse community solutions
Connect with fellow students
Race through the leaderboard
Discover our platform

What do students say of us?

4.7

1,762 ratings
5 stars
71%
4 stars
18%
3 stars
8%
2 stars
2%
1 star
1%
Clear course, no adds, no "water", no hidden payments or some "must buy to pass to next level". Interesting course, a lot of practice, theory and links to more materials. Very helpful AI assistant built-in. I use it on mobile and as app and on desktop.

Natalie N.

I have been practicing and learning online, my first course has been the Python one and so far, it is very intuitive and easy to follow, plenty of practical exercises and a clear and simple explanation, I love it.

Oscar M.

Knowely its great academy. The tasks its good and you make real project while u learning.

Velislav B.

I love my experience in knowely really helped me out in my journey in being a front end developer and its easy to read and understand concepts...and have a nice community of students in which we help each other out

Nora S.

I tried the product and it is indeed user-friendly and quite engaging. I used it almost every day and it was easy to use and had everything I needed and nothing extra. I recommend it since it is cool and stands out among other platforms I know.

Mykola M.

I have never been taught coding this way. The way you guys break it down is so easy, I actually understand this.

Jacob C.

Well structured, robust and affordable courses. Learn at your own pace and take responsibility for research and digging deeper into topics through additional resources and loads of practice tasks.

Ayodeji A.

I do enjoy learning with the help of the platform. I was surprised by this LMS's capabilities. Well-structured materials and an advanced compiler boosted my coding skills.

Roman S.

The interactive support provided by the AI Buddy is ingenious

Ralph E.

Show more

Learn to code in our community of mates

Looking for something else?

You often ask

Can I switch to a different course or career path after this one?
You’ll get unlimited access to all the content on the platform under one subscription. So you can switch career paths, or learn any courses anytime
What are the payment and billing options?
You can pay by card, PayPal, Google and Apple Pay. Duration of the plan will depend upon the subscription plan you choose.
Will I be supported in any way?
We’ve got your back. If you get stuck with task, our AI Buddy (our users’ favorite feature) will help you out. You can also chat with other students in the community chat, and our support is just a message away via WhatsApp or email.
Will I get a certificate?
Completion certificates are given to students who finish 100% of the course and their portfolio projects. We aim at giving knowledge more than a mere paper :)