We use cookies to provide you with a better experience. Full functionality may not be available if cookies are denied.
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.
$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 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
