Discover Classes. Earn Rewards.
Price:
$295
Start date:
This class has ended. Save to Wish List to find out when new dates are added.
Location: Murray Hill
290 Madison Ave 3rd floor
(Btwn E 40th & 41st Streets)
New York, New York 10017
(Map)

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!

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.

Start Dates (0)

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.

Want to take this class?

Save to Wish List

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