Excel Macros and VBA

Description

This webinar will give you the building blocks for learning code, as well as Spreadsheet automation to increase productivity. 

You will create a variety of macros learning how to best automate repetitive tasks, create customised forms and programme solutions in Excel.

Learn how to harness the power of Excel through macros and coding and how it can open up a world of possibilities in transforming the way you do work.

Spreadsheet automation is an essential skill for Excel users who want to take their day to day use of Excel to the next level. 

Demonstration of how to relate the code to an Excel worksheet, ranges and cells.

We will learn how to:
• Generate emails from Excel.
• Attach pdfs to an email.
• Generate a variety of loops to perform these tasks numerous times that we can control.

There are no pre requisites for this course apart from being a competent user of Excel. The code we generate will come from macro recordings and forums we find on the internet. We will take this code, ensure we understand what the code does the add our own enhancements to complete set tasks. This is exactly the way 95% of programmers operate!

Presenter Bio:                                                                                                    
For over 20 years, Jason Leiper has provided leadership while training in qualified systems, business and information management training in government, while also training in universities and private circles.

You will be provided with: 

• PowerPoint presentation slide deck 
• Supporting documentation 
• Webinar Recording to view multiple times for up to 6 months 
• An opportunity to ask questions to the presenter

Introductory overview of Macros and VBA (Visual Basic for Applications).

  • Webinar Recording
    • PD hours: 1
    Stream this recording multiple times at your convenience.
    • $180.00 incl. GST

Coming Soon

All Coming Soon >>

One-Connection-One-Fee

Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.

Recordings

Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! You can watch it as many times as you like for up to 6 months. You will also receive Supporting Documentation.