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

Overview

Learn essential Excel skills in this comprehensive 26-minute video tutorial. Master basic math formulas, popular functions like SUM, COUNT, AVERAGE, and VLOOKUP, and advanced techniques such as working with dates, combining columns, and using conditional functions. Follow along with timestamps for easy navigation, download the practice file, and gain practical knowledge on utilizing the function wizard. Perfect for beginners and intermediate users looking to enhance their Microsoft Excel proficiency.

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

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.