(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 - Intermediate
Well-designed documents represent and showcase your organisation and can have a great impact. This course introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements.
Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.
Level - Fundamental
This course takes a practical, hands-on approach to design, providing beginners with the foundational skills needed to create professional content using Canva.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.