Discover Classes. Earn Rewards.
Excel : VBA Programming is unfortunately unavailable

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

Excel : VBA Programming

at Certstaffix Training - Near North Side

(114)
Course Details
Price:
$995
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:
Near North Side, Downtown/Loop
500 N Michigan Ave Ste 600
At N Michigan Ave
Chicago, Illinois 60611
(Map)
Share:
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 3

What you'll learn in this excel class:

This Excel VBA course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC) 
Course Taught With: Excel version 2013 (Microsoft Windows PC) Software and Courseware

Course Lessons:

Proficient knowledge of Microsoft Excel. 
Knowledge of PivotTables helpful but not required.
Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
School Notes:
Important:
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.


The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.

Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.

Still have questions? Ask the community.

Refund Policy
You can cancel or reschedule your registration without penalty or charge provided you give notice of 10 business days (M-F) or more days before the start of my class.

If you request to cancel or reschedule your registration 10 Business Days (M-F) or less days before the class start you will be charged 100% the course fee and will not be entitled to a refund. You have one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

You cannot change your class location ten (10) Business days (M-F) or less before the class start because Certified Staffing Solutions has shipped training materials and provisioned resources. Location changes requested prior to that timeframe are subject to availability and may incur an additional charge.

Should Certified Staffing Solutions need to cancel your class due to insufficient enrollment, or postpone it due to events beyond their control, Certified Staffing Solutions will notify you as soon as possible. In such cases, you may reschedule to a future class date at no additional charge or receive a refund for any money on account relating to that registration.

Travel arrangements and costs are the sole responsibility of the student. Certified Staffing Solutions suggests obtaining refundable reservations. Certified Staffing Solutions classes are confirmed approximately 14 days before the start of the class. We cannot guarantee class commitments before that window of time. Certified Staffing Solutions will not be responsible for any cancellation costs incurred, including but not limited to, airline/mass transit tickets, hotel reservations and so on.

Map

Google Map

Certstaffix Training

All classes at this location

Our downtown Chicago classroom is located at the Avenue Business Center in the Magnificent Mile district, close to plenty of restaurants and parking. When arriving for class, please proceed to Suite 600 and the receptionist will guide you to your classroom.

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 9950 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 Certstaffix Training (22)

School: Certstaffix Training

Certstaffix Training

Certified Staffing Solutions specializes in providing computer training and instructors nationwide. Our instructors are professional trainers and utilize hands-on exercises to reinforce lecture. Each averages more than 5 years delivering classes to business professionals.

Our Advantages

  • Our Instructors:...

Read more about Certstaffix Training

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
Taking this class for work? Get exclusive perks & discounts for free.

35 Top Choices

Excel Introduction

at Computer Training Source, Inc. - Schaumburg 1821 Walden Office Sq Ste 400, Schaumburg, Illinois 60173

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Thursday Sep 19th, 9am - 4pm

Mastering Excel – Advanced

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Thursday Sep 26th, 9am - 12:30pm

$299.99

Excel 2007/2010/2013 Intermediate

at Computer Training Source, Inc. - Schaumburg 1821 Walden Office Sq Ste 400, Schaumburg, Illinois 60173

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Course Outline Unit 1: Using multiple worksheets and workbooks Topic A: Using multiple workbooks Topic B: Linking worksheets with 3-D formulas Topic C: Linking workbooks Topic D: Managing workbooks Unit 2: Advanced formatting ...

Friday Sep 20th, 9am - 4pm

Introduction to Excel - Learn Basics

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Friday Sep 20th, 9:15am - 1pm

$184.98

Microsoft Excel Level 4 - Macros & VBA

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

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

Thursday Oct 10th, 9am - 4:30pm

Excel BI Tools: Power BI for Excel Users

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service. Audience profile: The course is individuals who are not IT professionals but need to easily create and publish reports...

Monday Sep 23rd, 9am - 3:45pm

  (2 sessions)
$795

2 sessions

Excel 2007/2010/2013 Advanced

at Computer Training Source, Inc. - Naperville 2135 City Gate Ln Ste 300, Naperville, Illinois 60563

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Wednesday Sep 18th, 9am - 4pm

Excel Introduction (365/2019/2016)

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks. Who Should Attend: This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets. Prerequisite: Basic Windows, keyboarding and mouse skills. Course Outline: Getting Started Entering Data...

Wednesday Sep 25th, 9am - 3:45pm

Excel 2013 Advanced

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions.  This...

Wednesday Sep 25th, 9am - 3:45pm

Excel Tips, Tricks and Timesavers

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Target Student: You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might...

Thursday Sep 26th, 9am - 3:45pm

VBA Excel - Introduction to Macros & VBA

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

Thursday Sep 26th, 1pm - 4pm

$299.99

Excel Macros

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment,...

Friday Sep 27th, 9am - 3:45pm

Excel 2013 Introduction

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

In today's work environment, proficiency with spreadsheets is expected. In this course, you will work with Microsoft® Office Excel® 2013 create a new spreadsheet. You will learn to enter data in the most efficient way. You will create formulas to summarize and analyze data and learn the proper technique to copy and paste formulas. You will also...

Friday Sep 27th, 9am - 3:45pm

Excel Database Features & PivotTables (365/2019/2016)

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment,...

Thursday Oct 3rd, 9am - 3:45pm

Excel Workbooks, Formulas and Functions (365/2019/2016)

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks ...

Friday Sep 27th, 9am - 3:45pm

Mastering Excel - Intermediate

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Friday Sep 20th, 1:30pm - 4:30pm

$184.99

Excel at Excel: Getting Down to the Basics

at General Assembly - Near North Side 444 N Wabash Ave 5th Fl, Illinois City, Illinois 60611

For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to the next level and become a “power” user. We’ll start with the absolute...

Thursday Oct 3rd, 6pm - 8pm

Microsoft Excel

at Discovery Center - Irving Park 4318 N Elston Ave 2nd Fl, Chicago, Illinois 60641

You can't get a job today without Excel. This class will show you the basics of working with spreadsheets using Excel. First we'll get comfortable in the Excel workspace, then we'll cover the basics: entering numbers and text, formatting, and performing basic calculations. Then we'll look at sorting data, creating charts, and more advanced use of formulas. ...

Thursday Oct 3rd, 6:30pm - 9:30pm

  (2 sessions)
$125

2 sessions

Excel Level 2

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to:  Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...

Friday Oct 4th, 9am - 4pm

Excel Charts, Formatting and Reporting (365/2019/2016)

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

Learn the essentials regarding visualizations in Excel. Create charts, use styles and templates, manage advanced worksheet formatting. Target Student This course is for individuals whose job responsibilities include publishing spreadsheet results and need to create visualizations and manage formatting and advanced reports. Prerequisites Excel...

Monday Oct 7th, 9am - 3:45pm

Loading...