Google Sheets Advanced Tutorial
Learn Skills Daily
@learnskillsdailyAbout
BECOME A MEMBER TO UNLOCK AD-FREE VIDEOS Learn Skills Daily provides on-demand video courses on a wide range of software and subjects. From the deep data tools of Microsoft Excel to the endless creative possibilities of Adobe Photoshop to the collaborative concoction of Microsoft Teams, we've got you covered. At Learn Skills Daily, we've been fine-tuning our teaching methodology for over 25 years. Our videos are specifically designed to emulate the same great experience you get from a live class. Plus, you can learn at your own pace, following along with our try-it-yourself exercise files. If you're serious about learning, we're serious about providing you with a better learning platform.
Latest Posts
Video Description
Google Sheets Advanced Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/425rhbw2 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. 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 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.
You May Also Like
Master Google Sheets Faster
AI-recommended products based on this video
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad
TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)
TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)