Overview

In this course, you will develop your understanding of Excel automation and VBA programming. You will be equipped to transform static spreadsheets into dynamic, intelligent, and highly customised tools, enhancing your efficiency and proficiency in data management and analysis.

The Advanced Macros and VBA in Excel course is an exploration of Excel's powerful automation and programming capabilities, designed to empower you with the skills to revolutionise your spreadsheet workflows.

Learning Outcomes

• Get to know the Visual Basic Editor and create a basic sub procedure using VBA.  
• Create a basic user-defined function that can be used in the same way as SUM and IF to return a value.  
• Use an event to see if a particular cell in the spreadsheet has changed and if so, run a sub procedure.
• Add interactivity to your Excel file with MsgBox, InputBox and User Forms.

Audience

Individuals looking to further their knowledge of Excel.