Excel Level 3: Spreadsheet Analysis

Reset

Live online events

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

  • 15
    Dec
    4 hours, Fri 8:30 AM CST - Fri 12:30 PM CST
    In Person
    • $210.00 excl. GST + PST (SK)
    Contact training coordinator for registrations options.
  • 15
    Dec
    4 hours, Fri 8:30 AM CST - Fri 12:30 PM CST
    Online
    • $210.00 excl. GST + PST (SK)
    Contact training coordinator for registrations options.
  • 26
    Feb
    4 hours, Mon 8:30 AM CST - Mon 12:30 PM CST
    In Person
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
    Register
  • 26
    Feb
    4 hours, Mon 8:30 AM CST - Mon 12:30 PM CST
    Online
    • Group Rates Apply (6 or more) $202.02 excl. GST + PST (SK)
    • $210.00 excl. GST + PST (SK)
    Register
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.

Similar courses

Powered by Arlo training & Event Software