Part Time Advanced Excel 2007 (Part 2)

South Devon College

Vocational qualification

In Paignton

Price on request

The best Excel courses

See all

See all

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

Paignton (Devon)
See map
South Devon College Vantage Point Long Road, TQ4 7EJ

Start date

On request

About this course

It assumes a knowledge of our Microsoft Excel 2002 XP Intermediate and/or Advanced Part 1 course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

See related categories

Part Time Advanced Excel 2007 (Part 2)

Price on request

The best Excel courses

See all

See all