(08) 9383 8000
Excel - Macros with VBA Programming
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.
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.
If you have attended Power BI Desktop - Level 1, this course will build on your existing knowledge and introduce you to more advanced DAX (Data Analysis Expressions).
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.