Excel with VBA Training Course

·      Data Formatting & Custom settings

·      Conditional Formatting

·      Filters, Queries & Data Sorting

·      Formula Writing & Fixing Errors

·      If‐Then‐Else & Nested If commands

·      Vlookup / Hlookup

·      Graphs & Charts

·      Hyper / Data Linking

·      Grouping ‐ Ungrouping

·      Pivot Tables

·      Macros Recording, use, editing, linking:

·      Security & Protection

·      Data Validation

·      Practical Exercise        

 VBA Excel Training at BIT aims to impart basic skills in using Excel to its best. Participants will learn to use statistical, math, and logical functions, organize data using filter and sort and effectively present data for quick decision making using charts and graphs.  Participants will also gain some advanced skills in Excel, such as using VLOOKUP, PivotTables, and Macros among others.

·      Creating & Recording Macro

·      Executing Macros through shortcuts & command buttons

·      Editing recorded syntax

·      Modules

·      Procedures

·      Sub Procedures

·      Functions

·      Objects and collections

·      Workbook and workbook objects

·      Range object & cells property

·      Methods & properties

·      Object variables and arguments

·      If Case, Loop Case & Select Case

·      Practical Exercise

VBA means Visual Basic for Applications. It's a program design language that permits us to regulate just about the whole thing in Excel. Learning on how to make Macros that can be run from things like a button on a spreadsheet, the Excel Ribbon - in fact, lots of places. Knowledge Excel VBA will allow us to do a lot more with the software than we can view via the standard spreadsheet. Course Objectives: If we are executing repetitive actions on workbooks or sheets, it may be probable to systematize that work. Introducing data, cleaning that data, archiving current information and similar activities are decent applicants for computerization in Excel. VBA offers extra options for developers viewing to automate Excel.

·      Welcome To Visual Basic

·      A Simple Project

·      Using the Application Wizard

·      Practical Exercise

·      Visual Basic Controls

·      Creating and Manipulating New Controls

·      Changing Design Time Control Properties

·      Visual Basic Built‐In Controls

·      Practical Exercise        

·      Introducing Events

·      Event Procedures

·      The Form Load Event

·      The Form Resize Event

·      Command Button Click Event

·      Text Box Change Event

·      The Timer Control's Timer Event

·      GotFocus / LostFocus Events

·      Practical Exercise

·      Setting Properties at Run Time

·      Setting Form and Control Properties

·      Using ActiveX Controls

·      Adding ActiveX Controls to a Project

·      Using the Monthview ActiveX Control

·      Extra ActiveX Samples

·      Practical Exercise

·      Menus in Visual Basic

·      Using the Menu Editor

·      Working with Menus

·      Manipulating Menus at Run Time

·      Reusing Menus

·      Creating Popup Menus

·      Practical Exercise

·      Finishing Touches

·      Project Properties

·      Native Code vs. p‐code

·      Creating Your Executable

·      Using the Package and Deployment Wizard

·      Practical Exercise

·      Creating a Simple Procedure

·      Variables and Parameters

·      Data Types

·      Using Constants

·      Investigating Built‐In Functions

·      Branching Structures and Looping Structures

·      Practical Exercise

·      Handling Syntax Errors

·      Handling Run‐Time Errors

·      The Error Handling Standard

·      Taking a Closer Look

·      Who Handles Errors?

·      Practical Exercise        

·      Handling Logic Errors

·      Watch Expressions

·      The Call Stack

·      The Debugging Process

·      Practical Exercise        

·      Scope, Lifetime, and Precedence

·      Passing by Value and by Reference

·      Arrays

·      Optional Arguments

·      Using Multiple Forms

·      List Boxes Revisited

·      Control Arrays

·      Practical Exercise

·      Support for Data Access in Visual Basic 6.0

·      Using the ADO Data Control

·      Binding Controls to Data

·      Writing Code for the Data Control

·      Practical Exercise

This VBA for Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

·      Encrypting a Database

·      Using the Access 2010 Runtime Program

·      Packaging a Database

·      Synchronizing a Database with a SharePoint List

·      Importing Data from and Exporting Data to SharePoint Lists

·      Sharing a Database

·      Practical Exercise