Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Useful for Excel 2010, Excel 2013, or Excel 2016
Description :
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.
Get Course