Excel VBA Training

Course Name : VBA Excel
Duration : 20 Hours

Excel is one of the most popular software applications in the world and is used by firms in almost every industry, from pizza parlors to private equity. Companies, educational institutions, and government agencies all use Excel to manage and analyze data, create spreadsheets and reports, print charts, and much more. It’s no wonder why a working knowledge of this spreadsheet software is an essential skill for people who spend part of their workday in front of a computer, even for those that do not necessarily have an accounting or finance-related careers. Thus Excel skills are in demand, and its no surprise people with Excel knowledge are earning more money than their counterparts.

Target Audience

  • Undergraduate, Graduates and Post-Graduates
  • Job aspirants

Pre-requisites

  • Basic Computer
  • Basic Internet
  • Advanced Excel

Recommended Next Course

  • Commercial Accountant
  • Digital Marketing

Complete Course Contents

Module 1: Understanding Security Levels
Why security
Security levels and its meaning
Module 2: Functions
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook
Module 3: Recording Macros
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu
Module 4: The Visual Basic Editor
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code
Module 5: Programming Fundamentals
Variables, data types and constants
Arrays
Object Variables
Conditional structures (If …. Then, Select Case)
Logical Operators
Looping constructs (For loops, Do loops, while… Wend)
Built-in functions
Creating Subroutines
Module 6: Excel Object Model
Working with objects – properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects
Module 7: User Forms
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins
Module 8: Working with other applications
Working Word, PowerPoint and other applications.

Why SAMYAK ?

1. Registered LLC Company in Florida, USA
2. An ISO Certified Company
3. Corporate Division, Working on International Level Projects
4. HP Software University Partner
5. RKCL's (Rajasthan Govt) Training Partner
6. Govt. Approved Courses Provider
7. Authorized Microsoft Testing Centre
8. Authorized AutoDesk Testing Centre
9. Authorized Adobe Testing Centre
10. 10 Branches & Growing ...
11. Most Preferred Vendor working on Projects

Live Projects Based Professional Training

1. Samyak believes in employability and hence Samyak provides training with less theory and more of Practicals.

2. Samyak has 150+ Computers, Switches, Routers, PLCs, Hardware and supporting Software AND has enormous in-house projects to support the project based studies.

3. Students of Samyak get opportunity to avail internship and placements in and at partner companies of Samyak (in and out of India).

4. Samyak students have exclusive portal for placement, where companies exclusively request the quality students from SAMYAK only.

5. Being in multiple locations across the Globe, Samyak allows students to take transfer in needed circumstances.

6. Check student's reviews online at Justdial, Sulekha, Facebook, Google Pages etc.

7. Samyak is the fastest growing company in education / training domain, and provides all solutions through cutting edge technologies.

I want to meet SAMYAK Counselor & Faculty