Microsoft Excel Level 3 - Spreadsheet Analysis (2016, 2019) - Corporate Training - Algonquin College Corporate Training

Make a selection

About This Course

Prerequisites

Who Should Attend

What You’ll Learn

Materials and Fees

Additional Notes

Contact

About This Course

Learn advanced spreadsheet analysis by mastering Excel functions, Goal Seek, Data Tables, Scenario concepts and reports, Solver tool, and workbook auditing. Topics include:

Using Functions
Projecting Figures
Performing What-If Scenarios
Using Solver
Auditing Workbooks

Prerequisites

The learners are expected to be familiar with concepts covered in MS Excel Level 2.

Who Should Attend

This course is intended for participants who are familiar with Microsoft Excel 2016.

What You’ll Learn

Upon completion of the course, participants will be able to accomplish the following:

Use absolute and mixed references in a formula
Use financial functions
Use the Goal Seek feature and Data Tables
Create and manage scenarios
Create scenario reports
Define and solve problems with Solver
Create reports,
Understand and utilize the various tools used to audit workbooks

Course Materials and Fees

Course materials will be provided to each learner. Required Software: MS Excel 2016 or MS Excel 2019 required (not included with course materials). MS Excel 2013 or earlier not supported. This course does not support Mac computers.