|
Nexient Learning ~ Word Training, Excel Training, PowerPoint Training, Canada Wi Cancellation Policy
Description: Who should attend
This course is intended for participants who are familiar with Microsoft Office Excel 2007.
Performance 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
- Create and manage scenarios, as well as create scenario reports
- Define and solve problems with Solver, as well as create reports
- Understand and utilize the various tools used to audit workbooks
Course Outline
Using Functions
- Function Concepts
- Absolute and Mixed References
- Financial Functions
Projecting Figures
What-If Scenarios
- Scenario Concepts
- Creating Scenarios
- Managing Scenarios
- Scenario Reports
Solver
- Solver Concepts
- Defining the Problem
- Solving the Problem
- Solver Reports
- Solver Options
Auditing Workbooks
- Auditing Concepts
- Tracing a Worksheet
- Evaluating Formulas
- Locating and Correcting Errors in Formulas
- Tracking Cells in a Workbook
Pre-Requisites: Microsoft Excel 2007 Level 2
Certificates offered: Certificate of completion
Duration Details: 1 day
8:30am - 4:30pm
Facility Location: Nexient Mississauga
30 Eglinton Avenue West
Suite 804
Mississauga
Ontario
Canada
L5R 3E7
|
