Designed for users who already understand the basics. Learn to use advanced functions, create dynamic charts, and discover time-saving techniques for data analysis and management.

This interactive session requires participants to bring a laptop with Excel installed. You’ll work hands-on with real world examples and practice scenarios that reflect workplace challenges. The instructor will guide you through each technique, ensuring you can apply these skills to your own projects immediately after the course.

The Excel Intermediate course will teach you how to:

• Create and manage complex formulas with multiple operations.
• Utilize advanced functions such as VLOOKUP, IF, COUNTIF, and nested functions.
• Develop dynamic and interactive charts and PivotTables.
• Implement data validation and conditional formatting for error prevention.
• Use Excel’s data analysis tools to gain insights from large datasets.
• Automate repetitive tasks with basic macros.

This course bridges the gap between basic Excel usage and advanced applications, focusing on practical skills that increase efficiency and accuracy in your daily work.

The outcome – confidence in handling complex Excel tasks, ability to analyse data more effectively, and significant improvement in your spreadsheet productivity.

To book a place, click here.