Google Sheets Advanced Tutorial
Google Sheets Advanced Tutorial
2023 Update
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: https://https://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:
https://www.learnitanytime.com
For Private Group Trainings please visit:
https://www.learnit.com/private-group...
Manuals: https://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.
In questa pagina del sito puoi guardare il video online Google Sheets Advanced Tutorial della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Learnit Training 01 gennaio 1970, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 36,322 volte e gli è piaciuto 723 spettatori. Buona visione!
