Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Excel Macros Training Course

Excel Macros Training Course


Course Description:  The Excel Macros course will train students on how record Macros in Excel to automate repetitive tasks and reports. Students will learn to Macro basics (recording and Running Macros), using formulas and functions in Marcos and doing data entry with Macros. This class is for non-programmers. The Excel Programming with VBA course is ideal if you need to build more complex programs and automated procedures.

Upon completion of the course, users will be able to:

  • Basic Macro Recording
  • Running Macros
  • Creating Dynamic Macros
  • Using Functions and Formulas in Macros
  • Working with Files
  • Using Macros for Data Entry
  • Connect directly to data stores

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 10/9/2020 - 10/9/2020
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 11/3/2020 - 11/3/2020
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 12/4/2020 - 12/4/2020
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 12/29/2020 - 12/29/2020
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 1/27/2021 - 1/27/2021
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 2/25/2021 - 2/25/2021
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 3/26/2021 - 3/26/2021
Course Fee : $395


Excel Macros
Locations: Available Nationwide and Online
Class Date(s): 4/21/2021 - 4/21/2021
Course Fee : $395


Course Syllabus

Configuring Excel for Macros
Using The Developer Tab
Macro Security
Trust Center
Saving Files

Basic Macro Recording
The “Record Macro” Window
Rules for Macro Names

Running Macros
Run a Macro from the Developer Tab
Run a Macro Using a Shortcut Key
Run a Macro from a Button
Run 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
Create a worksheet to use as a Data Entry Form
Create a macro to add the data to a table

Onsite excel Training
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)




Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile