Learning Videos

Handy Formulas For Excel

MicrosoftMicrosoft
Basic10 episodes • 9m 48s17.1K views
Excel
Formulas
Spreadsheet
Data Analysis
Productivity

Episodes

A Formula Is What A Calculation Needs
1. A Formula Is What A Calculation Needs
1m 39s
In this video, discover how you can create formulas that make calculations easier in Excel.
In this video, discover how you can create formulas that make calculations easier in Excel.
The Formula For Division In Excel
2. The Formula For Division In Excel
0m 32s
Watch this tutorial to discover how to do division in Excel using just one formula.
Watch this tutorial to discover how to do division in Excel using just one formula.
Multiplying Couldn't Be Easier!
3. Multiplying Couldn't Be Easier!
0m 32s
Here's a simple formula to solve multiplication in Excel spreadsheets using cell data.
Here's a simple formula to solve multiplication in Excel spreadsheets using cell data.
Do Subtraction In A Flash!
4. Do Subtraction In A Flash!
0m 33s
Let's learn how to solve one of the basic arithmetic calculations, subtraction, in Excel.
Let's learn how to solve one of the basic arithmetic calculations, subtraction, in Excel.
Find Your Data Using VLOOKUP
5. Find Your Data Using VLOOKUP
0m 53s
In this video, find out what VLOOKUP is and how to use it to make searching for data in Excel easy.
In this video, find out what VLOOKUP is and how to use it to make searching for data in Excel easy.
How To Use The SUM Function In Excel
6. How To Use The SUM Function In Excel
0m 28s
Check out this quick and easy way to calculate the total amounts in Excel using the SUM formula!
Check out this quick and easy way to calculate the total amounts in Excel using the SUM formula!
Basics Of The IF Function In Excel
7. Basics Of The IF Function In Excel
0m 57s
Learn the basics of Microsoft Excel’s IF function.
Learn the basics of Microsoft Excel’s IF function.
Using The IFS Functions In Excel
8. Using The IFS Functions In Excel
1m 17s
Learn how to grade scores using Microsoft Excel’s IFS function.
Learn how to grade scores using Microsoft Excel’s IFS function.
Using SUMIFS In Microsoft Excel
9. Using SUMIFS In Microsoft Excel
1m 06s
Have the basics of Microsoft Excel’s SUMIF function at your fingertips
Have the basics of Microsoft Excel’s SUMIF function at your fingertips
Ways To Define And Use Names In Formulas
10. Ways To Define And Use Names In Formulas
1m 46s
Define and use names in formulas to make your data manageable.
Define and use names in formulas to make your data manageable.

Tools and templates

Boost your job preparation with these essential tools and templates.