Excel Formulas & Functions - Find Answers in Your Excel Data (Updated)

Duration: 1.5 hour | Size: 367 MB



Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Learn on Excel 2010, Excel 2013, or Excel 2016

What you'll learn

Identify formulas and functions and know the difference between the two.
Locate and use any of the functions in Excel using various methods, such as the Formula Tab.
Use the 7 most important Excel functions in common spreadsheet computations.
Understand the important difference between Absolute and Relative cell references to increase your computing power.
Identify the various parts of an Excel formula so you can create or modify formulas to fit your needs.
Use the SUM function in Excel
Use AVERAGE and AVERAGEA functions in Excel
Use COUNT and COUNTA functions in Excel
Use IF functions in Excel
Use SUMIF and SUMIFS functions in Excel
Use COUNTIF and COUNTIFS functions in Excel
Use VLOOKUP in Excel
Use LEFT, RIGHT and MID functions in Excel

What's included in the course?

What is a formula? What is a function?

The anatomy of a formula and how to create one.

How to use the SUM function.

How to use the AVERAGE and AVERAGEA functions.

How to use the COUNT and COUNTA functions.

How to use the IF function.

How to use the SUMIF and SUMIFS functions.

How to use the COUNT and COUNTIFS functions.

How to use the popular VLOOKUP function.

How to use RIGHT, LEFT and MID to sort data easily.

A complete demonstration of how to use each function and what to use if for.

*