Excel 2016: Frequently Used Formulas and Functions

This training course for Microsoft Excel 2016 will help advance your Excel capabilities by teaching you the most commonly used formulas and functions to calculate and analyze data. To begin, you’ll learn how to implement simple predefined formulas such as the SUM, AVERAGE, COUNT, and IF functions. You'll also learn many of the more complex formulas such as the VLOOKUP and HLOOLUP functions. In addition, you’ll learn how to customize formulas to help you manipulate data. You’ll explore ways of linking and consolidating your worksheets so that you can easily reference cells between worksheets. Auditing is essential to avoiding errors, and by the end of the course you’ll also know how to identify the precedent and dependent cells and evaluate the formulas in your worksheet.

Learning objectives:

• Prevent errors by auditing your worksheets and evaluating the formulas
• Navigate through multiple worksheets by linking and consolidating your data
• Improve your productivity by implement time-savings formulas
• Calculate data using predefined and custom formulas and functions