Discover Classes. Earn Rewards.
Welcome to CourseHorse!

Valuable Rewards & Savings

40,000 Classes to Choose From

Verified Student Reviews

Prompt Customer Service

Fast & Secure Checkout

Price:
$295
4 seats left
Start date: Mon, Oct 13 9:00am - 4:30pm
Location: Murray Hill
290 Madison Ave 3rd floor
(Btwn E 40th & 41st Streets)
New York, New York 10017
(Map)

Class Information

  • Class Level: Advanced
  • Age Requirements: 18 and older
  • 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


Outline

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.

Refund & Cancellation Policy

Cancellation & Refund Policies

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.

Price Guarantee

We promise that our prices are the same (or less) than prices on the school's website

Comprehensive

We centralize over 40,000 classes from vetted, high quality class providers

Verified Student Reviews

CourseHorse is the only place where you can read class reviews from verified students

Incredible Service

We're dedicated to supporting your learning goals every step of the way

Fast & Secure Checkout

Single-page checkout and powerful encryption make CourseHorse the place to book

Save on Every Class with CourseHorse

We give you back 5% of every class purchase, to encourage you to keep on learning!

Start Dates (1)

Start Date # of Sessions Price
1 $295 Book

Schedule:
Mon, Oct 13 9:00am - 4:30pm

Location:
Murray Hill, Manhattan
290 Madison Ave
3rd floor
Btwn E 40th & 41st Streets
New York, New York 10017

Map

Can't make these dates? Save to Wish List this class to find out first about new class dates.

Save to Wish List

Map

Google Map
New Horizons Computer Learning
Murray Hill
290 Madison Ave
3rd floor
Btwn E 40th & 41st Streets
New York, New York 10017

All classes at this location

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 School

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

Reviews of Classes at New Horizons Computer Learning

(3 Reviews)


Attended: Excel 2010 - Level 3

The instructor was helpful and engaging. The class was well designed and I walked out with a lot of new tricks to improve my work with excel.


Attended: Excel 2010 - Level 2

Although I already had a base of knowledge of Excel at the intermediate level, I picked up a number of new skills that will really help me on a number of projects. The course was very useful and will be beneficial to my work going forward.


Attended: Grammar Skills

Although the teacher was enthusiastic, knowledgeable and specifically asked each student what they wanted to focus on, she frequently got off track. As a result I did not get nearly as much as I had expected- definitely not $275 worth! I did however get a short list of useful resources which the teacher promptly emailed to me. Given the hefty price of this course I would not recommend it. I think you would get more by doing free grammar activities online.

Ready to take this class?

Book Online
Or call 212-729-4088

Taking this class for work? Get exclusive perks & discounts for free.

Need help finding a class? Call 212-729-4088 or email [email protected]
Customer Service: 212-729-4088