Request Info

Salutation

First Name

Last Name

Job Title

Company

Post Code

Country
List

Office Telephone

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.

Free Courses with Training Vouchers
 

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 initialising variables
  • Automating changes in multiple PivotTables
  • Developing an interactive interface with form controls

Course 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
 

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

Course Dates

Live online classroom training. Attend highlighted events in person or live, online via Learning Tree AnyWareTM.
Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.

US East Coast Dates

19 JulWashington, DC enrol*
7 AugWashington, DC enrol*

*Work and train on the same day! Attend live US East Coast Courses online from 2pm to 9pm GMT.

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

More Dates and Locations.

 

Fees

£ 195Standard Fee

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customised for your organisation.

 

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