COURSES | PRICING | CALENDAR | ENROL | CONTACT | SELF ASSESSMENT | DOWNLOADS | FEEDBACK  
 
  EXCEL | WORD | ACCESS | OUTLOOK | PROJECT | POWERPOINT | VISIO | INFOPATH | PUBLISHER | SHAREPOINT | ACROBAT | PC BASICS |ONLINE COURSES
  TIME MANAGEMENT | PROJECT MANAGEMENT | CONSULTING SERVICES | ONSITE TRAINING | OUR VENUE
 
» QUICK LINKS
 

EXCEL VBA ESSENTIALS (ADVANCED) PERTH

Outline | PDF | Calendar | Enrol | Enquire | Pricing

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

EXCEL VBA ESSENTIALS (ADVANCED) COURSE OVERVIEW
Skill Level: Advanced

This course is designed to help attendees learn (or enhance their existing) VBA skills in Microsoft Excel. By the end of this 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. Attendees will also learn how to create custom UDF (User Defined Functions).

WHO SHOULD ATTEND THIS COURSE

This course is designed 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 proficieny in Excel and that attendees already know how to record and edit a macro.

COURSE DURATION AND TRAINING VENUE

DURATION: 2 full days (9am to 4pm)
VENUE: Onsite (your premises) or Inhouse (our premises)

MINIMUM ATTENDANCE REQUIREMENTS

• This course is intended for advanced users of Excel.
• Attendees MUST already have Advanced Excel skills.
• Students should have experience recording/editing macros.

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 WorksheetFunctions in VBA
• Specific Examples
• Excels Built-In Features
• User Defined Functions
• Arguments
• Calculation
• Controls
• ActiveX
• Control Toolbox
• Control Properties
• Control Parents

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

IS THIS THE RIGHT EXCEL COURSE FOR YOU?

Not sure which excel course is the right one for you? Take our free, zero obligation excel self assessment here. More info...

» Excel New Users Course (Basic)
» Excel Essentials Course (Intermediate)
» Excel Expert Course (Advanced)
» Excel Formula Workshop Course (Advanced)
» Excel Dashboards (Day 1) Course (Advanced)
» Excel Dashboards (Day 2) Course (Advanced)

 

[back to the top]

 

LEARN ABOUT OUR ONSITE TRAINING



ABOUT OUR EXCEL VBA ESSENTIALS (ADVANCED) COURSE

 

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


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

 

COURSE PRICING


Our pricing structure is unique. The more people you enrol in an excel course, the cheaper the excel course becomes (which is great for companies and friends). More info...

 

For all of the reasons above (and more), Australias' biggest companies acknowledge the features and benefits of training with Mobile MOUSe. Our professional approach and intricate knowledge of the features and abilities of Excel have saved our clients millions of dollars after they implemented the features we have made them proficient in. More info...

 

OUR TRAINERS

 

Our trainers are known for their knowledge and helpful, friendly approach. All of our excel courses are taught by experienced, certified and qualified instructors, who individually have a minimum of 15 years training experience.

 

EACH STUDENT RECEIVES


• The best Excel training in Perth and Western Australia
• A detailed high quality manual -> download a sample
• Free downloadable practice files
• Online support
• A certificate of attendance (on request)
• Zero Hassle, FREE PARKING when attending at our premises

 

 

 

[back to the top]

» CALENDAR

Click the image below to view our current perth training schedule and potentially book your classroom seat(s).

 

Mobile MOUSe course calendar

» 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...

» CERTIFICATION

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications.

 

Microsoft Office Certification

 

More info...

» VENUE & ROOM HIRE

Need a meeting or training room? Options range from a day to a years lease.

 

More info...

 
Email Mobile MOUSe
Read our terms and conditions...