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.

Book a Public Course

Book Corporate Course

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



WORKPLACE TRAINING

Learn about our Corporate Workplace Training Options

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.

Book a Public Course

Book Corporate Course

Request Quote / Date

Enquire Now

Send Us a Text

Public & Virtual Dates

This Excel VBA Course is a Two Day Course run over consecutive days.

Public & Virtual Dates	Link to Book
23 Feb 2022 (Wed)	BOOK NOW

Virtual & Public Pricing

Public (Two Day)	Price per Head
Enrol 1	$600
Enrol 2	$600
Enrol 3	$600
Enrol 4	$600
Enrol 5	$600
Concession Card	$400
5 Vouchers	$1,175
10 Vouchers	$2,250
20 Vouchers	$4,000
Corporate / Workplace	GET QUOTE
Custom Training	GET QUOTE
One on One	GET QUOTE

Excel Training Courses and Support Mobile MOUSe Perth WA

Course Outline (PDF)

Excel Skill Assessment

Related Excel Courses

Excel Consulting

Reuben, Downhole Surveys

\"Joes presentation is brilliant, he is engaging, informative and extremely knowledgeable. Top bloke. I will recommend him to my company. The facilities at Mobile MOUSe are excellent.\"

Silvana, Prime Laundry

\"The course was absolutely brilliant, Graeme is an excellent instructor and I have taken a lot from this course. Thank you, Thank you, Thank you :)\"

Natasha, Woodside

\"Thanks, it was great! Everything was perfectly timed, very enthusiastic trainer and a lot of great takeaways from today. I look forward to attending the next one in a few months.\"

Lisa, Georgiou Group

\"Great trainer!! Russell presented the course really well....very funny and helpful! The facilities were great too. Nothing bad to say at all....would totally recommend Mobile MOUSe to others!\"

Andreas, Sinostruct

\"Easily the best course I have been to. Graeme you do a wonderful job at keeping the course upbeat and interactive. Thank you, learnt so much\"

Roni, Ranger Drilling

\"Very good teaching technique, class control and time management. Very well presented. Great facilities, teaching aids and take home information for future reference. Money well spent.\"

Emma, Brikmakers

\"I thought this course was fantastic. I learned a lot, which will be valuable to my experience and skill set and relatable to my current role. Graeme is an Exceptional trainer, very good at his job.\"

Kristy, BHP Billiton Iron Ore

\"This is the most fun we have had on a course in ages, and learnt so MUCH! Russ was awesome, Thank you!\"

Lisa, Eni Australia Ltd

\"Everything was explained brilliantly. Small class which was great as was more comfortable asking questions. Trainer was very approachable and very knowledgeable.\"

Nicole, Wirtgen Australia

\"Graeme was very interactive with the class and did a great job at keeping everyone involved. The Facilities are also very good. Thank you!\"

Garry, Office of Transport Security

\"I have an extensive training background. The content, pace of delivery and quality of delivery was exceptional. Preparation was obvious and contributed to the course quality. Thank you so much\"

Andrea, HFM Asset Management

\"I attended the courses today with Russell and yesterday with Graeme, they are both amazing! I cant stress enough how great their customer service is, they are very patient and passionate about what they do. Well done guys!\"

Stacey, City of Nedlands

\"The training was awesome and the instructor very helpful! This is my second or third training course I have done with Mobile MOUSe and I would come back again!\"

TRAINING UPDATES

COURSE SPECIALS

We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.

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 !!!

EXCEL CONSULTING