We are passionate about empowering individuals to expand their knowledge and skills using Excel. Our training programs are designed to equip you with the expertise needed to thrive in today's data-driven world. Through our in-depth courses and workshops, you will develop a clear understanding of Excel’s built-in functions allowing you to work efficiently with your data and produce meaningful reports. Our hands-on approach to learning ensures that you not only grasp theories but also gain practical experience in implementing these new skills efficiently. 
 

Who will benefit from this course
 

This instructor led course is designed to build your knowledge so we recommend that you have attended our foundation course or have the equivalent understanding.

Key elements of the course 

• Use basic statistical functions such as Sum, Average, Min and Max to analyse data
• Understand Excel's order of calculation
• Work with relative and fixed cell referencing
• Use names to define cells and ranges
• Use conditional functions to test a condition and return values depending on the result
• Use lookup functions to find and use data from other spreadsheets
• Apply formatting that changes upon a given set of conditions
• Learn custom sorting, filtering, sub-totals and slicer to report from data
• Add data validation and cell protection to control data input or prevent unwanted changes
• Produce charts to visually enhance data for reporting

Course Details

This is a one-day, tutor led, on-line course the dates for which are set out on the Course Schedule. It can also be run as a tailored, company specific course either on-line or at an organisation’s premises.