Microsoft Excel VBA

ms excel vba

Overview: Visual Basic for Applications is a computer programming language developed to create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports. It helps learners to customize beyond what is normally available and automate specific computer processes and calculations.

  • Prerequisite:
    Students must have strong excel knowledge.
  • Objective:
    Students learn how to create macros and functions to save their time by automating their repetitive tasks
  • Take away:
    On Completion of this course you will be able to automate repetitive tasks by using macros.

Course Details

1
Lesson 1: Developing Macros
  • Create a Macro Using the Macro Recorder
  • Edit a Macro
2
Lesson 2: Introduction to Excel VBA
  • Working with Variables in Excel VBA
  • Using Message box and Input box in Excel VBA
  • Data Variables
3
Lesson 3: Loops and Statements
  • Using If….Then….Else in Excel VBA
  • For……Next Loop
  • Do……Loop
  • Select Case.........End Select
4
Lesson 4: Excel VBA Objects – An Introduction
  • Excel VBA Objects –The Workbook Object
  • Excel VBA Objects –The Worksheet Object
  • Excel VBA Objects –The Range Object
5
Lesson 5: Working with Excel VBA Controls
6
Lesson 6: VBA Procedures –Functions
  • String Handling Functions
  • Date and Time Functions
7
Lesson 7: VBA Procedures -Sub Procedures
8
Lesson 8: Sample Excel VBA Programs
  • Formatting Worksheets Using Macros
  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report
9
Lesson 9: Creating an Interactive Worksheet
  • Determine the Dialog Box Type
  • Capture User Input
10
Lesson 10: Working with Multiple Worksheets
  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets
11
Lesson 11: Performing Calculations
  • Create User-Defined Functions
  • Automate SUM Function

Onetime payment at the time of admission


Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 19 students
Duration: 09 Hours
Lectures: 11
Video: 3

Talk to Our Experts














    Please prove you are human by selecting the Key.