IconLogoc IconLogoc

Macros and Automated features in Word and Excel Training

Macros and Automated features in Word and Excel Training

This class requires a minimum of 5 students to run.

Course Date Course Time Price Seats
Apr 14 2021 1:30pm - 4:30pm ET

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.

Be the first to review this course.

Write Your Own Review

Only registered users can write reviews. Please, log in or register

Thank you Kevin, this was incredible!
Erin Skolte