BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

How to Use Formulas and Functions in Microsoft Excel

Teacher's Tech via YouTube

Start learning Write review

Overview

This course teaches learners how to use formulas and functions in Microsoft Excel, starting with basic math formulas and progressing to popular and powerful functions like SUM, COUNT, AVERAGE, VLOOKUP, and conditional functions. The teaching method includes a video tutorial with practical demonstrations and examples. The course is intended for beginners who want to enhance their Excel skills and learn how to efficiently use formulas and functions in spreadsheets.

Syllabus

Intro.
Basic math formulas.
Starting with the SUM Function in Excel (with shortcuts).
The COUNT function.
Take a look at the status bar in Excel.
AVERAGE, MEDIAN and MODE functions.
MIN and MAX functions in Microsoft Excel.
Functions and formulas with Date and time in Excel.
Using formulas to combine columns.
If statements in Excel.
How VLOOKUP works.
Conditional functions (SUMIF, SUMIFS, COUNTIF, etc.).
How to use the function wizard.

Taught by

Teacher's Tech

Reviews

Start your review of How to Use Formulas and Functions in Microsoft Excel

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.