How to use Formulas and Functions in Google Sheets
Teacher's Tech
@teacherstechAbout
🌟 This is the channel where tech finally makes sense! I'm Jamie, an avid tech enthusiast and educator, and I'm here to make your journey into tech a whole lot easier. Forget complicated jargon and confusing tutorials. I make beginner-friendly videos that explain tech concepts in plain English, step by step. In today's fast-paced world, the right tech tools can be a game-changer. That's why I'm here! I break down important business and education apps into simple steps, so you can unlock their power and boost your productivity. If you're ready to get started with tech without the overwhelm, make sure to subscribe to my channel 💡
Latest Posts
Video Description
Google Sheets formulas and functions for beginner's 2021 tutorial. I will show you how to use formulas and functions in Google Sheets. I will start with basic math formulas in Google Sheets and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video. Here’s the link to the practice spreadsheet: https://docs.google.com/spreadsheets/d/195g9zTLzUyuHmx89vGGz0dD7pN10mCwV3_0nZMO11Ik/edit?usp=sharing 0:00 Intro 0:49 Basic math formulas 3:35 Starting with the SUM Function in Google Sheets 7:05 The COUNT function 8:50 AVERAGE, MEDIAN and MODE functions 10:32 MIN and MAX functions in Google Sheets 11:19 Functions and formulas with Date and time in Google Sheets 14:04 Using formulas to combine columns 15:44 If statements in Google Sheets 19:01 How to use VLOOKUP in Google Sheets 22:12 Conditional functions (SUMIF, SUMIFS, COUNTIF etc.) Interested in how I make my videos? Here’s a tutorial: https://youtu.be/hNzulrauu4Y
Fight Aging With These Must-Have Tools
AI-recommended products based on this video
AMVR Facial Interface Compatible with Meta/Oculus Quest 3 Face Pad Accessories, with Soft PU Face Cushion Replacement and Breathable Ice Silk Cotton, Air-Circulation(Not for Quest 3s)
EcoNour Windshield Cover for Ice and Snow | Heavy Duty 600D Oxford Fabric | Windshield Protector for Cars, SUVs, Trucks | Secure Fit Waterproof Frost Cover | Winter Car Accessories | Medium (69"x42")
AstroAI 27" Snow Brush and Detachable Ice Scraper with Ergonomic Foam Grip for Cars, Trucks, SUVs (Heavy Duty ABS, PVC Brush, Orange)
Cervical Neck Pillow, Memory Foam Pillows for Neck and Shoulder Pain Relief, 2 Heights Ergonomic Pillow with Breathable Ice Silk Cover, Neck Support Pillow for Side Back Stomach Sleepers, Odorless OEKO-TEX STANDARD 100
HICC PET Dog Wound Care Hydro Gel, Hot Spot Treatment for Dogs, Soothes Inflammation, Prevents Infection, Treats Bites, Scratches & Skin Ulcers, Cat Wound Care Solution, 100ml
LANEIGE Water Sleeping Mask: Hydrating Korean Overnight Mask with Squalane & Probiotic-Derived Complex, for Bright, Glowing Skin & Barrier Support
Premium Nose Pore Strips - Deep Cleansing Blackhead Remover for Men & Women, Oil & Dirt Removal, 30 Count, Designed in Canada
