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:  $159.00
GovEvents Member Price: $100.00


More GovEvents Member Deals

Website
Click here to visit event website


Organizer
Global Wizdom


Contact Event Organizer



Return to search results