0845 450 6120

Excel Macros

Increase the usability of your Excel spreadsheets by adding a little programming to them. While Excel's formulas and spreadsheet features make it a great tool, mastering the ability to create macros will make it even greater and faster to work with

This course is designed for Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) in the application using macros.

Please note that course contenet may vary by course location and date, please check the course content on your chosen date

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

We don't currently have any courses listed for Excel Macros, would you like to view all courses for Microsoft Office?

Learning Objectives

At the end of this course, delegates will learn how to use macros to automate processes and also be able to edit macros.


• Record / Run Macros
• Write Code Manually
• Perform Loops, Controls and Error Handling
• Create UDF Functions and Add-ins
• Create User forms and Sheet Controls
• Use Events

Pre-Requisites

Delegates should have a good grounding in Excel (any version) and be familiar with absolute verses relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage.

Course Content

1. Introduction and the Macro Recorder
2. Objects and Dialog Boxes
3. Creating and Editing Macros With VBA
4. Introduction to Controls

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include