Excel 365 VBA - Expert

Duration
5 Hours, 5 Minutes

 

Delivery Method
Self-Paced

Educate 360 Pro from New Horizons

This class is part of a 12‑month Educate 360 Pro Subscription

Course Overview

This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.

Course Objectives

Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion

Course Prerequisites

There are no prerequisites for this course.

Agenda

1 - Introduction

  • Introduction

2 - Getting Started with VBA

  • Adding the Developer Toolbar
  • Understanding the VBA Editor
  • Recording a Macro in Personal
  • Understanding the Elements of the VBA Language
  • Understanding Methods
  • Understanding Comments
  • Working with the Range Property and Worksheet Object
  • Adding a Macro Button to a Spreadsheet
  • Working with the ActiveCell Object
  • Working with the Offset Property

3 - Working with Variables

  • Understanding Variables
  • Working with Integer Variables
  • Understanding Option Explicit
  • Working with Other Variable Types

4 - Working with Conditional Logic

  • Working with IF Statements
  • Working with ELSE
  • Working with ELSEIF
  • Understanding Conditional Operators
  • Working with NOT, AND, and OR
  • Working with Nested IF
  • Working with Select Case
  • Working with WITH and End WITH

5 - Working with Strings and String Functions

  • Working with Text Strings
  • Working with LCASE and UCASE Functions
  • Working with LEN and TRIM Functions
  • Working with LEFT, RIGHT, and MID Functions

6 - Working with Loops

  • Understanding Loops
  • Working with For Next Loops
  • Working with For Each Loops
  • Working with Cells Property
  • Working with Do Until Loops
  • Working with Do While Loops

7 - Working with Sub Procedures Options and Functions

  • Calling Sub Procedures
  • Working with Exit Sub
  • Working with Message Boxes
  • Working with Input Boxes
  • Working with VBA Functions
  • Working with Object Variable and Set

8 - Working with User Forms

  • Understanding and Creating a User Form
  • Adding Controls to a User Form
  • Adding Code for a User Form
  • Launching a User Form from Excel

9 - Debugging your Code

  • Getting Started with Debugging
  • Stepping Through Your Code
  • Working with Breakpoints
  • Working with the Immediate Window
  • Working with the Locals Window
  • Working with the Err Object

10 - Conclusion

  • Course Recap

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.