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

Course 100011

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


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

Visual Basic for Excel 365 Fundamentals - Excel VBA

Visual Basic for Excel 365 Fundamentals – Excel VBA

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

Are you facing a repetitive clean-up of fifty tables in Excel? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?

You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.

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 for Excel VBA

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

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Visual Basic for Excel 365 Fundamentals – Excel VBA.

Additional information

dates

05/03/2021 (Live Virtual) $895, 06/07/2021 (Live Virtual) $895, 07/12/2021 (Live Virtual) $895, 08/09/2021 (Live Virtual) $895, 09/06/2021 (Live Virtual) $895, 10/04/2021 (Live Virtual) $895, 11/08/2021 (Live Virtual) $895, 12/13/2021 (Live Virtual) $895

Train Your Team

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 - Choose Date


$895.00

Clear
Number of Seats: