Welcome to ONLC Training Centers

Excel Macros Course

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $395

Savings options:

 Learning Credits
 Office 5 for 4
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


Excel Macros Course

 

Excel is our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible.

Excel is our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible.

Overview

Advanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis. Using “Macros” many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again).

Prerequisite

Proficient knowledge of Microsoft Excel. This class is for non-programmers.

Target Student

This course is for individuals who use Excel 2016, 2013 or 2010 frequently and who need to automate routine tasks. Programming experience is not required.

*** NOTE: A More Advanced VBA Programming Class is also Available ***

Do you need to construct more complex programs and automated Excel procedures? Consider our
Excel Programming for VBA course.

Course Outline

Configuring Excel for Macros

  • The Developer Tab
  • Macro Security
  • Trust Center
  • Saving Files

Basic Macro Recording

  • The “Record Macro” Window
  • Rules for Macro Names

Running Macros

  • Running a Macro from the Developer Tab
  • Running a Macro Using a Shortcut Key
  • Running a Macro from a Button
  • Running a Macro from a Worksheet Object

Creating Dynamic Macros

  • Absolute versus Relative References
  • Effective Range Selection
  • The Importance of the Cursor’s Position
  • Handling Empty Cells in a Data Range

Using Functions and Formulas in Macros

  • Creating dynamic formulas
  • Filling Formulas
  • Using Data Tables
  • Deleting Empty Rows at the End of a Worksheet
  • Functions with Dynamic Ranges

Working with Files

  • The Personal Macro Workbook
  • Using Hyperlinks
  • Writing Macros that Work on Variable File Names
  • Importing a Text File

Macros for Data Entry

  • Creating a worksheet to use as a Data Entry Form
  • Creating a macro to add the data to a table

 

View outline in Word

WEXM19

Attend hands-on, instructor-led Excel Macros training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com