Excel for HR Professionals

Advanced Level

Johannesburg venue: Hackle Brooke Conference Venue, 110 Conrad Drive

• Cnr Conrad Drive & Jan Smuts Avenue, Craighall Park

Who should attend this course?

If you are an HR or Reward Professional who needs to do detailed data analysis, you will find these 1 day courses beneficial. You will attain a clear and relevant understanding of Excel’s functions from its basic uses to its most advanced operations and data analysis tools specifically for use in HR.

These 1 day courses are guaranteed to improve your skills.

Why is this course relevant?

Excel is a core tool in the business world and it is critical that HR and Reward professionals are able to realise the maximum benefits of advanced data processing that Excel can provide. Being able to use Excel effectively and efficiently for HR purposes means that you will be able to collate and organise information methodically and simply, so as to allow for its easy and insightful interpretation.

These courses aim to develop your capability and your confidence to use Excel with excellence - creating better spreadsheets and turning collated data into useful HR management information. Furthermore, the tips of more advanced Excel users will be shared and demonstrated using examples of HR application. Excel is a portable skill and you will find that it’s useful application in all spheres of HR and other areas of the work environment cannot be overvalued.

What is covered in this Intermediate Course?

Some areas that will be covered in the Advanced Level are below. These areas will be covered in detail on the day. For detailed course outlines, please enquire with Kirsten Smythe at This e-mail address is being protected from spambots. You need JavaScript enabled to view it

• Reports: Data consolidation, Using pivot tables, Creating and modifying a pivot table, Formatting pivot tables and Creating a Pivot Chart
• What-if analysis: Data tables and Goal seek
• Advanced functions: Vlookup, Iserror and IFerror, Sumif and =Countif, Sumifs and =Countifs, Nested IF statements, Text functions, Text to Columns, Print formulas
• Tables (Lists): Creating a table, Modifying a table, Formatting a table, Sorting a list, Filtering a list, Using sub-totals Customising
• Defaults: Changing defaults, Customising the QuickAccess toolbar, Customising the ribbon, Setting Data Validation

Which level of the Excel Course is right for you?

Beginner, Intermediate and Advanced level courses are offered. An assessment tool can be provided to you, to assist you in determining your current Excel skill level and which of the courses will address your needs.

Course requirements:

Excel is learnt best through practice so; please bring your own laptop on the day of the course.

All courses can be customised for your organisations in-house training requirements.

Cost: R1 595 (excluding VAT, per person, per level)

Booking Special: Receive 10% discount when you book 3 people on the same level or,

15% discount when you book the same person on 2 or 3 different levels.

Want to know more information about course dates and how to book?

Contact: Kirsten Smythe, Events and Training Co-ordination Manager at Emergence Growth Evolve on  This e-mail address is being protected from spambots. You need JavaScript enabled to view it or call +2784 321 3249