Microsoft
Excel
Further Use
Working with somebody else's workbooks
but don't know what's going on?
Then come along to our half day Excel training modules.
Date: Monday 8 November 2010
Venue: Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Start Time: 13.30
End Time: 16.30
Price: £97 (+VAT)
How to book:
- Email karen@roem.co.uk OR
- Call Karen on 01223 214177
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.
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.
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!
very well presented, clear, cheerful and friendly -- thanks!
Very relaxed atmosphere helped to make this one of the best and informative courses I have ever attended.
Good content, clearly presented.
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. |
||
|
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
Roem Limited
Cambridge, UK
tel: +44 (0)1223 - 214177
mobile: +44 (0)7941 - 848326
email: karen@roem.co.uk
|
 |
Home
Training
Support
Clients
Contact Details
What's New
Disclaimer