Price:
$295
(1 session)
4 seats left
Session:
Mon, Sep 29
9:00am - 04:30pm
Location: Murray Hill
290 Madison Ave 3rd floor
(Btwn E 40th & 41st Streets)
New York, New York 10017
(Map)
Book Online

Need help booking?
Call us: 212-729-4088

Save to Wish List

Give as a gift
Book a private event

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 training:

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.

Interested in an On-Site Class or Custom Program from New Horizons Computer Learning ? Request info about private training

Start Dates (1)

Start Date # of Sessions Price
1 $295 Book

Can't make these dates? Find out first about new class dates by saving it to your wish list or request info about private training.

Save to Wish List

Schedule:
Mon, Sep 29 9:00am - 4:30pm

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

Map

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

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.

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]