You’ll look deeper into Excel’s functionalities, learning to use complex formulas, manage larger datasets and apply tools such as pivot tables and conditional formatting to enhance your data analysis.

This session is interactive (you will need to bring a laptop with Excel installed), offering opportunities to practice and refine your skills. You’ll work on real-world scenarios that will help you become more efficient ad confident in handling more complex Excel tasks.

The Excel Intermediate course will teach you how to:

• Utilise more complex formulas and functions to perform more sophisticated calculations. Logical functions like IF, COUNTIF and SUMIF as well as lookup functions like VLOOKUP and HLOOKUP
• Efficiently manage and analyse larger datasets with more advanced sorting, filtering and data validation techniques
• Create and use pivot tables to summarise and extract insights from large volumes of data
• Working with multiple spreadsheets, linking data across spreadsheets
• Apply conditional formatting to highlight key data points and streamline reporting, creating new rules for specific formatting needs
• Leverage Excel’s advanced charting tools for more detailed and dynamic data visualisation

This course is practical and engaging, tailored for those who want to take their Excel skills to the next level and handle more demanding spreadsheet tasks.

The outcome – enhanced Excel proficiency, enabling you to perform advanced data analysis, streamline reporting and improve productivity.

To book a place, click here.