Download appDownload App

Excel with VBA Training Course

During this course, you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project-based Excel Macro/VBA exercises, detailed t...

  • All levels
  • English

Course Description

During this course, you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project-based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within...

During this course, you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project-based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks. Excel with VBA training imparts the skills to build proficiency in coming up with solutions for handling repetitive tasks and run in response on the occurrence of specific events. VBA stands for Visual Basic for Applications an event-driven programming language from Microsoft that is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word, and MS-Access.VBA means Visual Basic for Applications.

What you’ll learn
  • Live Class Practical Oriented Training
  • Timely Doubt Resolution
  • Dedicated Student Success Mentor
  • Certification & Job Assistance
  • Free Access to Workshop & Webinar
  • No Cost EMI Option
  • Build a solid understanding on the basics of Microsoft Excel. Writing formulas and performing calculations
  • Cells, Ranges, Tables, Worksheet operations: Navigate the spreadsheet & begin to change the way cells, ranges, & tables...
  • Easily and quickly produce a summary of key statistics for any given data set through Excel functions.
  • Summarizing in Excel using Pivot Tables: Quickly summaries, analyse, and sort your data with easy-to-use pivot tables.
  • Introduction to Excel worksheets, workbooks, and toolbar: Learn the basics of Excel and how to navigate a spreadsheet.
  • Become an advanced Excel wizard by writing your own programmed tasks directly in Excel to automate complicated tasks.
  • What-If Analysis: Explore a variety of different results by comparing two sets of data within the spreadsheet.
  • Keep others from changing the cells in your worksheet through data protection and validation.

Covering Topics

1
MS Excel - Advance
2
MS Excel – Macros
3
MS Visual Basic for Applications (VBA)
4
Microsoft Access

Curriculum

      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

Frequently Asked Questions

Basic Computer Knowledge.

: The course offers a variety of online training options, including: • Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. • 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. • Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. • Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.

Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.

If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.

The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.