Excel 2003 - Level 3

Progressive Training & Development

Short course

In Southwark

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

You need to have some exposure to
charts and formulae such as sum or average.

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

DESCRIPTION
This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets.

PREREQUISITES
You need to have some exposure to charts and formulae such as sum or average.

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
  • WhatIf 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
  • Documentation
CUSTOMISING EXCEL 2003
  • Configuring Excel 2003 Options
  • Customising The Excel Environment
  • Working With Workspaces
COLLABORATION AND CONSOLIDATION
  • Sharing Workbooks
  • Sending Workbooks
  • Consolidation

See related categories

Excel 2003 - Level 3

Price on request

The best Excel courses

See all

See all