Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial
2023 Update

Get Ad-Free Training by becoming a member today!

Who it's for: Anyone looking to gather, format, and interpret data in a spreadsheet.

What it is: Google Sheets is Google’s free, web-based spreadsheet application that mirrors the magic of Microsoft Excel, with some standout features and key differences as well.

What you'll learn: First, students will be shown how to navigate the app. Then, they’ll learn the basics like creating and sharing spreadsheets. Next, they’ll learn how to calculate data with functions and formulas, as well as how to filter and sort all their data. Finally, users will get some hands-on time with popular features like Pivot Tables, AutoFill, VLOOKUP, Macros, real-time collaboration, and more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:09
List, Format, and Sort 0:46
Multi-Column Sort 3:13
Filters 5:21
Conditional Filters and Filtered Views 8:18
Creating Charts 11:57
Editing Charts 14:49
Removing and Deleting Chart Data 18:04
Sparklines 20:30
Formatting with Alternating Row Colors 23:09
Pivot Tables 24:22
Pivot Charts 28:36
Named Ranges 31:16
IF Functions 36:05
Nested Functions 39:10
VLOOKUP 42:15
SUMIF and AVERAGEIF 45:43
SUMIFS 49:42
AVERAGEIFS 52:19
IFERROR 54:49
LEFT and RIGHT 57:12
CONCATENATE 59:49
Sharing Files 1:01:53
Real-Time Authoring 1:03:38
Google Sheets Add-Ons 1:05:37
Introduction to Google Apps Scripts 1:07:32
Conclusion 1:09:50

#googlesheets #googlesheetstutorial #googleworkspace #googleworkspacetutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[maayanzilberberg]

Hello,
I want to make a todo list with dropdown. the a column title will be number and the b column title will be name with dropdown of a b c d names.
i want that if i have the number 1 in column a1 so the dropdown is column b1 will appear.
how to achieve it? thanks

[ksfqjrk]

Grateful For notifying me ❤
Waiting eargly for this powerful presentation

[kittohernandez]

You have an incorrect formula at 40:00 at cell E2 . It should be >2000.

[educationworld]

Also, how to copy and insert the copied rows in sheets like Excel?

[heyarmaan]

could you upload "Complete C Programming + DSA (Data Structure and Algorithm "?

[tgwyiwq]

This is such a great video but how to I download exercise files to google doc. They keep going to my excel.

[heyarmaan]

🎉 Waiting for The Miracle | From Bangladesh 🎉

[educationworld]

How to protect sheet tabs in Google sheets like Excel?

[tbad]

Tutorial is about google sheets. but why all files on the video have extensions ".xlsx"?