MS Excel Super User (Expert)

Overview

This one-day MS Excel Super User (Expert) course is designed for advanced Excel users who are ready to master specialised functions, advanced data manipulation techniques, and interactive spreadsheet tools. The programme covers complex formulas, advanced filtering with macros, powerful lookup functions, and form controls for dynamic charts and PivotTables.

Participants will gain hands-on experience with advanced logic, text, date, and statistical functions, while also exploring automation techniques and form-driven interactivity. This training enables delegates to design robust, efficient, and highly functional spreadsheet solutions for complex business needs.

Objectives

• Use Paste Special operations for advanced data manipulation.
• Apply and combine multiple text functions for data formatting and transformation.
• Work with date and time functions for scheduling, calculation, and analysis.
• Apply advanced logical and statistical functions, including IF, AND, OR, COUNTIF(S), SUMIF(S), SUMPRODUCT, INDEX, and MATCH.
• Perform advanced filtering using macros.
• Advanced filter using Macros
• Use additional lookup functions and mathematical functions like CEILING and FLOOR.
• Create and manage form controls to enhance charts and PivotTables.

Delivery Methods

Facilitated by a competent and experienced subject matter trainer using practical, experiential techniques such as questions, discussions, demonstrations, exercises, and assessments.

Who should attend?

This course is ideal for highly skilled Excel users seeking to develop specialised, interactive spreadsheet solutions, including:

• Data Analysts and Reporting Specialists
• Business Intelligence Practitioners
• Advanced Financial Modellers
• Senior Administrative Professionals
• Anyone creating advanced spreadsheet tools for business operations

Includes:

• Comprehensive Manual
• Lunch and Refreshments (not applicable to on-site / online training)
• Electronic Certificate (on successful completion of the course)
• Electronic Delegate Feedback Questionnaire