TAP> Advanced Microsoft Excel

Course Purpose:

Advanced Microsoft Excel online course is to equip participants with the knowledge and skills needed to utilise Excel’s advanced features for complex data analysis, automation, and visualisation. By mastering key tools such as formulas, PivotTables, Pivot Charts, macros, and dynamic dashboards, participants will enhance their proficiency in Excel, enabling them to efficiently manage and analyse data, automate tasks, and create insightful visualisations for professional and personal use.

What will you learn

Delve into complex functions like nested formulas, data analysis tools such as pivot tables, and advanced features like macros and VBA (Visual Basic for Applications) for automating tasks and manipulating data more efficiently. Additionally, you’ll explore advanced data visualisation techniques, data validation, and scenario analysis, empowering you to handle intricate data sets and create sophisticated spreadsheets for various purposes.