Training Courses in Perth for: Excel | Word | SharePoint | Project | Outlook | Time Management | Access | PowerPoint | Visio | Publisher | PC Basics | Acrobat
Mobile MOUSe Mobile MOUSe Training Mobile MOUSe

Welcome to Mobile MOUSe, Perth WA

Excel VBA Essentials (Excel VBA Macros Training Perth)

Course Calendar Calendar | Course Outline PDF Outline | Enrol Enrol | Course Enquiry Enquire | Course Pricing Pricing | Skills Assessment Assessment

Excel LogoExcel VBA Training Summary

Mobile MOUSe is the preferred INSTRUCTOR LED Excel VBA course provider for Australia's largest companies.

COURSE TARGET SKILL SET: ADVANCED
TRAINING COURSE DURATION: 1 Day (9am - 4pm)
TRAINING VENUE: Our Premises (In-house Perth) or Your Premises (Onsite)

Minimum Attendance Requirements

• Attendees must already have Advanced Excel skills.
• Attendees must have keyboard and mouse skills.

Training Course Overview

This VBA Course is designed to help attendees learn (or enhance their existing) VBA skills in Microsoft Excel. By the end of this training course you should be confident enough to create procedures and controls for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms and debug and handle errors in code. As part of this Excel VBA Training Course, attendees will also learn how to create custom UDF (User Defined Functions).

Intended Audience

This VBA Training Course is intended for people who need to come to grips with the Visual Basic for Applications (VBA) component of Excel. This course assumes a high level of proficiency in Excel and that attendees already know how to record and edit a macro.

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn See How We Roll


Excel VBA Essentials Course Outline

PART ONE - LEVEL ONE / DAY ONE

• The Fundamentals of Excel VBA
• The Visual Basic Editor
• Objects and Properties
• Excel Objects
• Object Hierarchy
• Application
• Workbook
• Worksheet
• Range
• Variables and Constants
• Data types
• Variable Levels
• Declaring Variables
• Constants
• Loops
• Types of Loops
• Loop Pitfalls
• Decision Making
• If / And / Or
• Select Case
• Dates and Times
• Workbook and Worksheet Events
• Debugging and Error Handling
• Prevention
• Runtime Errors
• Excel Worksheet Functions in VBA
• Specific Examples
• Excels Built-In Features
• User Defined Functions
• Arguments
• Calculation
• Controls
• ActiveX
• Control Toolbox
• Control Properties
• Control Parents

Outline (PDF) Enrol Now Onsite Quote

PART TWO - LEVEL TWO / DAY TWO

• UserForms Introduction
• Filling UserForm Controls
• Putting Data into Controls
• When to put Data into a Control
• Filling a ListBox and or ComboBox using Loops
• Multi-Page Control
• Creating a wizard using the Multi-Page Control
• Validating User Inputs
• Methods and Functions
• When to apply Validation
• Control Events
• When and which Controls to use
• Parsing Control Values back to a Spreadsheet
• Parsing range values to the UserForm Controls
• Option Buttons and Checkboxes in Detail
• True or False
• Creating Template Controls
• Using the RefEdit Control
• Finding the Active Control
• Creating Controls at Runtime

Related Excel Courses in Perth

If you are not sure if this is the right Excel course for you, why not take our zero obligation online excel training course skills questionnaire? Alternatively investigate one of our other Excel Training Course options below...

New Users (Basic Excel Course)
Essentials (Intermediate Excel Course)
Excel Expert (Advanced Excel Course)
Formula Workshop (Excel Formulas Course - Advanced)
Dashboards - Day 1 (Excel Dashboards - Advanced)
Dashboards - Day 2 (Excel Dashboards - Advanced)
Online Microsoft Excel Training Courses

General Notes

Our Inhouse Excel VBA Training in Perth is conducted at Unit 1 / 41 Action Rd, Malaga, Perth, WA or... alternatively, our Excel VBA Course can be delivered onsite at your premises (office / factory / regional / minesite).

With our onsite excel training options, we come to you with our laptop computers and projection equipment to deliver the Excel course of your choice. We can also deliver custom Excel training courses (i.e. you choose specific aspect(s) of our Excel courses that you would like delivered). Our Microsoft Excel training is structured to Microsoft Office Certification, in addition, every Excel course comes with free online support.

What Students Say

Standard Course Inclusions

Onsite Training (Your Venue)
For all onsite Excel Training we supply the following (all at NO EXTRA COST):

• The Laptops (at no extra cost)
• Face to Face Instructor-Led Training
• The Projection Equipment
• All electric cables and Power boards
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance (On Request)
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

InHouse Training (Our Venue)
For all Excel Courses our venue we supply the following at no extra cost.

• State of the Art Training Facilities
• Free Parking
• Free Refreshments
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

Our Social Media Links

Mobile MOUSe Social Media

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn

Microsoft Certification

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications. Click the graphic below for more information about Microsoft Office Certification.

MOS Testing Centre

Training Facts

There are many myths about training - reasons suggested for postponing skill development. Whether it's a process that is not being followed, technology under utilised – every organisation benefits from training...

More info...

© 2017 - Mobile MOUSe - Microsoft Office Training and Consulting Specialists (Perth - Western Australia) | (08) 9404 7041 | www.mobilemouse.com.au
 
 
Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn