Description

Take your Excel skills to the next level with our Microsoft Excel Advanced course. This course helps you refine your data management techniques and master advanced Excel functions.

Over four interactive 90-minute webinars, you will explore essential tools to optimise your workflows, improve data analysis, and enhance productivity. Learn how to efficiently manage lists, utilise Pivot Tables, work with advanced functions like IF, VLOOKUP, and XLOOKUP, and apply data validation and protection techniques.

Key Learning Areas

Managing Dates & Data Protection

• Understand how Excel interprets dates and perform date-based calculations

• Use functions like TODAY, EOMONTH, and ISONUMBER

• Convert date formats using Text to Columns

• Implement data validation (text, numbers, drop-down lists)

• Protect worksheets and workbooks with password encryption

Advanced Excel Functions (Part One)

• Create and manage Named Ranges

• Work with Subtotals, SUMIFS, COUNTIFS

• Master the IF function, including AND/OR logic and Nested IF functions

• Use IFERROR to handle formula errors

• Explore Goal Seek and Scenario Manager for forecasting

Advanced Excel Functions (Part Two)

• Revisit Named Ranges and IFERROR

• Learn VLOOKUP, Index & Match, and the powerful XLOOKUP (Excel 365 only)

• Optimise XLOOKUP using the [if_not_found] argument and Search Mode

Pivot Tables & Pivot Charts

• Create and customise Pivot Tables for dynamic data analysis

• Filter and refresh Pivot Tables efficiently

• Format data using the Pivot Table Design Ribbon

• Group fields and dates for better organisation

• Enhance interactivity with Slicers

• Create and modify Pivot Charts for clear data visualisation

Who Should Attend?

This course is ideal for professionals who want to refine their Excel expertise and streamline data analysis processes. If you are comfortable with intermediate Excel functions and ready to advance your skills, this course is for you!