Google Sheets Advanced Tutorial

Google Sheets Advanced Tutorial

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, and more.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Google Sheets classes:

For Private Group Trainings please visit:

Start 0:00
Introduction 0:03
Single and Multi-Level Sorting 0:11
Filtering Records in a List 3:47
Search Filter and Filter by Condition 7:32
Custom Filter Views 10:07
Inserting Data Charts 13:15
Formatting and Editing Chart Elements 14:58
Adding and Removing Data from Charts 22:48
Inserting Sparklines 25:11
Alternating Colored Rows 30:46
Alternating Colors Button 34:08
Creating a Pivot Table 35:30
Creating a Pivot Chart 44:21
Filtering Within Pivot Tables Using Slicers 46:48
Using the IF Function 49:12
Introduction to Nesting Functions 57:13
VLOOKUP Function 1:00:39
Using the IFERROR Function 1:08:01
Creating and Applying Names in a Worksheet 1:11:02
Summary-Based Functions SUMIF(S) and AVERAGEIF 1:13:02
Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns 1:19:41
Sharing and Managing Permissions 1:24:52
Macros 1:28:14
Conclusion 1:34:23

#GoogleSheets

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[LearnitTraining]

How to edit the sheet:


Click the link
Select File
Select Copy

Or

Click the link
Select File
Select Download
Choose the format you wish to download
Click Save

[ceciliafarkas]

You are an amazing teacher. Perfect speed, easy to follow instructions, straight logic, no unnecessary repetition. Loved it!

[ChaimaDjaa]

This is an incredible tutorial I'm starting a new job next week and wanted to refresh my memory a bit but ended up learning so many new tricks you're an incredible teacher you simplify everything thank you so so much <333

[romyhistorillo]

Learning from excel to google sheet wasn't a steep learning curve for me because of this tutorial. Thanks so much for creating informative videos.

[akshatmeena]

For those people who check the ocmments to see if the video is fit to watch/learn. Then, heer's my testimonial, Just go for it. This one is surely to make to grasp each and everything easily.

[itu]

OMG I NEVER SEE JUST LIKE THIS CHANNEL,
I HAD LEARNED TO MANY COURSES FROM THIS CHANNEL :THANK YOU BOSS (:

[RiskyInvestor]

learned a job skill in 2 hrs, easy & quick, thanks joe

[jeffthechickenking]

Thank you so much! This was a great course, so well explained, and so easy to follow along with! I tried it out every step of the way, and now I feel like a pro 😄 I really can't thank you enough for making this!

[abhishektripathi]

00:03 The main point is about sorting and filtering data in Google Sheets.
05:42 Filtering and Custom Filter Views in Excel
16:48 You can customize the chart appearance and colors to create a visually appealing chart.
21:06 You can customize the legend, axis, grid lines, and add data to your chart.
31:27 Use banded rows or alternating colors in Google Sheets for better data visualization and readability.
36:40 Google's pivot table tool helps analyze data and answer questions instantly.
47:31 Slicers can be a great tool to utilize and create an interactive dashboard.
52:39 Automate calculations based on sales data.
1:02:53 Using VLOOKUP in Excel to search for specific data
1:07:53 Use the iferror function to handle errors in lookup formulas
1:18:27 Generate summary in JSON format
1:23:45 Learn how to share a Google Sheets file with others
1:34:23 Thank you for choosing Learn It
Crafted by Merlin AI.

[faheemqadri]

Great way to teach in a simple way with details. No time waste like others. Big thank you from India

[arindambasak]

I love you Joe, your voice is so good and the way you minutely discussed so many topics in this video is just amazing, I am loving to learn from you :)

[DivyanshuBansal-cl]

Thanks for the great walkthrough! You have an amazing teaching style, with a coherent thought process and realistic examples. The presentation had a logical flow, and the way you explained each concept, building on the previous ones, was excellent. Thanks, Joe! 😊

[is]

It would be really nice if you included a link to a practice sheet like yours to follow along. Thank you, great content!

[DevanshuJain-nn]

HATS OFF, YOU GAVE SUCH VALUABLE INFORMATION FOR FREE.

[davidmmmc]

Thank you! however could you include the practice sheet for sorting, filtering, the first one your are using?

[MGSV]

What an excellent tutorial! I learned so much ... and I thought I knew Sheets well. Thank you

[mereymeiram]

In the exercise files there are no:
Sorting
Filtering
Charting
Sparkliness
Conditional Formatting
Pivot Table

If you provide us the video can you please provide proper exercise files too?

[channibedi]

An excellent tutorial with exceptionally perfect presentation skills! No time waster, to the point. Much appreciated!

[ridmagamage]

This is brilliant! I learned everything from the scratch! Keep up the good work! Thank you so much!

[karamshahrour]

Perfect is the only word that describe your videos, thanks a lot for this amazing work