(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 - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
Level - Advanced
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.
Level - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.