Part Time Advanced Excel 2007 (Part 2)
Vocational qualification
In Paignton
Description
-
Type
Vocational qualification
-
Location
Paignton
The course includes: Use goal seeking to determine the values required to reach the desired result. Create and work with scenarios and the Scenario Manager. Use Solver to resolve complex optimisation problems. Create, use and modify data tables. Group cells and use outlines to manipulate the worksheet. Use templates to create consistency in your workbooks. Create and use a range of.
Facilities
Location
Start date
Start date
About this course
It assumes a knowledge of our Microsoft Excel 2002 XP Intermediate and/or Advanced Part 1 course.
Reviews
Course programme
Advanced Excel 2007 (Part 2)
Is this course right for me?
This one-day advanced course is designed for experienced Excel users. You will learn how to implement workbook automation and advanced operating procedures.
What will I be learning?
The course includes:
- Use goal seeking to determine the values required to reach the desired result ;
- Create and work with scenarios and the Scenario Manager;
- Use Solver to resolve complex optimisation problems;
- Create, use and modify data tables;
- Group cells and use outlines to manipulate the worksheet;
- Use templates to create consistency in your workbooks;
- Create and use a range of controls in a worksheet;
- Protect data in worksheets.
How will I learn?
Classroom based group workshop
What else might I want to know?
Lunch and refreshments are provided.
What can I do afterwards?
You may like to improve your knowledge of other Microsoft applications such as Word or Access.
Apply for this course
You can apply online , by phone, post or in person.
Course Code: CT9EA21SBN
Part Time Advanced Excel 2007 (Part 2)