Microsoft Word and Excel Macros Training
Macros allow you to automate your work by creating a mini-program which completes repetitive tasks for you. Complicated macros require Visual Basic programming. This class will not cover programming. Instead, we will use the record feature to record some simple macros and then replay them. We will assign macros to keystrokes and buttons and learn how to do some basic editing of macros. We will also learn ways of automating text entry without using macros.
Who Should Attend?
Intermediate to Advanced users of any version of Word and Excel who want an introduction to macros.
Topics covered include, but not limited to:
- Automating data entry
Learn some quick ways of automating data and text entry including AutoCorrect, QuickParts, and Building Blocks.
- Steps to creating a macro
You want to plan your macro out before starting to record to be sure it is efficient and it works the way you expect! We will also discuss the correct ways to save macros in files.
- Record a macro and simple editing of the macro
When you record a macro, it records the Visual Basic required behind the scenes. We will record several and then try to do some simple editing of the Visual Basic to change how our macro works.
- Assign a macro to a keystroke or to buttons to play the macro anytime.
Once you have created your macro, you can assign it to a keystroke combination, a button on the Quick Access Toolbar, or a clickable button on the document itself!
About Your Instructor
Rosemary McCracken is a computer trainer with over 25 years of experience in the classroom. She teaches all levels of Microsoft Word, Excel, PowerPoint, Access, Visio and Outlook. In addition to Microsoft products, she also teaches G Suite, QuickBooks, InDesign, HTML/CSS and WordPress. Rosemary has a B.S. from James Madison University. She is Microsoft Office Expert Certified and is also a Certified Online Training Professional.