|
|
|
|
Work with tables of data - agenda
|
| Format: Lecture-style with group hands-on exercise sessions - computers will be provided |
| Duration: Half-day course |
|
|
|
Your power-packed agenda
|
|
|
Put filters to good use
- Make AutoFilter show just certain data.
- Set criteria as required.
- Create advanced criteria for Advanced Filter.
- Extract a unique list of entries.
- Filter by colour in Excel 2007/2010.
- Clear unwanted entries with filters.
Sort and insert subtotals
- Sort by more than three fields.
- Sort by non-sequential fields such as Small, Medium, Large, XLarge.
- Insert subtotal rows.
- Show only subtotals.
Analyse and report with PivotTables
- Learn the power of PivotTables to analyse and report on tables of data.
- Create and rearrange cross-tabulation reports.
- Show percentages of total.
- Drill-down to see the detail of aggregated values.
- Refresh PivotTable reports.
|
|
|
|
|
|
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.
|
|