School Event

An Introduction to Macros and VBA in Excel

An introduction to Macros and VBA in Excel

By Kate Daus

2 Days

·         Learn how to record, edit and debug a macro

·         Learn how to make a macro do complex tasks

·         Make a workbook user-interactive

·         Create user-defined functions

·         Learn to control Excel by programming in VB

·         Save time by automating repetitive tasks

An Introduction to Macros & VBA in Excel is aimed at introducing you to the power of Visual Basic in Excel. This course is for those who want to learn how to use VBA to program Microsoft Excel for a more professional result. Whether performing repetitive tasks on large spread sheets or compiling Excel Workbooks for other users, or just wanting to simplify your own tasks, learn to work smarter, not harder. Coding functionality using VB can be used to create extremely powerful and complex spreadsheets.

The content from this course allows the user to automate repetitive tasks and achieve more flexibility with Excel than through the front end alone. 

This intensive, interactive and hands on 2 day course is offered to the user who has a thorough understanding of MS Excel and has completed up to and including the MS Excel Advance course. A prior knowledge  of Visual Basics or programming is not required.

Note: Computer based exercises are done throughout the course and delegates will have a practical example and code to utilise in their workplace.

This new course is being presented by the enthusiastic and extremely knowledgeable trainer Kate Daus, who presents the renowned and successful Advance Excel course.  
**You can only register for this course, if you have done Advanced Excel** 
 An Introduction to Macros in Excel 
Making Macros do complex tasks
  • Creating and editing a simple macro
  • Debugging a macro
  • Customise the Quick Access Toolbar
  • Object – oriented programming
  • Loop structures
  • Using variables and operators
  • Creating a master macro                                
Working with Worksheets Creating User-Defined Functions
  • Add, copy and delete worksheets
  • Rename and reorder worksheets
  • Using the Print and print preview commands
  • Perform calculations by creating user defined functions
Dates and Times:
  • Tue 16 May 2017  08:30 to 16:30
  • Wed 17 May 2017  08:30 to 16:30
Type: Course
Venue: CESA Training Centre, Johannesburg , Paulshof
Fee: R 7 267.11 excl. VAT
CESA member fee: R7 153.11 excl. VAT
CESA Validation Num: CESA-731-07/2018
CPD Points: 2
Coordinator: Blessings Banda