Excel Level 3: Spreadsheet Analysis

Live online events

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

  • 20
    Jun
    1 day, Thu 9:30 AM CST - Thu 5:30 PM CST
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 20
    Jun
    1 day, Thu 9:30 AM CST - Thu 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 18
    Jul
    1 day, Thu 9:30 AM CST - Thu 5:30 PM CST
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 18
    Jul
    1 day, Thu 9:30 AM CST - Thu 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 19
    Aug
    1 day, Mon 9:30 AM CST - Mon 5:30 PM CST
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 19
    Aug
    1 day, Mon 9:30 AM CST - Mon 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 17
    Sep
    1 day, Tue 9:30 AM CST - Tue 5:30 PM CST
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
  • 17
    Sep
    1 day, Tue 9:30 AM CST - Tue 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
None of these dates work for you? Suggest another date & time

Description

COURSE OBJECTIVES

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

  • Define and solve problems with Solver, as well as create reports

  • Understand and utilize the various tools used to audit workbooks

COURSE CONTENT

USING FUNCTIONS

Function Concepts; Absolute and Mixed References; Financial Functions

PROJECTING FIGURES

Goal Seek; Data Tables

SOLVER

Solver Concepts; Defining the Problem; Solving the Problem; Solver Reports

AUDITING WORKBOOKS

Auditing Concepts; Tracing a Worksheet; Evaluating Formulas; Locating & Correcting Errors in Formulas; Tracking
Cells in a Workbook

Prerequisites

Microsoft Office Excel Level 2 or equivalent knowledge.