Virtual Live Instructor
Free Training Manual
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:
Configuring Excel for Macros
Using The Developer Tab
Basic Macro Recording
The “Record Macro” Window
Rules for Macro Names
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
Using Data Tables
Deleting Empty Rows at the End of a Worksheet
Functions with Dynamic Ranges
Working with Files
The Personal Macro Workbook
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
Please check the course description to find prerequisite information.
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Instructor led training is a cost effective and convenient learning platform for busy professionals. Most courses are available at over 300 locations nationwide and Online.
The classes are taught via the RCI method by professionally certified instructors, and are usually limited to 12 or less students. Each student receives a training manual and practice problems, along with a free course retake. Click here to learn more about Instructor Led Training
Below is a list of upcoming Excel Instructor Led Class Dates:
We offer private Excel group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Excel Private Group Training from Business Computer Skills can help your team.