Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

State

Zip Code

Country
List

Work Phone

Extension

E-mail

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

  

Excel® Macros:
Increasing Productivity through Automation

Course 1372 • 1/2 Day

 E-mail E-mail  Print Print  Q&A Q&A  PDF PDF  Facebook Facebook  Twitter Twitter

Quick Enroll

You Will Learn How To

  • Create macros to simplify workbook tasks
  • Identify Excel workflow processes for automation
  • Troubleshoot code in the Visual Basic Editor (VBE)
  • Identify cells in code and extract values from cells
  • Build dynamic user interfaces with form controls, toolbar buttons and keystrokes
  • Expand the capabilities of a macro using variables

Course Benefits

Excel macros improve productivity and streamline your workflow by automating multistep tasks. In this course, you learn how to identify processes to be automated and gain practical experience creating and troubleshooting automated solutions to save time and be more productive.

Who Should Attend

Anyone who needs to design and troubleshoot macros. A working knowledge of Excel is assumed.

Hands-On Training

  • Easing repetitive tasks through macros
  • Adding functionality and troubleshooting a macro
  • Identifying data types and initializing variables
  • Automating changes in multiple PivotTables
  • Developing an interactive interface with form controls

Course 1372 Content

Identifying Workbook Processes for Automation

  • Repetition
  • External data sources
  • Complex sequence of actions
  • Determining issues with inherited workbooks

Automating Processes with Macros

Creating and troubleshooting macros

  • Exploring the recording process
  • Mapping a macro to the interface
  • Working with the Visual Basic Editor
  • Identifying code components of a macro
  • Interpreting lines of code
  • Investigating troubleshooting techniques

Enhancing your macro

  • Incorporating variables into the solution
  • Identifying the context of data types
  • Expanding your workbook models through form controls
  • Leveraging list box and state value controls
  • Adding functionality through user dialogs

<< Back to Excel, Office and Access Course List
 

Related Courses

Excel is a registered trademark of Microsoft Corporation.
Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
  
Excel Macros: Increasing Productivity through Automation

Training Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.
Jul 19Reston, VA enroll
Aug 7Rockville, MD enroll
Sep 11Alexandria, VA enroll
Sep 14Toronto enroll
Oct 2New York enroll
Oct 16Reston, VA enroll
Oct 26Ottawa enroll
Dec 4Rockville, MD enroll
Jan 15Alexandria, VA enroll
Jan 29New York enroll

For AnyWare enrollments, please register at least 7 days prior to the start of the course.

More Dates and Locations.

 

Tuition for Course 1372 (1/2 Day)

Bring this or any Learning Tree Course on-site to your location!

 

PMI 3 PDU