Excel-Automation with Macros

Overview:

• Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets?
• Do you have a time-consuming Excel-based process that you want to automate?
• Do you want to control how Excel acts when a file is opened, closed, saved or printed?

If the answer to any of those questions is “Yes”, it’s time to learn how to create a macro.

In short, a macro allows you to automate Excel, allowing you to spend more time on other things!

Objectives:
In this session, you will learn how to create and edit macros, create macros that can be re-used across multiple files and create macros that run automatically based on an event such as opening or closing a file.

Why Should You Attend:
Being able to create and edit a macro is one of the must-have skills for Excel Power Users. Having this knowledge will save you, your colleagues, and your customers hours of time by allowing you to automate any Excel-based task or process. If you’ve never created macros before, this webinar is for you.

Areas Covered in the Session:
•  Using the Macro Recorder to create a macro
•  Saving a file as a macro-enabled Excel workbook
•  Running a macro
•  Creating a button to run a macro
•  Editing a macro
•  Using the Personal Macro Workbook – to make macros available to all files
•  Creating a macro that runs automatically when a file is opened