Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

Google Sheets Advanced Tutorial

Автор: Learn Skills Daily

Загружено: 2023-08-11

Просмотров: 55100

Описание:

Google Sheets Advanced Tutorial
2023 Update

Get Ad-Free Training by becoming a member today!
   / @learnskillsdaily  

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/3wtpd253

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.

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
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Google Sheets Advanced Tutorial

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

array(20) { ["3SdEo2Se-Ac"]=> object(stdClass)#11017 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "3SdEo2Se-Ac" ["related_video_title"]=> string(45) "Google Sheets Full Course Tutorial (2+ Hours)" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> NULL } ["tCVNiIvHqZM"]=> object(stdClass)#11024 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "tCVNiIvHqZM" ["related_video_title"]=> string(38) "Google Sheets for Excel Users Tutorial" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> NULL } ["cWGQncQxaHI"]=> object(stdClass)#11015 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "cWGQncQxaHI" ["related_video_title"]=> string(49) "Learn Google Sheets – Full Course for Beginners" ["posted_time"]=> string(28) "11 месяцев назад" ["channelName"]=> NULL } ["POZorIoSK5c"]=> object(stdClass)#11025 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "POZorIoSK5c" ["related_video_title"]=> string(52) "10 INCREDIBLE things Google Sheets can do Right Now!" ["posted_time"]=> string(19) "1 год назад" ["channelName"]=> NULL } ["HYkAmQs3Y94"]=> object(stdClass)#11009 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "HYkAmQs3Y94" ["related_video_title"]=> string(89) "Administrative Assistant Office Procedures Training Classes & Courses. Earn a Certificate" ["posted_time"]=> string(21) "3 года назад" ["channelName"]=> NULL } ["dLDUE-s8lzc"]=> object(stdClass)#11028 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "dLDUE-s8lzc" ["related_video_title"]=> string(48) "Excel 2021 Productivity Tips and Tricks Tutorial" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> NULL } ["O0k9uE4xnD0"]=> object(stdClass)#11013 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "O0k9uE4xnD0" ["related_video_title"]=> string(44) "10 Google Sheets Tips You DON'T Want to Miss" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> NULL } ["t0B0Tgz0b-0"]=> object(stdClass)#10992 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "t0B0Tgz0b-0" ["related_video_title"]=> string(31) "Google Sheets Advanced Tutorial" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> NULL } ["kSNxzoe9RcM"]=> object(stdClass)#11003 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "kSNxzoe9RcM" ["related_video_title"]=> string(27) "Excel Pivot Tables Tutorial" ["posted_time"]=> string(19) "1 год назад" ["channelName"]=> NULL } ["5e6LWOvNq_8"]=> object(stdClass)#11026 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "5e6LWOvNq_8" ["related_video_title"]=> string(31) "Google Sheets Beginner Tutorial" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> NULL } ["mRHlvRRERgs"]=> object(stdClass)#11016 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "mRHlvRRERgs" ["related_video_title"]=> string(47) "15 Functions in Google Sheets You NEED to know!" ["posted_time"]=> string(19) "6 лет назад" ["channelName"]=> NULL } ["PLoyECfvEFOjb_zzI_ugaL5e4B_2FGwVG3"]=> object(stdClass)#11022 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(34) "PLoyECfvEFOjb_zzI_ugaL5e4B_2FGwVG3" ["related_video_title"]=> string(25) "Google Workspace Training" ["posted_time"]=> string(0) "" ["channelName"]=> NULL } ["oCKvAcXTLZo"]=> object(stdClass)#11010 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "oCKvAcXTLZo" ["related_video_title"]=> string(38) "Google Sheets Query Function Explained" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> NULL } ["7tx1H7sxSL0"]=> object(stdClass)#11008 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "7tx1H7sxSL0" ["related_video_title"]=> string(42) "Excel 2021 Full Course Tutorial (3+ Hours)" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> NULL } ["N2opj8XzYBY"]=> object(stdClass)#11006 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "N2opj8XzYBY" ["related_video_title"]=> string(27) "Google Sheets - Full Course" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> NULL } ["NTGh0fZjNkU"]=> object(stdClass)#11007 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "NTGh0fZjNkU" ["related_video_title"]=> string(30) "Google Forms Beginner Tutorial" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> NULL } ["XGvCT3IeYdA"]=> object(stdClass)#11004 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "XGvCT3IeYdA" ["related_video_title"]=> string(94) "How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> NULL } ["YGifEp8d8R8"]=> object(stdClass)#11005 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "YGifEp8d8R8" ["related_video_title"]=> string(50) "Top 5 Features in Google Sheets for Advanced Users" ["posted_time"]=> string(21) "4 года назад" ["channelName"]=> NULL } ["n2DxXffRxBM"]=> object(stdClass)#10993 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "n2DxXffRxBM" ["related_video_title"]=> string(49) "Google Sheets BEATS Excel with THESE 10 Features!" ["posted_time"]=> string(19) "5 лет назад" ["channelName"]=> NULL } ["H2PnvZZ-2J4"]=> object(stdClass)#10994 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "H2PnvZZ-2J4" ["related_video_title"]=> string(64) "Interactive Google Sheets Dashboard Tutorial: Company Sales Data" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> NULL } }
Google Sheets Full Course Tutorial (2+ Hours)

Google Sheets Full Course Tutorial (2+ Hours)

Google Sheets for Excel Users Tutorial

Google Sheets for Excel Users Tutorial

Learn Google Sheets – Full Course for Beginners

Learn Google Sheets – Full Course for Beginners

10 INCREDIBLE things Google Sheets can do Right Now!

10 INCREDIBLE things Google Sheets can do Right Now!

Administrative Assistant Office Procedures Training Classes & Courses. Earn a Certificate

Administrative Assistant Office Procedures Training Classes & Courses. Earn a Certificate

Excel 2021 Productivity Tips and Tricks Tutorial

Excel 2021 Productivity Tips and Tricks Tutorial

10 Google Sheets Tips You DON'T Want to Miss

10 Google Sheets Tips You DON'T Want to Miss

Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial

Excel Pivot Tables Tutorial

Excel Pivot Tables Tutorial

Google Sheets Beginner Tutorial

Google Sheets Beginner Tutorial

15 Functions in Google Sheets You NEED to know!

15 Functions in Google Sheets You NEED to know!

Google Workspace Training

Google Workspace Training

Google Sheets Query Function Explained

Google Sheets Query Function Explained

Excel 2021 Full Course Tutorial (3+ Hours)

Excel 2021 Full Course Tutorial (3+ Hours)

Google Sheets - Full Course

Google Sheets - Full Course

Google Forms Beginner Tutorial

Google Forms Beginner Tutorial

How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)

How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)

Top 5 Features in Google Sheets for Advanced Users

Top 5 Features in Google Sheets for Advanced Users

Google Sheets BEATS Excel with THESE 10 Features!

Google Sheets BEATS Excel with THESE 10 Features!

Interactive Google Sheets Dashboard Tutorial: Company Sales Data

Interactive Google Sheets Dashboard Tutorial: Company Sales Data

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]