Skip to content
Offers IT In-house Corporate Training, Power BI Virtual Training
facebook
TRAINSPIRE IT Training
Call Support (02) 8294-3699; +639171453126
Email Support info@trainspireit.com; transpireinfo@gmail.com
Location 2nd Floor 489 Shaw Boulevard Mandaluyong City
  • Home
  • About Us
  • Course Outline
    • Data Analytics
      • Data Analytics Using Excel
    • Microsoft
      • Advanced Microsoft Excel
      • MS PROJECT 2016
      • MS Excel VBA
      • MS ACCESS 2016 -BASIC
      • MS POWER BI
    • Business Intelligence
      • MS POWER BI TRAINING
    • Web Development
      • Fundamentals Of HTML5 & CSS3
      • JavaScript
      • Building webpage with PHP and MySQL I
      • PHP and MySQL II
  • Public Schedule
  • Gallery
  • Contact Us

MS Excel VBA

Home > Courses > MS Excel VBA

MS Excel VBA

Posted on January 4, 2019February 4, 2019 by admin
0

Course Outline:

Lesson 1: Introduction to VBA

  • Microsoft Visual Basic Fundamentals
  • Microsoft Visual Basic Interface
  • VBA in Visual Basic
  • Macros
  • Writing Codes

Lesson 2: Variables and Data Types

  • Variables
  • Data types
  • Integral Numeric Variables
  • Decimal Variables
  • Any-type Variables
  • The scope or lifetime of a variable
  • The access level of a global variable

Lesson 3: VBA operators and operands

  • VBA operators
  • Arithmetic operators

Lesson 4: The Properties Window

  • The appearance of properties window
  • Types of properties

Lesson 5: Introduction to Forms

  • Forms Fundamentals
  • Using forms
  • The characteristic of a form

Lesson 6: Introduction to Controls

  • Controls Fundamentals
  • Adding a control to a Container
  • Control Selection

Lesson 7: Introduction to Conditions

  • Introduction to Boolean Values
  • Boolean Values and Procedures
  • Boolean Built-in Functions
  • Logical Operators
  • Checking Whether a condition is TRUE /FALSE
  • What ELSE the condition is TRUE/FALSE

Lesson 8: Functional Conditions

  • Alternatives to conditions being TRUE/FALSE
  • Conditional statements and functions
  • If-condition Built-in Functions

Lesson 9: Conditional Selections

  • The Select case statement
  • Managing conditional statements
  • Loop Repeater
  • Loop Counters
  • Exiting a procedure or a loop

Lesson 10: Introduction to built-in Functions

  • Constants, expressions and formulas
  • Fundamentals of Built-in Functions
  • Accessory built-in functions

Lesson 11: Procedures

  • Introduction to Procedures
  • Procedures
  • Introduction to sub-procedures
  • Calling a sub-procedure
  • Procedures and Access levels

Lesson 12: Introduction to Functions

  • Creating a Functions
  • Returning a value from a function

Lesson 13: Arguments and Parameters

  • Passing arguments
  • Techniques of passing arguments

Lesson 14: Strings

  • Introduction to Strings
  • Introduction to Characters
  • Character, Strings and Procedures
  • Characters and String Conversions
  • The Sub-string of a String
  • Other operations on Strings
  • The message box
  • The input box

Lesson 15: Dates and Times in VBA Excel

  • Fundamentals of Dates
  • The Components of a Date
  • Formatting a date value
  • Built-in Time Functions
  • The components of a time value
  • Operations on date and time values

Lesson 16: Error Handling

  • Handling Errors
  • In case of errors
  • Types of Errors
  • The Err Object

Please follow & like us :)

Facebook
Facebook
YouTube
YouTube
LinkedIn

Please follow & like us :)

Facebook
Facebook
YouTube
YouTube
LinkedIn

Trainspire IT Training Services

We offer comprehensive IT corporate training tailored to businesses of all sizes, from small startups to large enterprises, catering to programmers, developers, and other tech professionals. Additionally, we provide training services for individual professionals and technology enthusiasts, empowering them to enhance their skills and master the tech disciplines of their choice.

Contact Information
2nd Floor 489 Shaw Boulevard Mandaluyong City
0917-145-3126
trainspireinfo@gmail.com

Popular IT Training

  • Microsoft Advanced Excel 2016
  • Fundamentals Of HTML5 & CSS3
  • MS Excel VBA
  • Microsoft Power BI
  • Data Analytics Using Excel
  • Microsoft Project 2016
| WordPress Theme: Enlighten by Accesspress Themes