Discover Classes. Earn Rewards.
VBA Training Online is unfortunately unavailable

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

Course Details
Price:
$389
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!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Interactive Online Classroom
Important:
Class timing is 10 PM to 12 PM.
Description
Class Level: All levels
Age Requirements: 16 and older
Average Class Size: 6
System Requirements: Webinar is delivered using GoToMeeting for audio/video. Students need their own PC with fast Internet Connection, and they need to download the gotomeeting (citrix) plugin. 
Class Delivery: Ideally registrants should have two monitors, one to watch the live webinar and one to work with their copy of Excel.

Registrants will be emailed their own PDF notes and links to workbooks. 

Unique Benefits
Includes a 550 page user guide with hundreds of illustrations and hundreds of examples.  

Exclusive: 
Students also receive unlimited online access to our video library of an Excel class for you to review at your own pace. We also provide all the files used in the class on our website, including a searchable PDF and sample Excel tests.

What you'll learn in this excel class:

The class teaches several algorithms, approaches to solving problems with programming. Before you can use VBA to reconcile two workbooks you need to learn a few programming fundamentals. 

Fundamental algorithms include:
  • How to find the last row/column of data in a range.
  • How to locate key columns and use named ranges.
  • How to loop through a scenario.
  • How to read and write from/to cells (internal) and databases (external).
  • How to loop from row to row, sheet to sheet and workbook to workbook and process data with functions.
  • How to reconcile data between two workbooks.
  • How to communicate while a program is running and accept inputs with message boxes, input boxes and user forms.
  • How to debug programs and handle errors gracefully.
  • How to manage PivotTable reports.
  • How to communicate with web browsers, Word, PowerPoint, and Access.
VBA Online Outline:

Day 1: Advanced Excel Review
  • Windows Keyboard Shortcuts
  • Enable Macro Security Settings
  • Zoom
  • Formulas
  • Absolute Reference
  • Autofill
  • Data Filters
  • Subtotal Function
  • Sort
  • Subtotal Data
  • Freeze Panes vs Table
  • Named Ranges
  • Vlookup
  • Index Match
Day 2: Advanced Excel Features
  • If Functions
  • Formula Auditing
  • Database Functions
  • Text Functions
  • Array Formulas
  • Pivot Tables
Day 3: Macros, The VB Editor, Debugging
  • Anatomy of a Program
  • Call Statements
  • Record a Macro
  • Save As Macro Enabled
  • Assign Macros to Shapes
  • Edit a Macro
  • Debug a Macro
  • Modules
  • Procedures
  • Show The Developer Tab
  • Properties and Methods
Day 4: Introduction to VBA Programming

Prerequisites:
VBA requires you to type – alot. You should be able to type at least 20 words per minute – with reasonable accuracy – or you will have difficulty learning to program.

Still have questions? Ask the community.

Refund Policy
Cancel an order:
  • You can cancel your order three days prior to class for a refund.
  • Cancellations will be charged a $29 processing fee.
Reschedule your class:
  • You can reschedule a class one time if you notify us by phone or email 48 hours prior to class.
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!

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 3890 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Excel Class (65)

School: Excel Class

Excel Class

Learn Excel Class specializes in Excel training courses. The three Excel courses we offer are:

  • Beginner
  • Advanced
  • VBA Programming
Our comprehensive Excel training curriculum is taught in our New York facility – conveniently located across the street from Penn Station. We also offer New York City’s most...

Read more about Excel Class

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

143 Top Choices

Virtual Intermediate Excel

This class is temporarily being offered remotely.

at Julie Khidekel - Virtual Learning via Zoom

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Wednesday Jun 3rd, 6:30pm - 9:30pm Eastern Time

Virtual Excel for Beginners

This class is temporarily being offered remotely.

at Donna Sanabria - Virtual Learning via Zoom

Have you been wanting to learn Excel, but never had time for a long training course?  Do you have a project that requires Excel, but don’t know how to get started?  Are you looking to add another skill to your resume and give yourself a competitive advantage?  In this course you will learn how to get started and gain confidence with...

Wednesday Jun 3rd, 6pm - 10pm Eastern Time

Excel for Business Fundamentals - Level 1

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Friday Jun 5th, 10am - 5pm Eastern Time

Beginner Microsoft Excel 2016

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and complete beginners alike. Develop a command of time-saving Excel shortcuts and hotkeys. Practical Real-World Training Our Excel course includes practical exercises that walk you through the...

Friday Jun 5th, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Monday Jun 8th, 10am - 5pm Eastern Time

Advanced Excel for Business - Level 3

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Tuesday Jun 9th, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Thursday Jun 4th, 10am - 6pm Eastern Time

Intermediate Microsoft Excel 2016

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Monday Jun 8th, 10am - 5pm Eastern Time

Advanced Microsoft Excel 2016

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Develop expertise in Excel’s most advanced features and become a resident Excel expert. Maximize the power of Pivot Tables, save hours by automating tasks with macros, and develop experience with advanced database functions. By the end of this course, you'll have knowledge and skills above and beyond the requirements of most analyst roles. Practice-Based...

Wednesday Jun 3rd, 6pm - 9pm Eastern Time

  (2 sessions)
$219

2 sessions

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Sunday Jun 14th, 10am - 6pm Eastern Time

Excel Tips and Tricks: Essential Time-Saving Techniques

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this lively three-hour training session, you will learn many tips and tricks that will save you time every time you use Excel. We guarantee you will learn techniques worth remembering! Class Outline Formulas Display...

Wednesday Jun 3rd, 1:30pm - 4:30pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Saturday Jun 27th, 11am - 5pm Eastern Time

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Jun 4th, 6:30pm - 9:30pm Eastern Time

Virtual Excel Beginning Class

This class is temporarily being offered remotely.

at Computers Etc Software Training Center - Online

Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts. What you will learn: Create Formulas that add, subtract, multiply divide, etc: Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate...

Thursday Jun 4th, 9am - 4pm Pacific Time

Virtual Excel Package (Beg-Int-Adv) Class

This class is temporarily being offered remotely.

at Computers Etc Software Training Center - Online

Perform calculations with formulas, Use AutoSum, Edit a spreadsheet, Create charts & graphs, Advanced formulas, 3-D formulas, Link workbooks & consolidate data, Validation, Pivot table basics, Group / outline / sort / filter / subtotal data, Formula auditing, Templates, Conditional formatting, Password protect all or part of workbook, Functions,...

Thursday Jun 4th, 9am - 4pm Pacific Time

  (3 sessions)
$399

3 sessions

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Wednesday Jun 3rd, 2pm - 4:30pm Pacific Time

Excel at Excel: Getting Down The Basics Remote Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Jun 4th, 5:30pm - 8:30pm Central Time

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

Due to the current health concerns, all GA programs will temporarily be held online - including this one. Registered participants will be notified 24 hours in advance with information on how to log in to the Zoom meeting room and other tools needed for the workshop. Registration will close 2 hours prior to the start time in order to allow participants...

Thursday Jun 4th, 5:30pm - 8:30pm Central Time

MS Excel: Databases, Pivot Tables and Pivot Charts

This class is temporarily being offered remotely.

at Santa Monica College - Santa Monica SMC Bundy Campus 3171 S Bundy Dr, Santa Monica, California 90066

Advanced MS Excel: Working with Databases, Pivot Tables and Pivot Charts In a follow-up class to Intermediate MS Excel, continue building your skills as you learn how to use filters, how to work with subtotals, how to link data to a drop-down menu, how to create Sumif formulas, and how to make the most of pivot tables and pivot charts to take large...

Saturday Jun 6th, 9am - 2pm Pacific Time

Loading...