Excel Automation: Automating Tasks with Macros

Price: $

Summary

Duration: 60 mins

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.

Macros free up much time by automating routine tasks in Excel. They allow you to store the sequence of actions it takes to complete tasks, and therefore shorten time spent on tedious commands by the click of a button! In this session, you will learn how to record & edit macros, create macros that can be re-used across multiple files, and create macros that run automatically based on an action, such as opening or closing a file.

Topics covered:

Use the Macro Recorder to create a macro

Save a file as a macro-enabled Excel workbook

Different ways to run a macro

Edit an existing macro

Use the Personal Macro Workbook to use specific macros across all files

Run macros automatically when a file is opened

Why you should attend

Being able to create and edit a macro is one of the must have skills for Excel users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. No more wasting time on repetitive actions in Excel!

Who should attend

This webinar gets you started with macros. It's aimed at intermediate-to-advanced users of Excel and is relevant to all industries and job roles.

The training will be delivered using the latest version of Excel for Windows although much of the functionality is available in earlier versions of the application too.

About the Speaker

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and hundreds of courses and webinars on a wide variety of technology-related topics.

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Credits

Credit Hours:

Field of Study:

Program Level:

Basic Knowledge

Prerequisites:

None

Advance Prep:

Delivery Method:

Group Internet Based

Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Purchase This On-Demand Webinar