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

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

Class Tags:
Questions about this class?
Get help now from a knowledge expert!
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

78 Top Choices

Excel for Business Fundamentals

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....

Tuesday Jan 26th, 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,...

Wednesday Jan 27th, 10am - 5pm Eastern Time

Advanced Excel for Business

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...

Wednesday Feb 3rd, 10am - 5pm Eastern Time

Intermediate Microsoft Excel

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...

Sunday Jan 24th, 10am - 5pm Eastern 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....

Monday Feb 22nd, 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...

Saturday Feb 6th, 2pm - 5pm Eastern Time

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...

Saturday Feb 6th, 11am - 2pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Jan 30th, 12pm - 6pm Eastern Time

Excel VBA Macros: Write Custom Excel Macros in VBA

This class is temporarily being offered remotely.

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

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

Wednesday Jan 27th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions

Microsoft Excel Level 1

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

Monday Feb 1st, 9am - 4:30pm Pacific Time

Excel Advanced 1: Automating Tasks

This class is temporarily being offered remotely.

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

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

Tuesday Jan 26th, 9am - 12pm Pacific Time

Microsoft Excel Level 2

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

Tuesday Feb 2nd, 9am - 4:30pm Pacific Time

Online Excel Genius 1: Logic Functions

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

This class covers how to use conditional logic in formulas and functions, allowing you to create formulas that act differently in different circumstances. Topics covered include: IF statements, nested IF statements, AND and OR functions. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC...

Tuesday Jan 26th, 1pm - 3pm Eastern Time

Free

Microsoft Excel Level 3

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Wednesday Feb 3rd, 9am - 4:30pm Pacific Time

Online Excel Genius 6: Creating a Dashboard

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

This class will cover creating multiple Pivot Tables, Pivot Charts, and Slicers, and combining them into one interactive worksheet that we call a Dashboard. Skills required: Know how to navigate menu options in Excel Understand Pivot Tables and Pivot Charts Know how to customize charts Excel Genius is a new set of classes aimed at students who have...

Tuesday Jan 26th, 4pm - 6pm Eastern Time

Free

Online Excel Genius 7: VLOOKUP

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

This class will cover the most popular lookup method in Excel, VLOOKUP, which is used to search for and retrieve information in data sets, and work with the results. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC - 2007 , 2010 , 2013 , 2016 , 2019 Mac - 2016 , 2019 Must...

Wednesday Jan 27th, 4:30pm - 6:30pm Eastern Time

Free

Microsoft Excel 2016 - Level 2 - Online Course

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Students must have MS Office Excel software installed on their computer to participate in class. Overview: Learn how to create advanced...

Wednesday Jan 27th, 6pm - 9pm Mountain Time

  (2 sessions)
$174

2 sessions

Excel PivotTables: Data Summarization and Analysis

This class is temporarily being offered remotely.

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

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

Saturday Jan 30th, 9am - 12pm Pacific Time

Online Excel Genius 2: Conditional Stat Functions

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

This class covers how to take the basic logic from Class 1 and use it to create functions that process data based on conditions. Topics include SUMIF/AVERAGEIF/COUNTIF and SUMIFS/AVERAGEIFS/COUNTIFS. Skills required: Be able to write a basic formula and function Be able to write Relative and Absolute cell references Have Taken Class 1 or understand...

Thursday Jan 28th, 1pm - 3pm Eastern Time

Free

Excel Dashboards for Interactive Reporting - Online

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

Friday Jan 29th, 9am - 4pm Mountain Time

Loading...