Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel 2016 VBA

Course Outline

With Microsoft’s VBA programming language you can take your Microsoft Excel powers to the next level. Learn how to program Excel to automate complicated or repetitive worksheet operations at the touch of a button. This two-day advanced course will take you beyond simple recorded macros to being able to write your own VBA code in Excel. As well as learning to work with the VBA editor and Excel Object model, you will learn a range of programming techniques enabling you to automate processes and add rich functionality to your spreadsheets with your own user-defined functions and macros. At the completion of this course you should be able to:

  • understand the Excel object model and VBA concepts
  • work effectively with the main features of the VBA Editor window
  • create procedures in VBA
  • create and use variables
  • create and work with user-defined functions in VBA
  • write code to manipulate Excel objects
  • use a range of common programming techniques
  • create a custom form complete with an assortment of controls
  • create code to drive a user form
  • create procedures that start automatically
  • write a variety of error handling routines

Prerequisites

This course is intended for confident Microsoft Excel users who wish to learn how to automate repetitive/difficult processes by developing programs in VBA. Ideally attendees should have done at least an Intermediate Excel course or have equivalent skills.

  • You should have confident keyboarding skills and Excel Advanced course or equivalent skills and knowledge.
  • Students must have Excel 2016/2019 or Office 365 installed on their computers.

Virtual Classroom

This course will be delivered using virtual classroom via Zoom in Term 2 due to the current COVID-19 situation. Zoom is easy to use video conferencing software with a simple set up. You will be able to see your trainer and classmates and interact as though you were in the same room, all from the comfort of your own home!

This is what you need to join a Zoom classroom:

  • Understanding the basics of using Zoom – see our free Zoom tutorial by clicking here.
  • Access to a computer, iPad/tablet or smartphone; and
  • A webcam* so that you can be seen by the trainer; and
  • A microphone* so that you can participate in the class and be heard by the trainer; and
  • A good Internet connection.

*If you have a laptop computer a webcam and microphone is usually built into the top of the screen frame. Smartphones and iPad/tablets also contain cameras and microphones.

Once you have watched our free tutorial and experimented with Zoom, if you still have questions, we are offering free Q & A Zoom sessions with one of our experienced trainers. See our Zoom page for available dates by clicking here.

Using Zoom for computer classes

An additional video is also available that demonstrates how you can use two screens or split your computer screen if you are attending one of our computer / software application courses. You can view the video here: Zoom Video for Computer Students

Funding

This course may be fully funded under the NSW Government’s Adult & Community Education funding or Tech Savvy for Small Business Program in 2020. See ACE Community Service Obligation Funding page for details or See Tech Savvy for Small Business Program page or contact Susan Wilkinson on 9970 1000 or email vet@nbmc.nsw.edu.au to check eligibility or for further information.

$260 Limited GST free / $234
Excel 2016 VBA

<h3 id="CourseOutline">Course Outline</h3><p>With Microsoft’s VBA programming language you can take your Microsoft Excel powers to the next level. Learn how to program Excel to automate complicated

...

If there isn't a class to suit you, please the waiting list.

Contact us

Narrabeen Annex: 1525 Pittwater Road,
North Narrabeen NSW 2101
Office Hours: 8.30am to 4.30pm, Mon to Fri

Brookvale Campus: Level 1, 14 William St, Brookvale NSW 2100
Office Hours: 8.30am to 4.30pm, Mon to Thur

Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113