Techniques to Manage Information
This workshop is offered within organizations for groups of 5 people or more.
Course duration: 1 day
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