Excel with VBA Training Course

  Live Lectures 1-10 
Microsoft Excel is very popular software program included in the Microsoft office suite and used to create spreadsheets documents which is laid out in rows and columns as a big table. Excel has become one of the most used software programs in the business world due to its supreme versatility and power.
·      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

  Live Lectures 11-20 
 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

  Live Lectures 21-31 
 

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.


Lecture-21: Your First Visual Basic Program
Live Lecture 
·      Welcome To Visual Basic

·      A Simple Project

·      Using the Application Wizard

·      Practical Exercise


Lecture-22: Adding Controls to Forms
Live Lecture 
·      Visual Basic Controls

·      Creating and Manipulating New Controls

·      Changing Design Time Control Properties

·      Visual Basic Built‐In Controls

·      Practical Exercise        


Lecture-23: Understanding Events
Live Lecture 
·      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


Lecture-24: Working with Forms and Controls
Live Lecture 
·      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


Lecture-25: Creating and Using Menus
Live Lecture 
·      Menus in Visual Basic

·      Using the Menu Editor

·      Working with Menus

·      Manipulating Menus at Run Time

·      Reusing Menus

·      Creating Popup Menus

·      Practical Exercise


Lecture-26: Compiling and Distributing Applications
Live Lecture 
·      Finishing Touches

·      Project Properties

·      Native Code vs. p‐code

·      Creating Your Executable

·      Using the Package and Deployment Wizard

·      Practical Exercise


Lecture-27: Working with VBA
Live Lecture 
·      Creating a Simple Procedure

·      Variables and Parameters

·      Data Types

·      Using Constants

·      Investigating Built‐In Functions

·      Branching Structures and Looping Structures

·      Practical Exercise


Lecture-28: Handling Errors
Live Lecture 
·      Handling Syntax Errors

·      Handling Run‐Time Errors

·      The Error Handling Standard

·      Taking a Closer Look

·      Who Handles Errors?

·      Practical Exercise        


Lecture-29: Debugging Applications
Live Lecture 
·      Handling Logic Errors

·      Watch Expressions

·      The Call Stack

·      The Debugging Process

·      Practical Exercise        


Lecture-30: VBA Issues, Form and Control Issues
Live Lecture 
·      Scope, Lifetime, and Precedence

·      Passing by Value and by Reference

·      Arrays

·      Optional Arguments

·      Using Multiple Forms

·      List Boxes Revisited

·      Control Arrays

·      Practical Exercise


Lecture-31: Adding Simple Database Support
Live Lecture 
·      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

  Live Lectures 32-38 
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