Microsoft Excel 2016 Level 4 – Spreadsheet Analysis

This course is intended for participants who are familiar with Excel 2016.
Microsoft Excel 2016 Level 2 and 3
Upon completion of the course, participants will be able to accomplish the following:

• Use absolute and mixed references in a formula, as well as using financial functions.
• Use the Goal Seek feature and data tables.
• Create and manage scenarios, as well as create scenario reports.
• Define and solve problems with Solver, as well as create reports.
• Understand and utilize the various tools used to audit workbooks.