Display & Accessibility Options
Excel 2003 Intermediate
Microsoft Office 2003
 Next available Norwich date: 08 March 2012   |
Course Aims:
This one-day training course aims to give basic users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.
Assumed Knowledge:
A working knowledge of Excel gained from prior attendance on a Jarrold Training Microsoft Excel Introduction course or from a user environment.
Versions:
Microsoft Office 2000, 2002 and 2003
What people say:
I could not be happier. I will be back for more courses as it was the best training I have ever had anywhere. Brilliant.
May Gurney - Jan 2011
Special Offer
Book one person onto any two levels of Excel training and receive £30 off the total price.
Profile Outline:
Revision
- Product overview
- Revision exercise
Functions
- Date function
- Time function
- Round function
- IF function
- Integer function
Cell Addressing
- Absolute cell addresses
- Relative cell addresses
Conditional Formatting
- Applying conditional formats to text
- Applying conditional formats to numerical values
- Clearing rules
Database Features
- Using a spreadsheet as a database
- Sorting data
- Basic subtotals
- Filtering data with AutoFilter
- Custom AutoFilter
- Data form
Working with Multiple Sheets
- Selecting sheets
- Inserting & deleting sheets
- Copying sheets
- Copy and paste between sheets
- Naming sheets
- 3D calculations
- Group edit facility
Working with Multiple Workbooks
- Opening multiple workbooks
- Arranging windows
- Linking workbooks
- Using Hyperlinks to link worksheets
Additional Features
- Inserting comments
Charting
- Revision of basic charts
- Chart types
- Sizing and moving a chart
- Editing a chart
- Changing chart data
- Formatting chart elements
- Drawing features
- Printing a chart
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £155.00 
Duration: 1 day
Print Page
Norwich Dates:
-
08 March 2012
-
13 April 2012
Links:
People who attended this course, also booked:
Information & print:
