Here's $10 towards your first class. Join for free
Discover Classes. Earn Rewards.
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Midtown, Manhattan
462 Seventh Ave 6th Flr
Btwn W 36th & W 37th Streets
New York, New York 10018
Class Level: Advanced
Average Class Size: 6

What you'll learn in this excel class:

In this course, students will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.

Who Should Attend
Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Prerequisite(s) or equivalent knowledge
Excel 2007 - Level 1
Excel 2007 - Level 2
Excel 2007 - Level 3


Lesson 1: Developing Macros
  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys
  • Work with Macro Security
Lesson 2: Formatting Worksheets Using Macros
  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report
Lesson 3: Creating an Interactive Worksheet
  • Determine the Dialog Box Type
  • Capture User Input
Lesson 4: Working with Multiple Worksheets
  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets
Lesson 5: Performing Calculations
  • Create User-Defined Functions
  • Automate SUM Functions

Note: There are PC computers at location for students to use.

Please notify New Horizons six (6) or more business days in advance of your scheduled class if you need to cancel your reservation for applications classes, and eleven (11) days or more business days for technical classes.  

Cancellations may be made by calling or e-mailing your Account Executive. You will receive a 100% refund if you cancel according to the terms above for applications and technical classes.  

If you are a club member, you may be assessed a late fee of $50.00 for an applications class, and $200 for a technical class if you cancel late or do not show up for class.  

If you are a coupon holder, you will be assessed one coupon for each class that you do not show up for.


Google Map
New Horizons Computer Learning

All classes at this location
Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!

Reviews of Classes at New Horizons Computer Learning

(8 Reviews)

School: New Horizons Computer Learning

As part of the largest independent IT Training Provider, New Horizons Computer Learning Center delivers more courses than any other IT training company.

Innovative and Flexible Learning Methods

New Horizons New York City understands that not everyone is the same, and we have developed a variety of innovative...

Read more about New Horizons Computer Learning

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free. Learn More