0(0)

Introduction to MS Excel VBA

  • by admin
  • Course level: Intermediate
  • Categories Microsoft
  • Total Enrolled 0
  • Last Update August 30, 2020

Description

Excel with VBA training builds you the necessary skills in getting proficiency in of handling repetitive tasks and run in response on occurrence of specific events.

VBA or Visual Basic for Applications training automate activities in Excel such as preparing charts and graphs, generating reports,  doing calculations, etc.  The automation activity also can be referred as Macro that helps users to save time by automation of repetitive steps.

Who Should Attend

Learners who may want to automate repetitive tasks using VBA codes in Microsoft Excel or simplify complex tasks using VBA programming.

Course Duration

3 Days / 24 Hours

Pre-requisites

  • Simple keyboard typing
  • Navigating using the mouse
  • Able to manage files and create folders
  • Knowledge on Microsoft Excel 2013, including writing of Formulas and Functions

What Will I Learn?

  • Understand the Excel object model and VBA concepts
  • Work effectively with the main features of the VBA Editor window
  • Create procedures in VBA
  • Create and use variables
  • Create and work with user-defined functions in VBA
  • Write code to manipulate Excel objects
  • Use a range of common programming techniques
  • Create a custom form complete with an assortment of controls
  • Create code to drive a user form
  • Create procedures that start automatically
  • Write a variety of error handling routines

Topics for this course

72 Lessons

Understanding Excel VBA

Opening and Closing the Editor
Understanding Objects
Viewing the Excel Object Model
Using the Immediate Window
Working With Object Collections
Setting Property Values
Working With Worksheets
Using the Object Browser
Programming With the Object
Browser
Accessing Help
The VBA Editor Screen
Programming in Microsoft Excel00:00:00
VBA Terminology
Displaying the DEVELOPER Tab

Starting With Excel VBA

Procedures

Functions in VBA

Using Excel Objects

Programming UserForms

Automatic Startup

Error Handling

Free

Material Includes

  • Duration: Full-time-3 Days
  • Duration: Part-time-3 Saturdays
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Requirements

  • No coding experience is necessary to take this course!
  • Any computer and OS will work — Windows, macOS or Linux.
  • A basic understanding of HTML and CSS is a plus.

Target Audience

  • Practice your new skills with coding challenges.
  • Organize and structure your code using software.
  • Get friendly and fast support in the course.