|
|
|
|
More essential Formulae & functions
|
| Format: Lecture-style with group hands-on exercise sessions - computers will be provided |
| Duration: Half-day course |
|
|
|
Your power-packed agenda
|
|
|
Create powerful formulae to report and total
- Make reports automatically refer to the correct month so you don’t have to edit formulae each month.
- Create reports that access correct data by searching for matching codes.
- Create totals by using criteria to sum only certain values.
- Discover the power of array formulae use to total matching records.
- Learn functions INDEX, VLOOKUP, HLOOKUP, MATCH, SUMIF, COUNTIF.
Calculate dates and times
- Calculate hours and minutes between start and end times.
- Multiply time by a rate per hour.
- Calculate age.
- Display a series of dates from a start date.
Manipulate text
- Combine First and Last names that are in two columns into one.
- Split data in one column into several.
- Convert text entries into numbers.
|
|
|
|
|
|
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.
|
|