Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Google Sheets Intermediate Tutorial

Learnit Training via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This intermediate tutorial takes your Google Sheets skills to the next level, building on basic spreadsheet knowledge to transform you into a data manipulation professional. Master powerful techniques for converting raw data into formatted tables, implementing advanced sorting and filtering, creating compelling visualizations with charts and sparklines, and building insightful pivot tables. Learn to enforce data integrity through validation rules, apply sophisticated conditional formatting that highlights entire rows based on custom criteria, link data between sheets effectively, and collaborate through comments. Perfect for professionals in finance, marketing, project management, or any field requiring organized data analysis, this 75-minute training provides practical skills to handle larger datasets and streamline workflows, giving you the confidence to structure, analyze, and present information with speed and precision.

Syllabus

Start 0:00
Introduction 0:09
Creating a Table 1:06
Sorting Data 10:09
Filtering Our Data 15:36
Visualizing Data with Charts 21:00
Sparklines 31:03
Working with Pivot Tables 38:06
Data Validation 48:59
Conditional Formatting 58:15
Linking Data 1:07:35
Inserting Comments 1:11:07
Conclusion 1:14:36

Taught by

Learnit Training

Reviews

Start your review of Google Sheets Intermediate Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.