|
|
|
|
More Essential Spreadsheets for Human Resources - agenda
|
| Format: seminar interspersed with
small team hands-on problem-solving exercises - computers will be provided |
| Duration: one day |
| Arrival and refreshments: 9:00 am |
|
Start: 9:15 am |
|
Finish: 4:30 pm |
|
|
Your power-packed agenda
|
|
|
Best-practice multiple-workbook structure
- Hear the pros and cons of multi-workbook models.
- Structure file-links into Source and Destination areas.
- Use a single name in a range of file-links.
Utilise Excel's Advanced Filter
- Discover Advanced Filter and build any criteria you might need.
- Remove unwanted records.
- Quickly extract the unique items from a list.
Advanced PivotTable techniques
- Stop formats disappearing when you refresh your PivotTables.
- Learn to group PivotTable data by department, country, month or year.
- Add subtotals to PivotTables.
- Create a PivotChart.
- Discover how to add calculations to PivotTables.
Employee performance report model
- See a host of Excel functions and techniques implemented in a single model.
- Create a map sheet to automatically identify new or missing data items.
- Build crosschecks to instantly show when something is awry.
|
|
Advanced Excel functions
- Learn alternatives to the VLOOKUP function.
- Use sophisticated criteria to sum, count and average with Excel's database functions.
Create forms
- Create well-designed, easy-to-follow forms for printing out or for email and return.
- Create inputs, option buttons and check boxes.
- Learn to create a template master for your forms.
- Consolidate the results from many forms into a single workbook.
Create succinct, readable dashboard reports
- Convey key information in one concise report.
- Combine tables and charts into a single dashboard report.
- Use on-sheet indicators to highlight above- and below-target items.
- Change report criteria with dynamic drop-down lists.
Chart and show trends
- Learn how to create charts that convey data clearly.
- Add trendlines to charts.
- Determine whether a trendline is statistically valid.
Discover more great time-saving tips
- Discover a selection of great shortcut tips that everyone should know but many people don’t.
|
|
|
|
Who should attend:
- HR staff involved in planning, analysing and reporting of HR data.
- Those who have been using spreadsheets for some time and are quite familiar
with the basics of formula construction.
- While the two-day Essential Spreadsheets for Human Resources course is not a prerequisite for More Essential Spreadsheets for Human Resources, you should be familiar with the material outlined in the agenda for the two-day course if you plan to attend More Essentials.
|
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.
|
|