Automating Repetitive Tasks with Excel Macros

When

10/15/20 1:00 pm EDT

Our Customer Assurance Pledge

If this webinar fails to meet your needs, we will refund 100% of your tuition – no hassles, no questions asked.

Recording Only

Our Price: $219.00

Per Attendee

Event Description

Do you find yourself repeating 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 and master the macro, a powerful Excel automation tool.

Macros save time and provide consistency in almost any Excel spreadsheet, from the simplest personal report to complex dashboards and group reports involving external data, multiple sheets, pivot tables and charts.

Who Should Attend
This webinar gets you started with macros and improves your skills if you’re already familiar 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.

Why You Should 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

Customer Reviews Back To Top

Speaker Back To Top

Mike Thomas has over 25 years experience designing and delivering face-to-face and virtual training courses. He’s well-known for his patient, easy-to-follow training style and welcomes questions before, during and after his sessions. Mike has authored nearly 200 written and video-based Excel tutorials. He also develops Microsoft Office solutions to automate key business tasks and processes.

Topics Back To Top

Key Objectives

How to create and edit macros
How to create macros that can be re-used across multiple files
How to create macros that run automatically based on an event such as opening or closing a file.

Topics covered

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 run automatically when a file is opened

What Comes with Your Purchase? Back To Top

You Will Receive

Interactive, engaging live webinar training
Q & A with the your trainer
Sample Excel spreadsheets and templates you can use after the training session

Bring Your Team – Group Package Pricing Back To Top

5 or More Attendees? Discounted Group Packages Available, Please Reach Out To:
support@bizwatchnetwork.com

Companies Who Trust Us Back To Top