Byron Employment

Byron Employment. Over 113,202 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $907.50

Course Overview

This course is designed for those who wish to learn more about macros - from the simple recording techniques to building programmable solutions within Excel. This course covers topics such as creating macros, user defined functions, understanding the VBA environment and programming techniques.

Delivery

Classroom

Duration

2 days

Locations

  • Public Schedule - Perth
  • Group Bookings - All States and Territories across Australia

Prerequisites

It is essential that students have attended an Advanced Excel course or have the skills and experience of topics covered in that course. Participants should have extensive experience in designing and creating workbooks and a good working knowledge of formulas, ranges, functions and multiple workbooks.

Course Content

Macro Overview

  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros
  • Create and work with user-defined functions

The VBA Environment

  • Work with the main components of the VBA Editor window
  • Understand the Excel object model and use the Immediate window

Creating Procedures

  • Create command procedures
  • Create and use variables
  • Write code to manipulate Excel objects

Programming Techniques

  • Use a range of common programming techniques

 

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search