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

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

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

Register


Price: $895   Duration: 2 days

- EST

Select Date: