Google Sheets Advanced Tutorial

Рет қаралды 29,718

Күн бұрын

Google Sheets Advanced Tutorial
2023 Update
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
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.

Пікірлер: 23

@LearnitTraining 10 ай бұрын

Exercise Files: learnitanytime.com/p/exercise-files-google-sheets-advanced-tutorial-2023

@user-ks8fq9jr9k 10 ай бұрын

Grateful For notifying me ❤ Waiting eargly for this powerful presentation

@LearnitTraining 10 ай бұрын

Hope you learned everything you wanted to!

@maayanzilberberg2523 7 ай бұрын

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

@kittohernandez3724 7 ай бұрын

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

@LearnitTraining 7 ай бұрын

Noted!

@user-tg3wy6iw5q 5 ай бұрын

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

@LearnitTraining 5 ай бұрын

This article may help: robots.net/tech/how-to-open-an-excel-file-in-google-sheets/

@berlysanscartier7526 4 ай бұрын

you need to save the files into your google drive to open them as google sheets

@heyarmaan 10 ай бұрын

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

@LearnitTraining 10 ай бұрын

We will look into it!

@educationworld4611 10 ай бұрын

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

@LearnitTraining 10 ай бұрын

To copy and insert rows in Google Sheets, you can use the following methods: Select the cells you want to copy, right-click and select copy. Then, select the cells where you want to paste the data, right-click and select paste. Use the keyboard shortcut Ctrl + C to copy the selected rows. Then, select a new row where you want to paste the copied data, and use the keyboard shortcut Ctrl + V to paste. From Google Sheets' menu bar, select Insert > Rows. Then, to add the new rows above your selected rows, choose "Insert X Rows Above." To add the new rows below your selection, choose "Insert X Rows Below."

@brendamartinezgomez2297 10 ай бұрын

👏🏻👏🏻

@LearnitTraining 10 ай бұрын

👏🏻👏🏻

@orjiprecious8592 5 ай бұрын

Nice

@LearnitTraining 5 ай бұрын

Thanks

@heyarmaan 10 ай бұрын

🎉 Waiting for The Miracle | From Bangladesh 🎉

@LearnitTraining 10 ай бұрын

See you Friday!

@heyarmaan 10 ай бұрын

I'm waiting eagerly to see you(@@LearnitTraining) 🥰

@educationworld4611 10 ай бұрын

How to protect sheet tabs in Google sheets like Excel?

@LearnitTraining 10 ай бұрын

To protect tabs in Google Sheets, you need to: Open your Google Sheets spreadsheet and go to the tab or sheet you want to protect. Right-click the tab or sheet and choose Protect sheet. In the Protect sheets & ranges side window, make sure that the Sheet button is pressed and the proper sheet is selected. Click on Set permissions and choose who can edit the sheet. You can restrict the editing to only you or specific people. Click on Done to save the changes.