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
Speaker and Presenter Information
Speaker: Mike Thomas
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office, especially Excel.
In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials.
Relevant Government Agencies
State & Local Government
Event Type
Webcast
This event has no exhibitor/sponsor opportunities
When
Tue, Aug 25, 2020, 1:00pm - 2:00pm
PT
Cost
GW - 7638: | |
GovEvents Member Price: | $100.00 |
More GovEvents Member Deals
Website
Click here to visit event website
Organizer
Global Wizdom