In the age of information technology, every person should be aware of the latest innovations. Modern programs, languages of programming and so on are constantly appearing. Nearly everybody knows Microsoft office and use it every day. But everybody wants to know how to work with it more efficient and quicker. Do you want to find out how to make your work with MS Office, even more, better? You'll learn it from this course teaches you VBA (Visual Basic for Application) . This programming language will automate your work with MS Office and makes it easier.

Course Contents

After this Visual Basic course will able to customize MS office for your needs. You'll able to:
  • To write your formulas and functions in Excel, output pre-programmed messages etc
  • To record macros
  • To create custom applications in such programs as Outlook, Excel, PowerPoint, and Access
  • It's only a part of the information you'll learn

What this course will cover?

This course will provide you with a lot of information given below:
  • You will be able to understand how to work with Visual Basic
  • You will find out how to record macros
  • You'll learn how to use loops and functions
  • You'll be taught to create code in Visual Basic Editor
  • You'll get information on debugging, and securing your code
  • You will be explained how to make dialogue boxes, input boxes
  • You'll be efficient to XML-based files

Who is this course useful for?

  • If you want to work more effectively and efficiently using programs of packaging in Microsoft office.
  • Individuals working for IT-industry.
  • If you’re a freelancer and want to work efficiently
  • Who want to be aware of the latest programming languages? This is for you!
  • Application developers
  • For people who are in business. The ability to use VBA will meet your business needs
  • People who prefer working in Microsoft Office Products

What are your benefits?

To say that Word, Excel, PowerPoint, Outlook, and Access are very popular programs is to say nothing. Daily Creation of documents and presentations and, of course, everybody use outlook to stay in touch with clients. And in common, it gets a lot of time. Everyone wants to reduce the time spending on working with these programs and optimize your working process. It is important to learn how to use such. And this educational course will help you. The benefits are:
  • VBA programming is easy to learn and simple to use
  • Gets you work done quicker
  • Gives you an opportunity to create your own applications
  • To run database more effectively
  • To improve work with Excel and Word

Module 1: Basic VBA

  • Why we use VBA
  • VBA IDE Details
  • Running/Debugging VBA Code
  • Types of Modules
  • Data Type
  • Variable/Operator
  • Recording Macro

Module 2: Dynamic Range

  • Used Range
  • Use of Excel(xlup/xlRight/xlDown/xlLeft)
  • Current Region
  • Cells / Using Cells with Range
  • Find using VBA Code
  • Apply Filter Using VBA Code
  • Copy Paste/Paste-special
  • Use of Special Cells in Range
  • Use Formulas Like Count-if ,Sum if using VBA Code
  • Techniques to improve the Code execution process

Module 3: Logical Condition

  • Conditional Operators/Logical Operators
  • If -else
  • Texted If else
  • if else if
  • AND
  • OR
  • Select Statement
  • Example/Task Logical Condition
  • VBA built in function (User Name,Trim,Len, Etc)

Module 4: What is Loop

  • Types Of Loop
  • Example of Each Loop
  • Automation for Compiler From (Workbook/Worksheet)
  • Automation for Decompiler(Workbook/Worksheet)
  • Discuss Problem and Requirement
  • Picked a real project

Module 5: Array

  • Declaring Array :
  • Different Types of Array
  • Dynamic Array
  • Array Function
  • Example of Array

Module 6: User Defined Function

  • Private Function
  • Public Function
  • ByVal/ByRef
  • Param Array
  • Call Function in Program
  • Difference between procedure and function
  • How to Call a UDF from excel

Module 7: Error Trapping and Handling

  • On Error Statement
  • On Error Resume Next
  • On Error GoTo
  • On Error GoTo 0:
  • About Err: object and Err Description

Module 8: VBA User Forms & Control

  • Forms Control /Events
  • Lable /Text Box /Combo Box
  • List Box
  • Tab Page
  • Project work: Design a Login Form, Move to the next form and come back to the previous form

Module 9: Connection With Database

  • Types of Database Connection
  • Connection with MS-Access
  • Connection with MS-Excel
  • Connection with MS-SQL Server
  • Query (Select/Update/Delete/Add/Insert)
  • Call a stored procedure from VBA

Module 10: Work on Excel Object

  • Pivot Table
  • Chart
  • Shape Objects

Module 11: Outlook Connection

  • Send a New Mail
  • Send mail With Attachment / Multiple Attachment
  • Send a mail with snap shot
  • Read emails from outlook mail body
  • Download an attachment from mail and save in folder

