VBA with Microsoft Excel

Details

VBA with Microsoft Excel

Duration: 1 day

VBA with Microsoft Excel is a focused, one-day introduction to automating Excel with Visual Basic for Applications. You’ll learn to record and edit macros, understand core programming concepts, and write code that automates the repetitive tasks you do every day.

Learning Objectives

  • Record and run macros
  • Navigate the Visual Basic Editor
  • Understand variables, objects, and basic logic
  • Edit recorded macros to make them flexible
  • Automate common Excel tasks

Who Should Attend

  • Excel users who want to start automating their work
  • Professionals who perform repetitive spreadsheet tasks
  • Anyone curious about programming in Excel

Prerequisites

  • Strong Excel skills (Part 2 or equivalent)
  • No prior programming experience required

What's Included

What’s Included

  • Authorized courseware and student materials
  • Hands-on labs and real-world practice exercises
  • Live instruction from an experienced, certified trainer
  • Small class sizes for personalized attention
  • Attend on campus in Miami or Fort Lauderdale, or live online
  • Certificate of completion

Training Solutions

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Schedule

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
12/8/202512/8/2025
12/29/202512/29/2025
1/19/20261/19/2026
2/9/20262/9/2026
3/2/20263/2/2026
3/23/20263/23/2026
4/13/20264/13/2026
5/4/20265/4/2026
5/25/20265/25/2026
6/15/20266/15/2026
7/6/20267/6/2026
7/27/20267/27/2026
8/17/20268/17/2026
9/7/20269/7/2026
9/28/20269/28/2026
10/19/202610/19/2026
11/9/202611/9/2026
11/30/202611/30/2026
12/21/202612/21/2026
1/11/20271/11/2027

Curriculum

Course Outline

Module 1: Getting Started with Macros

Record macros, run them, and view the generated code.

Module 2: The Visual Basic Editor

Navigate the editor, modules, and the object model.

Module 3: Programming Basics

Work with variables, ranges, and simple loops and conditions.

Module 4: Automating Tasks

Edit and combine macros to automate everyday work.