Excel 2003 Level 2
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
| 12 Jun 2012 (Tue) | Washington | 1 | £ 165 |
| 11 Jul 2012 (Wed) | Washington | 1 | £ 165 |
| 03 Aug 2012 (Fri) | Newcastle | 1 | £ 165 |
| 16 Aug 2012 (Thu) | Newcastle | 1 | £ 165 |
| 07 Sep 2012 (Fri) | Washington | 1 | £ 165 |
| 12 Oct 2012 (Fri) | Washington | 1 | £ 165 |
| 08 Nov 2012 (Thu) | Washington | 1 | £ 165 |
| 04 Dec 2012 (Tue) | Newcastle | 1 | £ 165 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Course Overview
This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Delegates will use Microsoft 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
Other courses in this series: 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
Microsoft 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
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
Microsoft and Microsoft Excel are Registered Trademarks
Microsoft Excel Intermediate training courses in North East England, Durham, Washington, Newcastle
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
