Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
WHO SHOULD ATTEND: People who have attended “Excel 1 – Foundation” course and want to improve their Excel skills. WHAT YOU WILL GAIN: You will learn the importance of Excel tables, how to use Excel for analysis and presentation of data and learn common functions that summarise and manipulate data.
WHO SHOULD ATTEND:
People who have attended “Excel 1 – Foundation” course and want to improve their Excel skills.
WHAT YOU WILL GAIN:
You will learn the importance of Excel tables, how to use Excel for analysis and presentation of data and learn common functions that summarise and manipulate data.
PROGRAMME OUTLINE:
Build and use Excel tables – why these are fundamental
Create and use a pivot table; add a slicer, create calculated fields.
Use conditional formatting techniques, such as data bars, background colours, icons, to make tables and pivot tables more appealing and insightful. Create sparklines for time-series data.
Useful functions in Excel
• The XLOOKUP function, why it is good replacement to the notorious VLOOKUP function.
• the SUMIFS and COUNTIFS functions to summarise data
• the INDEX/XMATCH pattern