Google Sheets Advanced Tutorial
Google Sheets Advanced Tutorial
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/yc3kv5k7
Who it's for: This class is for individuals who already have a solid understanding of the basics of Google Sheets and are ready to elevate their skills to an advanced level. It is designed for professionals, analysts, students, and anyone who frequently works with data and wants to become more efficient in organizing, analyzing, and automating spreadsheets. Whether you're managing financial information, running data reports, or just looking to optimize your workflow, this course provides powerful tools like named ranges, advanced lookup functions, conditional logic, and smart chips to help you work smarter, not harder.
What it is: Google Sheets is a cloud-based spreadsheet application within Google Workspace that lets users create, edit, and collaborate on data in real time from any device with an internet connection. It offers familiar spreadsheet functionality—such as formulas, functions, formatting, and charting—while uniquely enabling seamless sharing, simultaneous multi-user editing, automatic version history, and integration with other Google services like Forms and Drive. With built-in tools like Smart Fill, conditional formatting, and add-ons, Google Sheets empowers individuals and teams to organize, analyze, and visualize data efficiently without installing any software locally
What you'll learn: In this advanced Google Sheets course, students will learn how to leverage powerful spreadsheet tools to streamline data analysis and improve productivity. Key skills include using named ranges for better organization, mastering the XLOOKUP function for dynamic data retrieval, and applying logical functions like IF and IFS for decision-making automation. Students will also explore database functions such as COUNTIF, SUMIF, and AVERAGEIF, and learn how to calculate loan payments using the PMT function. Additionally, they will gain hands-on experience with Smart Chips to enhance interactivity, collaboration, and contextual data management within their spreadsheets.
Start 0:00
Introduction 0:09
Creating Named Ranges 1:18
Naming Multiple Ranges 6:32
Accessing Name Ranges Manager 8:01
XLOOKUP Function 9:09
XLOOKUP Approximate Match 15:33
Data Mining with XLOOKUP 19:50
IF & IFS Function 28:25
Database Functions 37:31
PMT Function 45:38
Smart Chips 54:30
Conclusion 1:01:44
#sheets #tutorial #googleworkspace
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.
On this page of the site you can watch the video online Google Sheets Advanced Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Learn Skills Daily 01 January 1970, share the link with friends and acquaintances, this video has already been watched 17,938 times on youtube and it was liked by 400 viewers. Enjoy your viewing!
