Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge
4.67 out of 50 stars, based on 80 reviews*

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Purchase

Price: $895   Duration: 2 days
- EST
Select Date:
Number of Seats:

Course 100011

Price: $895, Length: 2 days

Excel VBA, Visual Basic for Excel 365 Fundamentals. Versions 2013, 2016, 2019, Office 365, & Online are available.

To customize this class, call 800-453-5961 or click here to contact us

EXCEL VBA – Visual Basic, Fundamentals

Versions 2013, 2016, 2019, Office 365, & Online are also available.

Course Outline

Lesson 1 – Excel Macros

  • Macro Introductions
  • Running Macros
  • Macro Examples

Lesson 2 – Visual Basic Editor

  • Interface
  • Coding Components
  • Debugging and Running Code
  • Optional Topics

Lesson 3 – Cell Manipulation

  • Cell Identification
  • Cell manipulation
  • Column and row Techniques
  • Cell Offse, xlDowns, CurrentRegion, and Address

Lesson 4 – Formatting Techniques

  • Formatting
  • With Statements

Lesson 5 – Variables

  • Variable Structure
  • Global Declarations
  • VB Arrays

Lesson 6 – “IF” Statements

  • If Statements
  • Select Case Statements

Lesson 7 – Message and Input Boxes

  • MsgBox
  • Input Box
  • InputBox Method
  • User Form

Lesson 8 – Loop Control Structures

  • For Loops
  • Do Loops
  • Do While
  • While Wend Loops

Lesson 9- Worksheet and Workbook Manipulation

  • Worksheets
  • Workbooks

Lesson 10 – Functions

  • Excel Functions
  • Call – Calls Another Subroutine
  • Using Excel Formulas in VB Code
  • Run on Open

Lesson 11 – Custom Programming Techniques

  • Custom Function Library

Custom Functions

We look forward to your success!!!

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


100011Excel VBA, Visual Basic for Excel 365 Fundamentals. Versions 2013, 2016, 2019, Office 365, & Online are available.