Intermediate Microsoft Excel 2003 Training Courses
Short course
In Twickenham
Description
-
Type
Short course
-
Location
Twickenham
-
Duration
1 Day
-
Start date
Different dates available
This course aims to give delegates a greater understanding of MS Excel 2003.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates will have improved their skills in using Microsoft Excel 2003. They will be able to:
Manipulate worksheets
Use templates
Apply conditional formatting
Use various functions, including financial, logical and date/time functions
Manage Excel databases and lists
Customise charts
Use Excel in conjunction with other applications
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Excel
- MS Excel
- Microsoft Excel
- Microsoft excel training
- Manipulating Worksheets
- Inserting
- Freezing panes
- Hiding rows
- Grouping
- Applying templates
- Editing templates
- Creating Templates
- Financial functions
- Data validation
- Filtering Data
Course programme
Renaming worksheets
Inserting worksheets
Deleting worksheets
Splitting worksheet window into panes
Freezing panes
Hiding rows and columns
Grouping and ungrouping worksheets
Copying data between worksheets
Formatting multiple worksheets in one operation
Entering a formula to link related worksheets
Templates
Applying templates
Editing templates
Creating templates
Formatting
Applying number formats
Creating conditional number formats
Using conditional formatting
Functions
The IF function
Nested IF functions
Financial functions, including PMT, FV
The DATE function
The NOW function
Excel databases and lists
Creating an Excel database
Editing an Excel database
Sorting
AutoFilter
Filtering data
Totalling and manipulating filtered data
Creating subtotals
Using data forms
Data validation
Charts
Plotting non-contiguous data ranges
Pie charts
Adding new data to an existing chart
Chart formatting techniques
Use of Excel with other applications
Paste special option
Linking vs Embedding
Linking data from other worksheets
Linking data from other applications
Exporting to other applications
Additional information
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT
Intermediate Microsoft Excel 2003 Training Courses