Discover Classes. Earn 10% Rewards.

Excel 2007 - VBA is unfortunately unavailable

Thankfully we have 34 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Gain comprehensive Excel expertise in this intensive three-day course that moves from foundational calculations through to advanced automation with macros. Whether you're building on basic knowledge or aiming for expert-level proficiency, this well-paced program covers the full range of tools and techniques that make Excel an indispensable asset in any professional setting.

(452) Beginner 18 and older
$599

6 sessions

Gift it!

Excel Expert Certification Program

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Reach advanced Excel proficiency in this complete program. Through group sessions, private instruction, and a certification exam with one free retake, you'll cover formulas, functions, PivotTables, charts, and career-boosting tools.

(452) All levels 18 and older
$1,149

3 sessions

Gift it!

Excel Specialist Certification Program

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Become an expert in Microsoft Excel and strengthen your resume through this comprehensive certification program. Get lifetime access to video courses, private training, and free proctored exams. Grow your skills and stand out in the competitive job market.

(452) All levels 18 and older
$959

6 sessions

Gift it!

Excel Level III: Advanced

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Gain sophisticated Excel skills in this comprehensive course focused on tackling complex data challenges. Students learn to apply advanced analysis techniques, build efficient macros, and leverage powerful functions to streamline workflows and improve accuracy. Practical training designed to make a direct impact on productivity in any professional environment.

(452) Advanced 18 and older

Data Analytics Technologies Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Through this course, students build mastery in Excel, SQL, and Tableau, some of the top data analytics tools. Students develop the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.

(452) All levels 18 and older
$1,949

8 sessions

Gift it!
See all Excel classes NYC
  • Advanced
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 462 Seventh Ave, New York, NY

Start Dates (0) $295/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

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 Policy

Please notify us at [email protected]

  • 7 or more business days in advance of your scheduled class if you need to cancel your reservation for applications classes.
  • 12 or more business days for technical classes.
You will receive a 95% refund if you cancel according to the terms above for applications and technical classes.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at New Horizons Computer Learning (8)

Similar Classes

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. Earn 10% back in reward points!

New Horizons Computer Learning

New Horizons Computer Learning Center, part of the world’s largest independent IT training provider, offers flexible learning options from instructor-led and online courses to customized corporate training. With programs ranging from Microsoft Office to advanced Cisco and Citrix certifications, New Horizons equips individuals, businesses, and government agencies with the skills to succeed in today’s technology-driven world.

View school profile
New Horizons Computer Learning
Vetted by CourseHorse

A verified NYC educator.

Loading...