Fifteen tricks of the trade
that will transform your talents
Thursday, 20 October
Are you looking to excel with Excel, but the very thought of spending a day in front of a computer in a classroom puts you off? Perhaps you don't want to spend time entering data, correcting mistakes and feel as if you are slowing everyone else down? Or perhaps you are happy to experiment on your own and don't want to wait for slower delegates to catch up?
This seminar will motivate, enthuse and drive you to get a buzz out of using Excel. A seminar handout with a CD packed with exercise files enables you to practice what you've learnt at your own pace at your own time. For one month following the seminar you are entitled to free post-course advice on any subject matter covered in the seminar.
The plan
Who should attend?
The facts
Enrol today
Feedback
The small print
Microsoft Excel has lots of underutilized features that can make you more productive with less work, thereby saving you and your organisation in the long run. This seminar will teach you how to use these features and their usefulness in your organisation, challenging you to do things differently. Learn from somebody who talks jargon-free and who has a proven track record using Excel in a business environment.
Karen will reveal the fifteen tricks of the trade:
- Save countless hours in calculating and recalculating information by using formulas
- Perform more complicated calculations by using functions
- Avoid the "pitfalls" of relative cell references
- Test certain conditions and return one of two entries
- Present information in the form of a chart
- Produce summary reports from different worksheets
- Merge data from multiple users by linking workbooks
- Manage large spreadsheets by splitting the workbook window into panes
- Ensure accurate data entry by restricting cell entries to specific conditions
- Search for a value in one place and insert it in another using lookup functions
- Use Excels database features to quickly retrieve data and manipulate lists
- Analyse your data, using PivotTables
- Automate repetitive tasks by creating macros
- Assign a macro to a button on your toolbar or new menu
- Learn numerous time-saving tricks and shortcuts
It's easier done than said!
Back to top
- Anyone who has mastered Excel's basics and is ready to excel with Excel.
- Anyone who is looking for a lively mix of demonstrations and business examples and is happy to go back with a seminar handout with a CD packed with exercise files to practice what you've learnt at your own pace at your own time.
- Anyone who is put off by the very thought of spending a day in front of a computer in a classroom.
Back to top
Full price £247. Bring a colleague or friend for an additional £187, saving 25%.
Members of the Cambridge Network and Cambridgeshire Chamber of Commerce: £225 (save 10%).
Why not come as a group of 6 and invite friends, colleagues or customers for £999.
Price includes:
- Lunch and refreshments
- Seminar handout with a CD packed with exercise files (worth £65)
- one month post course advice personally from Karen, founder of Roem Limited
When and where
The seminar will be held on Thursday, 20 October 2005 at The Moller Centre, Storey's Way, Cambridge. The Centre is approximately an hour from London by direct train from King's Cross station and is easily accessible by road from the M11 and A14 with plenty of free on-site parking. (En-suite accommodation is available at the Centre.)
Also coming up is:
Mastering Microsoft Access on
29 September.
Seminar programme:
09:00 - 09:30 Registration and coffee
09:30 - 12:30 Part 1
12:30 - 13:30 Lunch
13:30 - 16:00 Part 2
16:00 - 16:30 Q&A
Interested but cannot make the date?
This seminar can also be held on-site at a time that suits you. You can benefit from getting
solutions to your "real-life" problems in your own environment. One-to-one or group training is available.
An on-site course can even work out to be more cost effective!
Back to top
Early bird bookings: Book before 15 July and receive a 10% early-bird discount. Pay just 225.
How to book. Please reserve your place using one of the following methods:
- Online: credit/debit card payments
- Email: karen@roem.co.uk
- Post: booking form
- Phone: 01223 214177
Payment is due before the seminar. Your booking is not confirmed until payment is received.
Back to top
Don't just take our word for it. Here's what people say about hands off training:
"I have attended many training seminars over the years but none have been
delivered with such a refreshing and relaxed format. Due to this the benefits of
attending were many and I would recommend Karen's courses to anybody who wishes to
learn without the feeling that they are just being taught."
Tim Heath, Manciple, Fitzwilliam College, Cambridge
"Computer courses can be scary, this course was thoroughly enjoyable, well paced, plenty of information - a day well spent!
"
Jayne Williams, Grifols UK Ltd, Cambridge
"I found the seminar extremely interesting and a very different way of learning. I would definitely recommend it to anyone who uses Excel and wants to
progress using the various functions to a greater degree. I enjoyed the day and even found time to look through the folder at home in the evening. I would not hesitate to go on another hands-off course.
"
Linda Curnow, Lucy Cavendish College, Cambridge
"I enjoyed the open forum rather than just sitting at the machine and working."
Jane Golding, Churchill College, Cambridge
"Non-hands on was very interactive and enabled plenty of Q&A."
Carolyn Harden, National Air Traffic Services
"Karen was very informative and went at a pace that everyone could follow. Always made time for all members of
the group."
Sharon Nightingale, Swavesey Village College, Swavesey
"Great venue, lovely trainer! I really enjoyed it. (Much more than I thought I would.)"
Liz Whitaker, Norfolk Federation of Young Farmers Clubs
"Very useful course. Hands-off approach was much better than expected as allowed everyone to progress at the
same pace and kept the continuity going. Trainer was happy to deviate from prepared programme and address relevant questions.
"
Emma Holmes, GMG BioBusiness Ltd, Cambridge
"I enjoyed the course and gained great value from the hands-off approach.
This type of course covered a wide selection of "opportunities" and it
is now down to practicing and implementation in the
work-place.
Many thanks for such an interesting day and also for your quick response to
the unanswered questions.
"
Angela Mead, The Mller Centre, Cambridge
"I've developed excel-ent skills! Thought you'd be pleased to know that today I am working on a
spreadsheet to create a report and it's a real pleasure to apply the knowledge I learned on your course. It's brilliant!
Many thanks for your excellent tuition.
"
Michael Bennett, Forward Business Solutions, Whittlesford
"Content was very good - I picked up a lot of new ideas - and remembered tips I'd forgotten!"
Natalie King, Atkinson Bolton Consulting Limited
"The quality of the event and the venue was excellent. The course pack is very comprehensive and will be a useful reference
tool. Excellent value for money!"
Carol Lyon, Cambridge Genetics Knowledge Park
Back to top
All fees must be paid for in advance. In the unlikely event of the seminar being cancelled a full refund will be made, but further liability is disclaimed. It may be necessary for reasons beyond the control of Roem Ltd. to change the date or the venue.
Back to top
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
Virtual Press Room
Disclaimer