Microsoft Excel Level 4 - Macros & VBA is unfortunately unavailable

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

Microsoft Excel Level 4 - Macros & VBA

at Training Connection - The Loop

(130)
Course Details
Price:
$450
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:
The Loop, Downtown/Loop
230 W Monroe St Ste 610
Btwn S Franklin & Wells Streets
Chicago, Illinois 60606
(Map)
Purchase Options
Save to WishList

8 people saved this class

Book Private Class
Description
Class Level: Advanced
Age Requirements: 14 and older
Average Class Size: 5

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this excel class:

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors.

Prerequisite: Students are expected to have completed Excel Advanced or have the equivalent experience prior to attending this class. Suitable for Excel 2010/2013/2016/365 users.

Course Outline:

VBA Concepts
  • The Object Model Hierarchy
  • Understanding Object Properties, Methods and Events
  • VBA Module and Procedure Types
Accessing VBA Functionality
  • Macro Security Options
  • Using the Macro Recorder
  • Writing and Editing Macros
  • Essential VB Editor Components
  • Exploring the Object Browser
  • Using VBA Comments and Formatting to Write Solid Code
Debugging and Error Handling
  • Types of Programming Errors
  • VBE Debugging Tools
  • Error Handling Code
Using Variables to Store Data
  • VBA Data Types and Naming Rules
  • Declaring Variables
VBA Looping and Decision Structures
  • For...and Do...Loops for Repetitive Actions
  • If..then Statements
  • Select Case Statements
User-Interactive Worksheets
  • Capturing User Input
  • Dialog Box Types
Performing Calculations with VBA
  • Using VBA’s Built-in Functions
  • Writing User-Defined Functions for Custom Calculations
  • Code to Automate Inserting SUM Functions
This outline is a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Refund Policy

Please send all requests to [email protected] .

We are unable to offer refunds for cancellations, however we can issue you a training voucher for the same value that can be used to book any class in the future.

Rescheduling requests made 7 days before the commencement of the training are free. Rescheduling that takes place within 7 days of the commencement of the training will incur a $100 administration fee. We do not charge for student substitutions at any time.

Due to the Coronavirus we are waving the transfer fee when you reschedule your training.

While we make every effort to deliver classes as scheduled, we reserve the right to reschedule previously confirmed classes for a variety of reasons including but not exclusively, the illness of the Trainer. In such cases, we will endeavor to inform the Client as soon as possible of the new training dates. We are not liable for any additional expenses incurred as a result of rescheduling training.

We are not able to offer refunds or training vouchers for no-shows or uncompleted courses.

Map

Google Map

Training Connection

All classes at this location

Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.

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 4500 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 Training Connection (130)

(130 Reviews)
Microsoft Excel Level 4 - Macros & VBA
Reviewed by Adriene W. on 8/19/2019
This course gave a great introduction to VBA and Macros. The instructor gave good examples and was able to help you learn how to fix your own errors. I would recommend this and all the other Microsoft Excel courses in this group to my peers.
Microsoft Excel Level 4 - Macros & VBA
Reviewed by Ashley Allison V. on 11/19/2018
Great class, really learned a lot and Rich the instrutor was awesome. Enjoyed the small class size as it allowed for a lot of one-on-one help. Would highly recommend.
loading...

School: Training Connection

Training Connection

Training Connection LLC is a computer and business skills training company.  

Our Training Philosophy

Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:

1. Our Instructors

Without a doubt our most...

Read more about Training Connection

CourseHorse Approved

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

Want to take this class?

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

85 Top Choices

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

Saturday Oct 3rd, 10am - 2pm Eastern Time

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 Sep 30th, 6:30pm - 9:30pm Eastern Time

Excel for Mac Level 1

This class is temporarily being offered remotely.

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

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. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets...

Tuesday Sep 22nd, 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 Sep 23rd, 10am - 5pm Eastern Time

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

Thursday Oct 1st, 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...

Monday Nov 9th, 10am - 6pm Eastern Time

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

Tuesday Nov 10th, 10am - 6pm 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....

Tuesday Oct 20th, 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 Sep 24th, 11am - 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...

Thursday Sep 24th, 8am - 2pm Pacific Time

Excel Dashboard Reporting: Intro to Dashboards ..

This class is temporarily being offered remotely.

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

A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and troubleshooting skills. The last thirty minutes of the class...

Saturday Sep 19th, 9am - 4pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

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

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Tuesday Oct 20th, 11am - 5pm 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...

Tuesday Oct 6th, 9am - 4pm Pacific Time

  (2 sessions)
$895

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 Oct 10th, 9am - 12pm Pacific Time

Excel Power User

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

This two-day class offers the "best of" topics from our series of Excel classes: - Excel Introduction (just tips and short-cuts from this class) - Excel Charts Formatting and Reporting - Excel Database Features and Pivot Tables - Excel Workbooks, Formulas and Functions - Excel Macros (Supplemental Hand-out) This jam-packed, fast-paced class...

Wednesday Sep 23rd, 10am - 4:45pm Eastern Time

  (2 sessions)
$795

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 Oct 12th, 9am - 4:30pm 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 Oct 13th, 9am - 4:30pm Pacific Time

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 Oct 14th, 9am - 4:30pm Pacific Time

Excel 2016: Basic

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

Designed for people who "learned on the job" as well as those who have never used spreadsheet programs before, this course teaches functions and features of Excel 2016. After an introduction to spreadsheet terminology, you will learn how to navigate worksheets, enter and edit text, values, and formulas. You will learn about absolute and relative references,...

Wednesday Sep 23rd, 6:15pm - 8:35pm Eastern Time

  (3 sessions)
$265

3 sessions