Don't be afraid of macros - learn how to create and effectively use them.
When you find yourself repeating actions in Excel®, whether it's a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, and print multiple worksheets once a week, the possibility exists that you can automate these actions in the form of a macro. Thereafter, you can perform these sets of actions with a simple keystroke combination, a button in a worksheet, or by using a button in the Quick Access toolbar. This topic shows you how to create these macro shortcuts, alerts you to situations ideal for creating macros, and explores the actual code, in the language called Visual Basic, created when you record command sequences. This is not a course in Visual Basic, but you will get a quick look at it and understand its role in creating and using macros. Creating a macro may ultimately involve programming techniques but most macros are developed by recording the way you use standard Excel® commands. This topic will show you how to create macros and give you examples of various macros that handle large amounts of information and interact with multiple files. You will also see how to activate a macro with commands, buttons, keystrokes, or pictures.
Add to Wishlist
More Program Information
Why Lorman?
Over 37 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.
Agenda
Rationale for Using a Macro - Why?
- Frequent Use of Lengthy Command Sequence
- Sort/Print/Re-Sort/Print Sequence
- Length Data Manipulation Need
Steps Used to Record a Short Macro
- Naming the Macro
- Assigning a Keystroke Shortcut
- Storing the Macro
- Avoiding Pitfalls While Recording
How to Run (Play Back, Execute) a Macro
- Keystroke Shortcut; Command
- Button in the Quick Access Toolbar
- Worksheet Picture or Clipart
Visual Basic
- Quick View
- Comments and Commands
- Editing Code
- Viewing Code as You Record a Macro
Using the Step Method to Test a Macro Slowly
Using IF Logic in a Macro to Create Different Actions Based on Changing Conditions
Extend the Power of Macros to Perform Tasks You Cannot Achieve With Standard Excel® Features
Add to Wishlist
More Program Information
Why Lorman?
Over 37 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.
Credits
OnDemand Course
This course was last revised on April 16, 2019.
Call 1-866-352-9540 for further credit information.
This program does NOT qualify, nor meet the National Standard for NASBA accreditation.
Add to Wishlist
More Program Information
Why Lorman?
Over 37 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.
Faculty
Dennis Taylor
Taylor Associates
- Founder of Taylor Associates
- More than 20 years of experience working with Excel®
- Taught thousands of classes and seminars throughout the United States and Canada
- Presented more than 700 Excel® webinars and is the author or co-author of six books on spreadsheet software
Add to Wishlist
More Program Information
Why Lorman?
Over 37 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.
All of your training, right here at Lorman.
Pay once and get a full year of unlimited training in any format, any time!
- OnDemand Courses
- Live Webinars
- MP3 Downloads
- Course Manuals
- Executive Reports
- White Papers and Articles
Additional benefits include:
- State Specific Credit Tracker
- All-Access Pass Course Concierge
Questions? Call 877-296-2169 to speak with a real person.
Access to all training products for one year
$699/year
Unlimited Lorman Training
With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!
Easy Registrations
Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.
Invest in Yourself
You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.