(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.
This course is designed for professionals looking to improve their practical use of Microsoft Teams, an increasingly common tool for modern workplace collaboration.
Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.
Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.
This course provides an in-depth understanding of the advanced features of Teams, enabling participants to enhance workplace collaboration, communication, and effectiveness.