Excel 2003 Level 2
| Date |
Location |
Duration |
Cost |
| 13 Sep 2010 (Mon) | Washington | 1 | £ 165 |
| 18 Oct 2010 (Mon) | 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 |
| 09 Aug 2011 (Tue) | Newcastle | 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
- We recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel. Students can obtain this level of skill by attending Excel Level 1.
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
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
Print