Module 12: IE Connection

  • Navigate a URL
  • Read data from Internet Explorer (Table,Link etc)
  • Trigger IE Events
  • Filling an IE Form using VBA Code

Module 13: Work With Other Object

  • Work With MS-Word File
  • Work With MS-PPT
  • External Objects

Module 14: Advance VBA Knowledge

  • What is Adding
  • Design a Custom Ribbon

What is VBA?

VBA is a programming language which runs on events. It was introduced by Microsoft in 1993, since then VBA is being used with Microsoft office collections like MS Excel, MS Access & MS Word. You can create a robust tool for by using VBA Programming language.

What are the pre-requisites for this course?

You need to have basic MS Office knowledge to build and make VBA programming on it.

What is live Webinar Classes?

Live webinar class are live virtual class led by expert of particular domain. It is just like class room training. You will be connected through virtual classroom and can clear all your doubts with our Instructor. You can communicate the instructor by using Audio, Video and Chat options.

In case of my absence how can I manage my class?

So you don’t need to worry if you miss your classes. You are responsibility of TechandMate to educate you on the technology you have enrolled. We will generate your learning account (LMS- Learning Management System). In case of missing the class, you will get all the recordings, presentation in your LMS and you can access the same in your leisure time.

Can I access my course module prior to join the class?

No you cannot access course module before enrollment.

Who are the Instructors / Experts / SME?

All our Instructors are experienced and working professional from IT Industry. They have rich experience on the technologies they are leading. Instructors are specially trained by our Learning & Development department to educate and become frontrunner for Live Virtual classes.

Can I see demo or sample class before registering the course?

Yes you can view the demo of class of your course. You can evaluate the teaching style of our SMEs and can further enroll for the course.

Will I get the Software?

Yes we will help you to install the software. We will provide you the link & necessary documents to download the same if it is an open source or demo version available.

Difference between Self Driven and Expert Driven learning?

Our course and training progression is vastly inter. In self-driven learning you will get the access of your LMS with all the modules and learning material available including recording of classes so that you can access it in your leisure time to learn. Expert driven learning would be live streaming webinar and our expert will clear all your doubts instantly. Self-Driven learning is almost 50% cheaper than Expert driven program. You can switch from SDL to EDL any time by paying the difference amount.

How can I access my learning tools?

Once you will enroll yourself for the course training, we will generate a LMS (Learning Management System) for you. All the course modules, learning tools will be available there.

How long I can access my learning tools?

Once you will enroll for the course you can access your learning tools for life time.

Tell me about my payment options?

You can choose any payment option as per your convenience like Credit Card, Debit Card, Net banking. For USD payment, it will be made by PayPal.

Can I convert my amount into EMI’s?

Yes you can convert your amount into EMIs.

What is the process to get the Certification of the course?

After accomplishment of all the modules, you will undergo a Project assessment. After successful submission, our official will review the same & you will be awarded with TechandMate verified Certification for the course.

Will I be working on Project?

Yes you will be working on live project.

What if I have more queries or concerns?

Our technical & Support team is always for your help and available 24x7 for you.

TechandMate certification process

At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work.

Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading.

If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.

Shubham Bardhan
Shubham Bardhan

After wonderful experience with T&M I can truly say this is the best place to learn technologies. Amazing faculties, great technology and vision to educate people. Getting PPTs, Recordings, Lab Assignment has done it all for me. Cheers for TechandMate

Aslam Ansari
Aslam Ansari

T&M folks it was great involvement to experience your training sessions. Doing assignment on real time scenarios added quality in my learning. You are best in the industry.

Ravi Sharma
Ravi Sharma

Came to know about the practical aspect of work, the environment is like any good start up. The benefits may not be much but if you are looking for the skill set development then this place might be for you. Instructors having good amount of experience in their domain, gives the real time examples and teaches how to apply the same in your work. Learning on latest trends with the help of best technology available in the industry. Certainly TechandMate has made it Easy for me.

Jasmine Kaur
Jasmine Kaur

I thought the context was very well organized and well delivered. The overall structure in initial presentation was carried forward in more detailed discussion which made relating all the aspects of BI easier. Sufficient examples and discussions were provided.

Rakesh Chauhan
Rakesh Chauhan

I was in dilemma when I was forecasting to learn Hadoop online. I had real misgivings to learn this way. Learning through live virtual classes and attending the class for consecutive hours looks odd. But it was other way around; I was quite keen and waiting for next weekend to learn more. Instructor paced the course quiet well and never felt bored at all.