Microsoft Excel 2000 - 2003 Level 3 - Spreadsheet Analysis (S1N3A)
Classroom Learning
Classroom Learning
Also available via
Who Needs to Attend
Those who are familiar with Excel 2000/2002/2003 and want to learn some advanced functionality for data analysis and reporting
Prerequisites
Excel 2000/2002/2003 Level 2 or equivalent experience
Follow-On Courses
- Microsoft Excel 2000 - 2003 Level 3 - Data List Management (S1N3D)
- Microsoft Excel 2000 - 2003 Level 3 - VBA Macros (S1N3V)
In this 1-day instructor-led course, you will learn advanced functions related to Data List Management in Excel 2000/2002/2003.
What You'll Learn
- Use absolute and mixed references in a formula, as well as use 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 the Solver, as well as create reports
- Understand and utilize the various tools used to audit workbooks
Course Outline
1. Using Functions
- Function Concepts
- Absolute and Mixed References
- Financial Functions
2. Projecting Figures
- Goal Seek
- Data Tables
3. What-If Scenarios
- Scenario Concepts
- Creating Scenarios
- Managing Scenarios
- Scenario Reports
4. Solver
- Solver Concepts
- Defining the Problem
- Solving the Problem
- Solver Reports
- Solver Options
5. Auditing Workbooks
- Auditing Concepts
- Tracing a Worksheet
- Evaluating Formulas
- Locating and Correcting Errors in Formulas
- Tracking Cells in a Workbook
Classroom Dates and Locations
Don’t see the location or date you need? No problem – just use our By Request service.
Course Code: 8764
Registration Information
$295 CAD
1 Day Course
Microsoft Course: S1N3A
Practice Files
RSS