Microsoft Excel

This course is ideal for reward practitioners who are involved in detailed data analysis. The purpose would be to discover the power of excel in assisting in the time-consuming ‘number-crunching’.

Learning Outcome:

• Interpret surveys – understand what statistics mean in remuneration analysis
• Analyse market data – know what to look for – understand how to interpret data – know how to use technology to interpret survey results
• Use Excel as an analysis tool – sorting, searching, filters, pivot charts and basic formulae – analysing data in Excel – lookups, ‘if’ functions, conditional formatting, arrays
• Present data using Excel – charting (scatterplots, line graphs, bar charts) – advanced functions