Discover How to Automate Repetitive Tasks to Save Time with Your Spreadsheets
Save Time by Automating Repetitive Tasks with Simple-to-Use Macros Do you find yourself repeating the same click-click-click sequence of keystrokes over and over again when you’re working on spreadsheets? If you do, you’ve probably also found that using multiple keystrokes opens yourself up to slip-and-click errors that consume even more of your time … or cause embarrassing gotchas! This interactive 90-minute webinar explores the rationale and techniques for using macros in Excel to eliminate repetitive command sequences, automate your work, and use Excel more efficiently. A macro is Excel’s automation tool. As you work with this powerful software, you often find yourself performing the same tasks repeatedly. If you regularly update sales figures, plot data on a chart, or apply special formats, you may find yourself repeating the same sequence of commands and actions. With a macro, you can store these sets of procedures and avoid having to repeat the entire sequence of actions each time you need to perform them. You can also easily activate them with a keystroke combination, a toolbar button, or an on-screen pointer. The result is that you’ll save a good deal of time and effort and improve accuracy by creating macros. About Your Instructor BJ Wilson is a Microsoft Certified Trainer and Excel expert with Osprey Productions. He has been helping people learn Microsoft Office for the past 10 years.
Seminar Number: 82081
Course Scheduling & Pricing
Do you find yourself repeating the same click-click-click sequence of keystrokes over and over again when you’re working on spreadsheets?
If you do, you’ve probably also found that using multiple keystrokes opens yourself up to slip-and-click errors that consume even more of your time … or cause embarrassing gotchas!
This interactive 90-minute webinar explores the rationale and techniques for using macros in Excel to eliminate repetitive command sequences, automate your work, and use Excel more efficiently.
A macro is Excel’s automation tool. As you work with this powerful software, you often find yourself performing the same tasks repeatedly. If you regularly update sales figures, plot data on a chart, or apply special formats, you may find yourself repeating the same sequence of commands and actions.
With a macro, you can store these sets of procedures and avoid having to repeat the entire sequence of actions each time you need to perform them. You can also easily activate them with a keystroke combination, a toolbar button, or an on-screen pointer.
The result is that you’ll save a good deal of time and effort and improve accuracy by creating macros.
BJ Wilson is a Microsoft Certified Trainer and Excel expert with Osprey Productions. He has been helping people learn Microsoft Office for the past 10 years.
Join us to discover exactly what macros are and how to put them to work for you right now! You’ll learn the best and fastest ways to create and modify time-saving macros with a minimum of effort, including:
By seeing examples of how you can automate repetitive tasks—whether short or long—you'll be able to create tools that you can use to work more efficiently with Excel. Plus, a quick introduction to the world of Visual Basic will give you insight into how this programming feature broadens the scope of Excel usage.
Get the expertise others envy—and bosses clamor for!
After completing this course, you will be able to demonstrate a working knowledge of creating Excel macros to reduce keystrokes when analyzing and manipulating complex data in spreadsheets.
AMA Webinars provide you with a cost-effective and convenient way to boost your know-how. You can participate in the comfort of your home or office without the need for travel costs and time.
BONUS: Paid registrants will also get a single-user license to access a recorded archive of the program for a full year.
Please note that AMA Webinars are designed to provide a one-to-one learning experience for an individual and are not designed to be viewed in a group setting. Program access is available only via the MYAMA account of the registered attendee.
Please note: The instructor will be demonstrating these methods and techniques using Excel 2016.
*Microsoft and Excel are registered trademarks of Microsoft.
For the best viewing experience, these are the following recommendations:
For On Demand Viewing, you will need:
You will also need to check the Internet Connection Requirements (playback) section for internet connection speed requirements.
For Live Events, you will need:
TEST NOW
Online Schedule
1 Session Available