sales@dynamicsedge.com
202-410-6400
SKU: 100011 Categories: ,

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

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.

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 – simple, virtuals

  • simple, virtual 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.

Need help picking the right course?

Give us a call!
408-684-5250 or 
800-453-596 (Toll Free) 

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!

Register Now

Price:

    Print

    Print this product
    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    https://www.dynamicsedge.com/
    sales@dynamicsedge.com
    Solutions
    Company
    202 Church Street S.E. , Suite 203 Leesburg, VA 20175
    202-410-6400
    800-453-596 (Toll Free)
    sales@dynamicsedge.com