Introduction to Macros – Write Better Excel

Learn some deeper skills of an ever-present office tool.

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 session 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 session 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

Please note that the demonstration will be given using Excel for Office 365. However, the version of Excel used in the session 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.

You will also be provided with: 

• Access to watch the Live Webinar 
• Opportunities to ask real time questions to the presenter/s
• Poll questions to test your knowledge 
• Access to On Demand recording, which can be viewed multiple times, for as long as required 
• Presenters contact details for follow up questions 
• CPD Quiz (for On Demand recordings)
• CPD Certificate 
• CPD Report – Logged automatically 
• PowerPoint Presentation
• Verbatim Transcript, with Searchability
• Supporting Documentation