Write Better Excel 2019 – Introduction to Macros

Description

Excel macros provide a way to automate tasks in spreadsheets. The use of macros can save time and increase the accuracy with which repetitive actions are performed.

Three highly practical case studies steer this webinar from your very first macro to more practical macros which are both useful in themselves and a foundation of principles for you to extend to your own code.

This is the final part of 5 popular webinars in 2019 covering smart ways to efficiently use Microsoft Excel. This webinar will concentrate entirely on writing macros but it is not aimed at developers! It will suit reasonably experienced Excel users with an appetite to get started with or advance their macro skills.

The session will include:

  • Introduction
  • Orientation, terminology
  • Case Study 1 – Recording your first macro
    • (Create, locate, understand, rename, run & edit a simple macro)
  • Case Study 2 – Understanding references and recording methods
    • Creating macros which can perform operations accurately around different locations in a spreadsheet)
  • Case Study 3 – Creating a dynamic macro
    • (Using variables so that your macros can interact with your spreadsheet)
  • Debugging
  • Q&A

The 5 webinars in the Write Better Excel series 2019 (in the order presented and the order of difficulty) are as follows

Tips for Total Beginners (March)
The Fundamentals (May)
Handling Data (July)
Charts & Sparklines (Sept)
Introduction to Macros (Nov)

If you would like to view a recording you can find them in our On Demand section.

It is not required that attendees have attended webinars 1-4 before joining this webinar, however, mastery of Excel basics will be assumed.

Please note that the demonstration will be given using Excel 2013. However, the version of Excel used in the webinar itself is of very limited importance as the points made extend to all versions.

LEARNING OUTCOMES

Attendees will learn how to write, locate, edit and run a very simple macro. They will also learn two key principles (references and variables) which can be applied to the creation of their own more complex macros. Debugging will be briefly covered.

SUITED TO

Anyone who has mastered the basics of Excel and wants to begin writing macros. Attendees should already understand the difference between absolute and relative references and be familiar with how to name ranges in spreadsheets. This session is not intended for specialist code developers.

PRESENTER

Richard Dams, Director, PepTalks

 

1.25 CPD Hours

  • Nov 20
    Wed, 10:30 AM NZDT - 11:45 AM NZDT Online
    • $190.00 excl. 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

All registrants that do not log into the live webinar are automatically sent a recording either later the same day or early the next business day.

If you did log in and wish to view again simply drop us a line at NZ‑learning@wolterskluwer.com and we’ll be happy to send it to you via email.

Sole practitioners

A discount on webinars is available for sole practitioners. Please contact us at NZ‑learning@wolterskluwer.com to confirm eligibility.