• logo
  • 9762422336
  • 5555545
  • info@mentorit.com.np
header-logo.png

Overview

 

VBA is an abbreviation for Visual Basic Application is a programming language that was developed by Microsoft Corp, it is a human-readable and editable programming code that gets generated when you record a macro. Today, it is widely used with other Microsoft Office applications such as MS-Word, MS-Excel, and MS-Access.

With the use of VBA, the user can automate some aspects of Excel, such as repetitive tasks. Frequent tasks, generating reports, etc., A simple, but powerful programming language that you can use to extend Office applications.

Beyond the power of scripting VBA to accelerate every-day tasks, you can use VBA to add new functionality to Office applications or to prompt and interact with the user of your documents in ways that are specific to your business needs.

VBA has been proved to be extremely useful for Data analysis and used as a mandatory tool by various big industries which shows us the importance of the tool.

Benefits of this course

  •   Chances of promotion in an Existing job
  • Proficiency to automate repetitive tasks
  •  Increase user interactivity
  • Reduce the formula burden used in Excel reports
  • Learn how to enhance the safety of sensitive data.

 

Career Opportunities for those with VBA skills

  • Data Analyst
  • Accountant
  • Information Clek
  • Business Analyst
  • Market Analyst
  • Financial Analyst
  • Auditor


 

Course Content

  • Recording Macros
  • Recording and Running Macros
  • Recording a Macro
  • Running a Macro
  • Adding a Macro/Procedure to the Quick Access Toolbar
  • The Personal Macro Workbook
  • Saving the Personal Macros
  • Editing a Personal Macro
  • Assigning Personal Macros to the Toolbar
  • Introducing Visual Basic for Applications
  • Editing Macros in Visual Basic Editor
  • Understanding the Development Environment
  • Protect/Lock Excel VBA Code
  • Using Help
  • Understanding and Creating Modules
  • Defining Procedures
  • Naming Procedures
  • Creating a Sub-Procedure
  • Working Using the Code Editor
  • Defining Control-Of-Flow structures
  • Using Boolean Expressions
  • Using the IfEnd If Decision Structures
  • Using the Select CaseEnd Select Structure
  • Using the DoLoop Structure
  • Using The ForNext Structure
  • Using the For EachNext Structure
  • Guidelines for Use Of Control-Of-Flow Structures
  • Understanding Errors
  • Using Debugging Tools
  • Identifying the Value of Expressions
  • Setting Breakpoints
  • How to Step Through Code
  • Working with Break Mode during Run Mode
  • Using the Immediate Window
  • Defining Objects
  • Examining the Excel Object Hierarchy
  • Defining Collections
  • Referencing Objects in a Collection
  • Using the Object Browser
  • Working with Properties
  • The With Statement
  • Working With Methods
  • Event Procedures
  • Defining Expressions and Statements
  • Expressions
  • Statements
  • How to Declare Variables
  • Naming Variables
  • Assigning Values To Variables
  • Declaring Variables Explicitly
  • Determining Data Types
  • Programming with Variable Scope
  • Harnessing Intrinsic Functions
  • Defining Constants and Using Intrinsic Constants
  • Using Intrinsic Constants
  • Creating a Function Procedure
  • Calling a UDF
  • Using a function within an Excel Workbook
  • Adding Message Boxes
  • Return Values
  • Notes Error! Bookmark not defined
  • Using Input Boxes
  • How to Declare and Use Object Variables
  • Defining VBA’s Error Trapping Options
  • Capturing Errors with the On Error Statement
  • Determining the Err Object
  • Coding an Error-Handling Routine
  • Using Inline Error Handling
  • Defining UserForms
  • Utilising the Toolbox
  • Using UserForm Properties, Events And Methods
  • Properties
  • Events
  • Understanding Controls
  • Naming Conventions
  • Setting Control Properties in the Properties Window
  • Using the Label Control
  • Using the Text Box Control
  • Using the Command Button Control
  • Using the Combo Box Control
  • Using the Frame Control
  • Using Option Button Controls
  • What is a Range?
  • Range Property of the Application
  • Cells Property
  • The SpecialCells Method
  • Naming Ranges
  • Working with Collections
  • Creating charts from worksheet data
  • Key Properties and methods of the chart object
  • Creating Charts from Arrays
  • Understanding PivotTables
  • Creating A PivotTable
  • Procedure
  • Using the PivotTable Wizard Method
  • Using PivotFields
  • What is an Array
  • Array Sizes
  • One Dimensional Arrays
  • Arrays with Multiple Dimensions
  • A word about index numbers
  • Ubound and Lbound
  • Saving arrays in names
  • Procedure Arguments
  • Passing Arguments
  • Optional Arguments
  • Default Values
  • Passing arguments by value and reference
  • VBA Password Protection
  • About Macro Security
  • Macro security settings and their effects
  • Change Macro Security Settings

About the instructor

DIPU MAHARJAN

BI Solution Architect

Hi I am Dipu Maharjan. I am working as BI Solution Architect. I have experience more than 10 years as Data Analyst, Database Programmer, Developer and Trainer.

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Course Cost18,000
  • Duration50 hrs