Google Sheets Formulas Tutorial
Kevin Stratvert
@kevinstratvertAbout
Learn how to do anything, with high-quality how-to videos. I teach millions of students around the world every month across YouTube, Instagram, TikTok, and other social media platforms to help them master technology, achieve more at work, and succeed at school. I've been featured on CNBC, Fast Company, GeekWire, and Windows Central. I'm an ex-Microsoft Product Manager and now a full-time education content creator. 📩 NEWSLETTER Get the top tech tips and tricks delivered to your inbox each week: https://kevinstratvert.com/newsletter/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 💻 OFFICIAL WEBSITE http://www.kevinstratvert.com 🪙 SUPPORT THE CHANNEL Support the channel with your Amazon purchases: https://amzn.to/3kCP2yz (Disclosure: this link gives me a small commission to support videos on this channel. The price to you is the same.)
Latest Posts
Video Description
Learn how to use formulas and functions in Google Sheets. 👋 Additional resources: - Access the spreadsheet I used if you'd like to follow along: https://docs.google.com/spreadsheets/d/1lRrxezy1dKcJLrZot5BxBBKffEP8Ys-c6qUMirM9OTA/edit?usp=sharing - Read about all functions available in Google Sheets: https://support.google.com/docs/table/25273 ⌚ Timestamps 0:00 Introduction 0:33 Add & formula basics 2:08 Subtract 2:48 Multiply 3:50 Divide 4:37 Bring it all together 5:44 Min 6:16 Max 6:38 Mean 7:23 Median 7:52 Mode 8:24 Sum 9:37 Sumif 11:09 Count 12:01 Counta 12:33 Countif 13:26 Concatenate 14:41 If 16:41 Vlookup 19:29 Convert 20:50 Today & Now 21:30 Len / character length 22:25 Wrap up 📃 Watch related playlists and videos - Google: https://www.youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ 🚩 Connect with me on social: - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
Upgrade Your Photo Gear
AI-recommended products based on this video
COTUBLR 31 Inch Computer Desk, Home Office Desk, Simple Modern Small Desk for Bedroom, Writing Desk with Storage Bag, Study Table for Students, Grey Oak
Kaiess 62" Tripod for iPhone, Selfie Stick Tripod & Phone Tripod Stand with Remote, Cell Phone Tripod for iPhone, Extendable Travel Tripod Compatible with iPhone 14/13/12 Pro Max/Android
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314
SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338
NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048
SmallRig ZV-E10 II Base Plate for Sony Alpha ZV-E10 II, Bottom Mount Plate with Quick-Release Plate for Arca, QD Socket, Hand Strap Hole, 1/4"-20 Threaded Hole - 4950