Course Details close

Course Details

Price:
(inc GST)
$ 990
Sale Price:
(inc GST)
$ 890
Application:Excel
Level:VBA Basic
Version:All-Versions
Duration:2 days
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel VBA Basic Course

   (4.87 out of 5)
337 Excel vba basic student evaluations

Quick links

Excel VBA Basic Course

Course Overview

This is a two-day training course tailored to give experienced Excel users the skills required to use Excel’s VBA (Visual Basic for Applications). Lead by dedicated instructors with expertise in the Microsoft Office package, you’ll learn how to confidently navigate and utilise the VBA editor to run, edit and debug VBA code. We’ll teach you how to get started with VBA and provide you with a solid foundation on the Excel Object Model along with the associated properties, methods and events which are the building blocks of the VBA programming language.

Raising the Bar training courses are carefully designed so that all students achieve the best possible learning outcomes. You'll be guided by industry experts as you learn earn through clear instructions, insightful demonstrations and hands-on activities. Our class sizes are small so that all students can learn in a supportive environment and we provide all equipment so you just need to show up. Upon completion, you'll leave with brand new skills and knowledge of Excel VBA, with the ability to automate standard features and develop programs. You will have gained the proficiency required to write code and use a range of common programming techniques using Excel VBA.

When you finish the Excel VBA Basics course, you’ll receive a certificate of completion and a course manual you can work through at home to further develop your VBA skills.

Who Should Attend This Course

The Excel VBA Basic Training Course is designed especially for students who already have an advanced knowledge of Excel and utilise these skills on a daily basis. Participants should have working knowledge of how to record and run macros and must be able to confidently nest functions before undertaking this training. This course is perfect for users who want to automate and customise complex calculations and processes in their current work flows.

Typically, students who attend this course already have a high level of confidence with Excel and know how to create professional and productive spreadsheets using Excel’s more complex and technical features and formulas. This course is right for you if you’re an experienced Excel user who wants to learn the basics of using VBA, write code and employ various programming techniques. We’ll familiarise you with the software and teach you how to use VBA securely, run and debug code from the VBA editor, work with variables, loops, perform tests, interact with the user, build your own User Defined Functions, learn how to handle errors and create and implement Excel Userforms.

Our public training courses are available in our North Sydney training facility throughout the year. For students in other cities, group training sessions are available by appointment for companies in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our course is designed for experienced Microsoft Excel users. Students should have completed our Excel Advanced course and know how to record and run macros and confidently nest functions before undertaking VBA training. You will also need general computer skills using the Windows operating system.

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Course Dates

Course Date Price Add Course Qty Status
25-Feb-19 (Mon)$890.00 0
ON SALE
28-Mar-19 (Thu)$990.00 0
29-Apr-19 (Mon)$990.00 0
30-May-19 (Thu)$990.00 0
25-Jun-19 (Tue)$990.00 0
15-Jul-19 (Mon)$990.00 0
15-Aug-19 (Thu)$990.00 0
Training courses on sale now

Courses start
from $890 (inc GST).
Limited seats.
Book today!

Course Outline

Getting Started

  • What is VBA?
  • Open the VBA Editor
  • Create a Module
  • Create a New Subroutine
  • Add Commands
  • Run the Subroutine
  • Save the File

Security

  • Open a File Containing Code
  • Create a Digital Signature
  • Digitally Self-Sign a File
  • Add the Publisher to the Trusted List
  • Install Certificates
  • Remove Trusted Publishers

Using the VBA Editor

  • Run Code in the VBA Window
  • Step Through Code
  • Step Over Code
  • Set a Break Point
  • Comment Code
  • IntelliSense and AutoComplete
  • Getting Help
  • The Project Explorer and Properties Window

Variables

  • What is a Variable?
  • Naming Variables
  • Store a Value in a Variable
  • Why Should I Declare Variables?
  • Procedure-Level Declarations
  • Module-Level Declarations
  • Global-Level Declarations
  • Static Declarations
  • Option Explicit
  • Declaring Data Types
  • Recognise Errors From Declaring Variables
  • Discover the Current Value of a Variable

Interactions With The User

  • Interacting With the User
  • MsgBox as a Method
  • MsgBox as a Function
  • Message Box using Numerical Constants
  • The InputBox Function
  • Long Messages

Making Decisions

  • A Note On Indenting
  • Line If
  • Block If
  • ElseIf and Else
  • Select Case

Looping

  • For/Next Iterations
  • For/Next Stepped Iterations
  • Do/Loop With Initial Test
  • Do/Loop With Final Test

Error Handling

  • Run-time Errors
  • Add a Simple Stop
  • The Err Object
  • Exit Sub
  • Error Handling with Another Sub
  • Resuming

The Personal Macro Workbook

  • Course Prerequisite
  • Record in the Personal Macro Workbook
  • Saving the Personal Macro Workbook
  • Use a Macro from the Personal Macro Workbook
  • Edit a Personal Macro Workbook Macro
  • Locate the Personal Macro Workbook

Excel Objects

  • The Object Hierarchy
  • Locate an Object
  • Properties and Methods
  • The Application Object
  • The Workbooks Object
  • ActiveWorkbook and ThisWorkbook
  • Sheets, Worksheets and Charts
  • The Worksheets Object
  • Simple Range Objects
  • More Complex Range Objects
  • Adding Higher Hierarchical Levels

Common VBA Techniques

  • Copy and Paste
  • Paste Special
  • Offset
  • Insert Calculations in a Cell
  • AutoFill
  • Add/Delete Rows and Columns
  • Convert Data Types

User Functions

  • Functions
  • Single Input Functions
  • Call the Function from Another Procedure
  • Use the Function on the Spreadsheet
  • Multiple Input Functions
  • Use the Multiple Input Function
  • The WorksheetFunction Object

User Forms

  • Insert a UserForm
  • The Project Explorer and Properties Window
  • The Final Product
  • Create TextBoxes and ComboBoxes
  • Align and Resize the Controls
  • Create Labels and use Control Tip Text
  • Create Command Buttons
  • Code the Close Button
  • Populate the Combo Box List
  • Code the Commit Button
  • Create a Macro to open the UserForm
  • Create a Button on the Spreadsheet
  • Automatically Load the Form

Connect to External Databases - Appendix

  • ODBC and VBA
  • Some General Considerations
  • How Does ADO Work?
  • Setting ADO References
  • Connecting to the Database
  • Populate ADO Recordsets
  • Locate a Record using ADO
  • BOF and EOF
  • Filter and Count the Records
  • Add a Record
  • Modify a Record
  • Delete a Record
  • Close the Connection and Recordset
  • Attaching an SQL Database
  • Using VBA with a Local SQL Database

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us