Excel 2003 Advanced

Short course

In London

Price on request

Description

  • Type

    Short course

  • Location

    London

  • Duration

    1 Day

The aim of this course is to increase delegates understanding of the advanced features available within Microsoft Excel 2003. By the end of the course delegates will be able to use forecasting tools, import data from external data sources and increase efficiency by using macros and templates. Suitable for: current users of Microsoft Excel

Facilities

Location

Start date

London
See map
Lower Ground Floor Russell Square House 10 - 12 Russell Square, WC1B 5EH

Start date

On request

About this course

Delegates must have a good knowledge of Excel 2003 either through experience in the work place or attendance of an Excel 2003 intermediate 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

Core Topics

Importing Data

· Importing Data From External Sources

· Importing Text Files

· Using Microsoft Query

· Querying Data From The Web

· Refreshing Data

Templates and Styles

· Working With Templates

· Working With Styles

Analysing Data

· What-If Analysis

· Goal Seek

· Data Tables

· Scenario Manager

· Solver

· Using Pivot Tables

Macros and Custom controls

· Working With Macros

· Running Macros

· Adding Custom Controls

Security and Proofing

· Security Features

· Protecting Excel Files

· Worksheet Protection

· Working With Digital Signatures

· Checking Spelling

· Using Data Validation

· Using Text To Speech

· Documentation

Customising Excel 2003

· Configuring Excel 2003 Options

· Customising The Excel Environment

· Working With Workspaces

Collaboration and Consolidation

· Sharing Workbooks

· Sending Workbooks

· Consolidation

Excel 2003 Advanced

Price on request