Learn how to use formulas and functions in Google Sheets with this tutorial. The course covers basic math formulas, popular functions like SUM, COUNT, AVERAGE, MIN, and MAX, as well as advanced topics such as working with date and time functions, combining columns, using IF statements, VLOOKUP, and conditional functions. The teaching method includes practical demonstrations using a sample spreadsheet. This course is designed for beginners looking to enhance their skills in Google Sheets.
How to Use Formulas and Functions in Google Sheets
Overview
Syllabus
Intro.
Basic math formulas.
Starting with the SUM Function in Google Sheets.
The COUNT function.
AVERAGE, MEDIAN and MODE functions.
MIN and MAX functions in Google Sheets.
Functions and formulas with Date and time in Google Sheets.
Using formulas to combine columns.
If statements in Google Sheets.
How to use VLOOKUP in Google Sheets.
Conditional functions (SUMIF, SUMIFS, COUNTIF etc.).
Taught by
Teacher's Tech
