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