Corporate Training - Algonquin College
My Learning Portal
Corporate Training - Algonquin College
Home
All Courses
Microsoft Excel Level 3 - Spreadsheet Analysis (2016, 2019)
Microsoft Excel Level 3 - Spreadsheet Analysis (2016, 2019)
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.

Additional Notes

Microsoft Learn for Educators (MSLE) Member

Contact

For more information about individual or group registration or to be notified of upcoming dates, please contact us.

Call: 1-833-282-6852

Email: training@algonquincollege.com

$ 350
1 Day
Select a Session
Quantity

If you are registering 8 or more participants in one class, please contact us for group registration.

Courses are posted up to 12 months in advance.

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.

For learners requiring special accommodations, please visit Documentation Requirements | Centre for Accessible Learning (algonquincollege.com),fill out the required form and send supporting documentation to trainingacct@algonquincollege.com. Please note that we need a minimum of three business days to accommodate your request.