Courses
Courses
Services
Services
About 
About 
Home
FAQs
Mobile Site | Phone 0191 377 8377  |   Email Us 
Stay up to date with special offers

Click here to enquire online

Click here to contact us
  

"Really good course, will definitely recommend, learned exactly what I needed to!!"
R. Swales, Stockton Borough Council

"Friendly warm atmosphere with well thought out course presentation"
A. Davey, Conmech Engineers Ltd


"Felt relaxed and not worried about keeping up"
J. Robson, Red House Academy

"Course delivered to suit the needs of all individuals"
R. Teeley, Studsvik UK

"Excellent, flexible so was made very relevant to my work situation"
R. Tunstall,
Homes for Northumberland Ltd


"Very useful and informative, good trainer"
A. Tunstall,
St Aidan's School

"Training facilities were good and good selection of biscuits!"

"Very good way to teach. Nice mix of theory and practice"

K. Ferguson, Durham University


Excel 2003 Level 2

  Print    

Date Location Duration Cost
10 Aug 2010 (Tue) Newcastle 1 £ 165
13 Sep 2010 (Mon) Washington 1 £ 165
14 Oct 2010 (Thu) Newcastle 1 £ 165
26 Oct 2010 (Tue) Blyth 1 £ 165
10 Nov 2010 (Wed) Washington 1 £ 165
06 Dec 2010 (Mon) Newcastle 1 £ 165
14 Jan 2011 (Fri) Washington 1 £ 165
10 Mar 2011 (Thu) Newcastle 1 £ 165
05 Apr 2011 (Tue) Washington 1 £ 165
11 May 2011 (Wed) Washington 1 £ 165
16 May 2011 (Mon) Blyth 1 £ 165
09 Jun 2011 (Thu) Washington 1 £ 165
05 Jul 2011 (Tue) Blyth 1 £ 165
12 Jul 2011 (Tue) Washington 1 £ 165

Please contact us to discuss private course dates and locations

Course Overview

This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Delegates will use Excel to streamline and enhance spreadsheets with templates, charts, graphics, and formulas.

Prerequisites

Objectives

Follow on Courses

Related Courses

Training Options

  • Scheduled public courses at one of our training venues
  • Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
  • Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • For further information please contact us on 0191 377 8377

What's Included

  • 1 delegate per computer
  • Telephone and email support
  • Relaxed refreshment area at our training venues
  • Lunch and refreshments when training is delivered at our training venue
  • Comprehensive course manual and exercises

Course Content

Recap of Level 1

    AutoSum
    Simple Formulae

More Formulae

    Functions, SUM, IF, COUNT, COUNTA, AVERAGE, MAX, MIN, DATEDIF

Referencing

    3D References
    Simple Referencing in a worksheet
    Using the Sum function in referencing
    Relative and absolute referencing

Advanced worksheet design

    Naming cells and ranges
    Protecting a Workbook/Worksheet
    Fixing column and row headings
    Using AutoFill
    Creating and modifying toolbars
    Adding comments to cells on a worksheet
    AutoFormats
    Creating custom lists
    Headers and footers

Sorting and Filtering

    Excel as a database
    Filtering, sorting and finding information
    Using subtotals

Conditional Formatting

    Dynamically formatting data based on cell values

Templates in Excel

    Creating a template
    Customising a template

Charting

    Creating a chart in a hurry
    Creating a chart using the wizard
    Changing the chart properties

Printing

    Advanced print settings:
    Views
    Repeating Column and Row heading
    Set print area
    Printing a selection