Excel Intermediate 2003-2010

Short course

In Poole

£ 150 + VAT

Description

  • Type

    Short course

  • Location

    Poole

  • Duration

    1 Day

To ensure that delegates have the right knowledge to make the most of Excel Workbooks.

Facilities

Location

Start date

Poole (Dorset)
See map
Phoenix House, Marshes End, Upton Road, BH17 7AG

Start date

On request

About this course

Basic use of Excel is assumed plus familiarity with spreadsheets in general. Attendees should have created their own spreadsheets, including basic formulae, and be using this software regularly in their working environment.

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

Formulae

· Review of Cell Addressing within Formulae

· Copy Formulae

· Absolute Cell Referencing

Functions

· Use of the Average, Min, and Max functions

· Function Wizard

· Conditional Functions

· Date related functions

General

· Protecting sheets

Ranges

· Creating Named Ranges

· Using Range names in Formulae

Multiple Sheets

· Renaming Sheets

· Inserting and deleting sheets

· Copying sheets

· Group Edit Mode

Charts

· Editing Charts•

· Formatting Charts

· Adding Trend lines

· Using Secondary Axis•

· Using Drawing tools

Printing

· Print & Preview options - ranges/sheets

· Headers and Footers•

· Print Titles

Formatting

· Useful Text formats

· Clearing formats

· Formatting Dates

Excel Intermediate 2003-2010

£ 150 + VAT