Microsoft Excel Level 3 – Spreadsheet Analysis (2016, 2019)

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

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

Who should attend

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

Prerequisites

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

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.

Microsoft Learn for Educators (MSLE) Member

$350

1 day

5 session(s) available

Loading session(s)

Choose a session

Select a date to register

For more information about individual or group registration please call 1-833-282-6852 or email training@algonquincollege.com.

Government of Canada Employees

Take advantage of our Standing Offers and Supply Arrangements with the Government of Canada to receive a discount when you register for training.

Download the course brochure