(08) 9383 8000
Excel - Macros with VBA Programming
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
2 Days
Overview
This course will introduce and extend VBA programming within Microsoft Excel to enable participants to create and manage complicated macros.
Content
- Understand the Visual Basic Editor (VBE)
- Object oriented programming concepts
- Work with cells
- Work with basic variables and arrays
- Interact with the user
- Decision making
- IF, CASE and LOOP statements
- Error handling
- Basic event handling.
Learning Outcomes
Participants should be able to:
- Create and edit macros by writing VBA code in the VBE
- Understand concepts of object oriented programming
- Build user-defined functions in Excel
- Use events to trigger VBA procedures.
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
This course provides an in-depth understanding of the advanced features of Teams, enabling participants to enhance workplace collaboration, communication, and effectiveness.
Level - Advanced
This course introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards.