|
|
|
|
Essential Formulae & functions - agenda
|
| Format: Lecture-style with group hands-on exercise sessions - computers will be provided |
| Duration: Half-day course |
|
|
|
Your power-packed agenda
|
|
|
Improve basic formulae
- Use absolute addressing so that you can enter one formula and copy it.
- Construct sheet-to-sheet formulae and sum sheets to a Totals sheet.
- Create formulae faster and make them easier to understand by using named ranges.
- Construct workbook-to-workbook formulae links and avoid common problems.
- Remove workbook-to-workbook formulae links before emailing workbook.
- Discover shortcuts.
Enhance formulae with functions
- Avoid #DIV/0!s by making use of the IF function.
- Use AND and OR functions with IF to flag certain data.
- Use the ROUND function to make totals reconcile to the detail.
Take advantage of calculation options
- Make totals reconcile by turning on a certain calculation option.
- Learn how the Manual calculation option can be useful, but also become aware of its pitfalls.
|
|
|
|
|
|
Who should attend:
- Those who have mastered the basics; that includes formula construction, formatting and printing.
You are definitely not a beginner.
|
Learn in a positive environment
- Be assured the advice you get is well-proven and utilised.
- Feel free to ask questions.
- Get time away from the office and constant interruptions.
- Enjoy a friendly environment where you don’t feel you’re holding others up.
- Instantly apply what you’ve learned on return to work.
The courses cover Microsoft Excel releases XP(2002) through 2010.
Where there are differences among the covered releases, they are pointed out.
Course cancellation policy:
A course booking is considered final when an invoice is sent, and can be cancelled
up to ten working days before the course. After that, payment is expected in full
and no refund will be given.
All cancellations must be notified in writing, i.e. post, fax or email.
Another delegate may be substituted at any time.
|
|