Excel VBA Macros Course Perth
The ULTIMATE Excel VBA Macros Course in Perth. Discover our World Class Excel Macros Training that teaches students how to automate and code Excel using Visual Basic for Applications.
Macros (Excel VBA Essentials) Course Summary
This Excel VBA Course (Excel VBA Essentials) covers a number of important topics for advanced Excel users, such as editing of Macros, and how to understand as well as write Excel VBA (Visual Basic for Applications) code from scratch.
COURSE DETAILS
Click to view details about this Training Course
COURSE DATES
View our available Public & Virtual Course Training Dates
COURSE PRICING
Check out our amazing Public & Virtual Course pricing
REMOTE TRAINING
You can also attend Virtually (Remotely). Learn how it works
Excel VBA Macros Course Details
Learn more about this Course and find links to booking options.
Outline: Excel Macros Course
You can learn more about this Excel VBA Essentials Course, by drilling down on the topics below.
Part One (Day 1)
- Fundamentals of Excel VBA
- Objects and Properties
- Excel Objects
- Object Hierarchy
- Application
- Workbook vs Worksheet
- Range
- Variables and Constants
- Data types
- Loops
- Decision Making
- IF / AND/ OR
- Select Case
- Dates and Times
- Workbook and Worksheet Events
- Debugging and Error Handling
- Error Prevention
- Runtime Errors
- Worksheet Functions in Excel VBA
- User Defined Functions
- Arguments & Calculation
- ActiveX Controls
- Control Toolbox & Control Properties
- Control Parents
Part Two (Day 2)
- UserForms Introduction
- Filling UserForm Controls
- Putting Data into Controls
- Filling a ListBox or ComboBox with Loops
- Multi-Page Control
- Creating a Wizard
- Validating User Input
- Methods and Functions
- Control Events
- When and Which Controls to Use
- Parsing Control Values
- Parsing Range Values to UserForms
- Option Buttons and Checkboxes in Detail
- True or False
- Creating Template Controls
- The RefEdit Control
- Find the Active Control
- Create Controls at Runtime
Overview
This advanced two day Excel Macros Training Course is designed to teach attendees to discover (or enhance their existing) Excel VBA Macro skills in order to help automate and improve their Excel spreadsheets.
Furthermore, knowledge gained includes writing Excel VBA code, as well as building UserForms. Finally, Error trapping and custom User Defined Functions (UDFs) are covered in detail.
Audience & Duration
This two day Excel VBA Course (9am to 4pm WST) is an Advanced Course, which means that it is suitable for users who have solid, advanced skills in Microsoft Excel. Therefore, it will not suit anyone with limited Excel skills.
Course Outcome
Students will learn how to record and edit Excel Macros and write Excel VBA code from scratch. At the same time, guidance is given about best practices for writing VBA code in Microsoft Excel. Consequently, attendees should be confident to create procedures and controls that control the behaviour and appearance of an Excel spreadsheet. Additionally, students should be able to create procedures that run in response to specific events, as well as create user forms to accept or display data.
Furthermore, course attendees should also be validate data entry user forms, and equally important, students should be able to debug and handle errors in code.
Last but not least, our Excel Macro Training Course attendees will learn how to create and deploy custom UDF (User Defined Functions).
Excel VBA Course Attendance
We offer a number of different ways to attend our Perth based Training, such as Public or Virtual Courses, as well as Workplace Training options. This is all in addition to the fact that you can also attend our courses online.
Public and Virtual Excel VBA Courses
We often run Excel Macro Training Courses at our venue in Perth, which can also be attended virtually (via ZOOM or Teams), from anywhere in Australia.
Workplace Excel VBA Courses
We also offer Workplace Training for companies. This means that we can run the course at your venue, or you can come to ours. With workplace courses, we supply laptops (with no rental fees), and can also cater for virtual students at the same time.
Custom Excel VBA Macros Training
In addition to this course, we also offer many other Training Courses for Excel, as well as custom Excel Training.
Online Excel VBA Courses
In addition to our standard delivery, we also offer the option to sit your course via our online training portal.
Public & Virtual Dates
This Excel VBA Course is a Two Day Course run over consecutive days.
Virtual & Public Pricing
TRAINING UPDATES
Course Specials
We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.
We now also accept Afterpay. You can select this option when completing your course booking online.
Microsoft Excel Consulting Perth, Australia
Not only does Mobile MOUSe offer the best Excel VBA and Macros Course in Perth. But we also offer tailored Excel support and assistance for any type of spreadsheet..
Our Perth based Microsoft Excel Support is world class, due to our years of experience and expertise.
Get Excel Support by contacting us today !!!
Microsoft Excel Training Courses
In addition to our Excel VBA Essentials (Excel VBA Course), here are our related Microsoft Excel Training Courses for Australia and Perth.
BASIC EXCEL TRAINING COURSE
Learn more about our Excel New Users (Basic Excel Course). Virtual Classes are also available.
INTERMEDIATE EXCEL TRAINING COURSE
More about our Intermediate Excel Training Course. Virtual Classes are also available.
ADVANCED EXCEL TRAINING COURSE
Discover our Excel Expert (Advanced Excel Course). Virtual Classes are also available.
EXCEL FORMULA WORKSHOP COURSE
Learn about our Excel Formulas Course (Advanced). Virtual Classes are also available.
EXCEL DASHBOARDS COURSE
Discover our Excel Dashboards Course (Advanced). Virtual Classes are also available.
VBA (MACROS) EXCEL COURSE
Click to learn about our Excel VBA Course (Advanced). Virtual Classes are also available.
EXCEL POWER QUERY COURSE
Info on our Excel Power Query Course (Advanced). Virtual Classes are also available.
EXCEL POWER PIVOTS COURSE
More on our Excel Power Pivot Training Course (Advanced). Virtual Classes are also available.
In Business Since
Students Trained
Avg Student Score (out of 10)
Pricing From
Excel VBA Training Inclusions
All Mobile MOUSe Excel Courses have the following course inclusions…
IN-HOUSE (Our Venue)
Excel Courses at our Perth venue include the following…
- State of the Art Venue
- Face to Face Courses
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Refreshments and Snacks (Free)
- Free Parking
- Dynamic Trainers
- Really Affordable Training
- An Amazing Training Day 🙂
ONSITE (Your Venue)
Our Workplace Training normally includes these features…
- Laptops (no rental fees)
- Face to Face Training
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Projection Equipment
- Cables & Power Boards
- Dynamic Trainers
- Very Affordable Training
- An Amazing Training Day 🙂
Virtual Excel Courses
In short, Virtual Training (via ZOOM or TEAMS) features include…
- Face to Face Training
- Interactive Virtual Classroom
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Dynamic Trainers
- Really Affordable Training
- An Amazing Training Day 🙂
Courses Online (Self Paced)
Our Online Courses include the following features…
- Online Portal
- Same Trainers
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Dynamic Trainers
- Really Affordable Training
- Learn at Your Own Pace