|
Cannot spare a full day training?
Then come along to our half day Excel training modules.
Date: Monday 11 August 2008
Venue: Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Start Time: 9.30am
End Time: 12.30pm
Price: £97 (+VAT)
Unless otherwise agreed to, payment is due before the training event. Roem Limited reserves the right to refuse entry to any attendee should payment not have been received.
The price includes a Microsoft Office Specialist (MOS) approved seminar handout
with a CD packed with exercise files for you to work through and take away,
as well as one month post course advice.
The maximum class size of both the Getting Started and Further Use modules is 4, providing computer training in a
friendly, non-threatening atmosphere.
You will be led through each topic and there will be plenty of opportunity for hands-on exercises,
questions and individual support. The practical work will be done on laptops using Excel v2003.
However, if you use an earlier version of Excel on the PC or a Macintosh this course will still be appropriate,
as the versions are very similar.
|
| |
 |
|
|
|
|
|
|
The Further Use course for Excel was pitched appropriately for relative beginners
trying to expand their skills whilst gaining confidence in manipulating the many functions.
Karen is exceedingly patient, not to mention pleasant company and good fun.
She's a great listener which is the key to her talent in tailoring the course perfectly to individual needs.
Kate Hesse, On Track Physiotherapy Ltd, Newmarket
Very informative afternoon. Small group meant that specific questions/problems could be dealt with. The lovely peaceful setting made it more relaxing and easier to take information in.
Jackie Abrey, Gibbs Denley
Course was excellent and presented most clearly. Small "class" size was a definite advantage, allowing 1:1 attention. Handouts will be a great asset for future reference. The venue is fabulous!
Fiona Bennett, Reproductive Healthcare Ltd
very well presented, clear, cheerful and friendly -- thanks!
Ratnaprabha Cooper, windhorse:evolution
Very relaxed atmosphere helped to make this one of the best and informative courses I have ever attended.
Good content, clearly presented.
Sue Murkett, University of Cambridge
Karen's style of training is excellent.
She listened to our requirements and then adapted the training perfectly to our needs.
It was a thoroughly enjoyable and rewarding morning.
Amanda Gracie, S V Mulley
|
|
|
|
|
|
Course outline:
Using Excel functions
- what is a function?
- using the SUM, AVERAGE, MAX and MIN functions
- using AUTOCALCULATE
Using absolute cell references
- entering an absolute column and row cell reference into a formula
- entering an absolute column or row cell reference into a formula
Filtering and summarizing worksheet data
- adding subtotals to a list
- applying an advanced filter to a list
Linking worksheets within a workbook
- setting up related worksheets within a workbook
- moving the cell pointer from one worksheet to another
- copying data from one worksheet to another, editing the data
- entering a formula to link related worksheets
- formatting multiple worksheets in one operation
- previewing and printing multiple worksheets in one operation
Linking multiple workbooks
- entering a formula to link multiple workbooks
- creating a workspace
Creating a chart
- what is a chart? plotting a basic chart
- modifying and enhancing a basic chart
- previewing and printing a chart
- plotting non-contiguous data ranges, plotting a pie chart
- adding new data to an existing chart
Analyzing worksheet data
- creating a pivottable report
- resetting a summary function in a pivottable report
|
|