Excel Macros Using VBA Level 1
+3

Excel Macros Using VBA Level 1

00040
$325.00
In stock
1
Product Details

Upcoming Classes

8/20/2024 - 9:00am to 4:00pm

WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!

Course Description

The student will learn not only how to capitalize on the macro recording capability within Excel, but also how to understand the VBA code that generates behind-the-scenes in order to then start building your own VBA statements. Common VBA programming code structures such as functions, decision control structures, loops, interactive message and input boxes, debugging and error handling are all a part of this one-day course.

Prerequisite

Excel Advanced and/or equivalent experience

Software Version

Microsoft (Office) 365, 2021, 2019, 2016

Course Highlights

  • Macro recording
  • Choices for running macros
  • Understanding VBA code
  • Visual Basic Editor
  • Editing VBA Code
  • Constants and Variable Declarations
  • Defining a Function
  • Decision Code Structures
  • Loop Structures
  • Interactive Messages
  • Debugging
  • Error handling
Save this product for later
Share by: