MS Excel 2007™ – Level 3 – Data Analysis

Techniques to Manage Information

This workshop is offered within organizations for groups of 5 people or more.

Program Topics

 

Using Functions

  • Understanding Arguments
  • Working with Absolute and Mixed References
  • Inserting and Using Financial Functions

Working with Figures

  • Using Goal Seek
  • Creating Data Table

Understanding What-If Scenarios

  • Creating Scenarios
  • Managing Scenarios
  • Reporting using Scenarios

Solving the Problem

  • Using Solver
  • Defining the Problem
  • Solving the Problem
  • Reporting using Solver

Auditing Workbooks

  • Auditing Concepts
  • Evaluating Formulas
  • Locating Errors in Formulas
  • Tracing Cells in a Workbook

Creating Macros

  • Creating a basic Macro
  • Editing a Macro
  • Saving a MS-Excel 07 Workbook with Macros

For more information on this workshop, please contact:
Sophie Gouédard
Tel: 613-234-2020, ext. 21
Email: sgouedard@pmctraining.com

Comments are closed