Excel Level 3: Spreadsheet Analysis

Learn how to use financial functions, Goal Seek, Data Tables, Solver, and What-If Analysis tools to gain deeper insights.

Take your Excel skills beyond formulas and spreadsheets with powerful tools designed for forecasting, problem-solving, and decision-making. This hands-on course teaches participants how to analyze data, evaluate business scenarios, project outcomes, and audit complex workbooks using advanced Excel features.

Learn how to use financial functions, Goal Seek, Data Tables, Solver, and What-If Analysis tools to gain deeper insights and make more informed decisions.

Duration: 5 Hours
Format: Online or In-Person (Regina)
Cost: Starting at $245 + GST/PST (SK)

Who Should Attend?

This course is ideal for:

• Excel users who work with business data
• Financial and administrative professionals
• Project managers and analysts
• Anyone looking to improve forecasting and decision-making skills in Excel

Learning Outcomes

By the end of this course, participants will be able to:

✅ Use absolute and mixed cell references effectively

✅ Apply financial functions to business calculations

✅ Use Goal Seek and Data Tables to model outcomes

✅ Build and manage What-If Scenarios

✅ Create scenario reports

✅ Use Solver to optimize business decisions

✅ Audit workbooks and troubleshoot formula errors

✅ Evaluate and trace complex formulas

Course Topics

Using Functions

• Function concepts
• Absolute and mixed references
• Financial functions

Projecting Figures

• Goal Seek
• Data Tables

Performing What-If Analysis

• Scenario concepts
• Creating and managing scenarios
• Scenario reports

Using Solver

• Defining and solving problems
• Solver options
• Solver reports

Auditing Workbooks

• Tracing worksheet calculations
• Evaluating formulas
• Finding and correcting errors
• Auditing best practices
• Our team will be happy to assist with cancellations, refunds, and registration changes.

Prerequisites

Excel Level 2 or equivalent knowledge is recommended.

Participants should be comfortable working with formulas, functions, worksheets, and workbook management features.

Cancellation & Refund Policy

If you need to cancel your registration, request a refund, or discuss transfer options, please contact a MicroAge Training Specialist directly.

📧 AppTraining@microagesask.com

Our team will be happy to assist with cancellations, refunds, and registration changes.