Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

Province

Postal Code

Country
List

Work Telephone

Ext.

E-mail Address

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

A representative will contact you to follow up your request.

 
Special offer: Training Vouchers - Free Courses with purchase.

 

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 Enrol

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.
Sep 14Toronto enrol
Oct 26Ottawa enrol

US Dates

Jul 19Reston, VA enrol
Aug 7Rockville, MD enrol
Sep 11Alexandria, VA enrol
Oct 2New York enrol
Oct 16Reston, VA enrol
Dec 4Rockville, MD enrol
Jan 15Alexandria, VA enrol
Jan 29New York enrol

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

More Dates and Locations.

 

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

 

Average Attendee Evaluation

 Evaluations in the last 12 months

5 stars:
71%
4 stars:
25%
3 stars:
4%
2 stars:   0%
1 star:   0%

PMI 3 PDU
 
Ten Questions to Ask Your Training Provider - Position Paper