Excel 2003 Level 3
| Date |
Location |
Duration |
Cost |
| 20 Aug 2010 (Fri) | Washington | 1 | £ 165 |
| 16 Sep 2010 (Thu) | Washington | 1 | £ 165 |
| 15 Oct 2010 (Fri) | Newcastle | 1 | £ 165 |
| 04 Nov 2010 (Thu) | Blyth | 1 | £ 165 |
| 24 Nov 2010 (Wed) | Washington | 1 | £ 165 |
| 16 Dec 2010 (Thu) | Newcastle | 1 | £ 165 |
| 27 Jan 2011 (Thu) | Washington | 1 | £ 165 |
| 11 Mar 2011 (Fri) | Washington | 1 | £ 165 |
| 22 Apr 2011 (Fri) | Newcastle | 1 | £ 165 |
| 27 May 2011 (Fri) | Washington | 1 | £ 165 |
| 20 Jun 2011 (Mon) | Newcastle | 1 | £ 165 |
| 18 Jul 2011 (Mon) | Washington | 1 | £ 165 |
| 21 Jul 2011 (Thu) | Blyth | 1 | £ 165 |
Please contact us to discuss private course dates and locations |
Course Overview
This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.
Prerequisites
- We recommend that you have completed the Excel Level 2 course or have the equivalent skills.
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
Outlining
Creating an outline automatically and manually
Removing the outline from a worksheet
Using the outline symbol
Custom views
Creating a custom view
Deleting a custom view
Displaying a different view
Scenario
Setting up a scenario
Viewing a scenario
Editing a scenario
Deleting a scenario
Pivot tables
Adding summary rows and columns and/or hiding certain field values
Formatting your pivot table
Filtering the fields once your pivot table is created
Creating a PivotChart
Creating a pivot table from an Excel list
Edit a pivot table at a later date
Removing a field from a pivot table
Refreshing a pivot table
Delete a pivot table
Modifying the settings for a pivot table field
Macros
Recording a macro
Using relative references when recording a macro
Running a macro
Deleting a macro
Assigning a macro to a button on a worksheet
Editing a button on a worksheet
Creating your own toolbar
Assigning a macro to a toolbar button
Removing a button from a toolbar
Setting a security option for your macros
Look-up tables
Creating a VLOOKUP
Tips using VLOOKUP
Creating a HLOOKUP
Using tracers to help audit a worksheet
Description of tracer arrows
Tracing precedents
Tracing dependents
Removing all tracer arrows
Complex formulas
The IF function
The SUMIF function
The COUNTIF function
The COUNTBLANK function
Round: To round a number to so many decimal places
Now()
Entering a workbooks name, path and worksheet name into a cell
Styles
Creating a style by example using the style command
Creating a style using the format cell dialogue box
Deleting a style
Applying a style using the menu
Redefining a style using a formatted cell as an example
Copying styles from another workbook
Goal seek & solver
Email Us 
Print