+91 8130 80 2001

+91 9267 97 4043

Placement

Join Now

The next level of your career starts here.







Estimated Time
2 Months

Pre REQUISITES
Students, Fresher's
Working Professional

Training Mode
Offline, Online

Full Fees
₹ 8,000/-₹ 10,000/-
You Save - ₹ 2,000/-

What you will learn

VBA Macros for Report Automation

Our VBA developer Program is designed by the industry experts. These skills fulfil the requirements of jobs related to automate various activities in Excel like generating reports, preparing charts & graphs, doing calculations.

Curriculum

Our leading edge curriculum covers fundamentals and more complex data and analytics concepts.

VBA Macros

In this course you'll learn how to create your own macros, automate and simplify multiple tasks in Excel so that you can bring your Excel skills to the next level, and put yourself ahead of the competition.

  • Learn to program in VBA from scratch
  • Understand coding, and the thought process behind it
  • Learn how to automate daily routine tasks within Excel
  • Learn VBA Programming concepts to create dynamic, re-usable code
  • Learn how to write custom VBA Macros to create more robust automation
  • Fully automate Excel using Visual Basic for Applications
  • Create emails and send them automatically
  • Quick Recap of Microsoft Excel
  • Introduction to Developer Ribbon Tab
  • Introduction to VBA
  • What is VBA / Macro in Excel?
  • Introduction to Visual Basic Editor Window
  • Getting Familiar with Visual Basic Editor (VBE)
  • Customizing the VBE Environment
  • The Macro Recorder
  • Executing / Modifying Recorded Macros
  • Saving Macro Workbook
  • Introduction to Sub and Function Procedures
  • Introducing the Excel VBA Object Model (A must-know thing to become a Pro in VBA)
  • Properties and Methods
  • Important and Useful Properties of Application Object
  • Working with Ranges Objects
  • Working with Comments
  • Variable, Data Types, and Constant
  • Finding the Last or Next available Row/Column
  • Selecting Rows/Columns/Table (Normally & Dynamically)
  • Introduction to VBA Loops & Conditional Statements
  • Working with Conditional Statements
  • Working with Loops
  • Working with Message & Inbox Box
  • With-End with Constructs
  • Controlling Program Flow
  • Introduction to Arrays
  • Introduction to Excel VBA Functions and Worksheet Functions
  • Difference between R1C1 and A1 style referencing
  • Difference between Worksheet Functions Vs Active.cell Formula
  • Getting started with VBA Excel Functions
  • Getting started with WorksheetFunction
  • Working with Function Procedures
  • Getting started with User Defined Functions (UDF)
  • Fixing arguments of Formulas in VBA
  • Working and Creating Customize Functions
  • Error Handling & Debugging Techniques
  • User Form Introduction
  • Exploring Form Controls & ActiveX Controls
  • Exploring UserForm Controls
  • Cycle/Sequence to follow to create UserForm
  • Validating User Inputs
  • Testing a UserForm
  • User Form Tricks
  • Understanding User Form Events
  • Working with Pivot Tables
  • Charts
  • Sorting & Filtering
  • Add-Inns
  • Type of different Excel events
  • Starting an application from Excel
  • Interacting with Microsoft Office Apps
  • Controlling Excel from another application
  • Sending Personalized emails via Outlook
  • Sending e-mail attachments from Excel
  • Working with Files & Folders
  • Converting / Saving Excel Files into PDF

2 Months

Video Recording

Live Session with industry experts

100% Placement Assistance

Career Scope

  • MIS Executive
  • MIS Analyst
  • Data Analyst
  • Business Analyst
  • Sales Planning
  • Sales Analyst
  • Finance Analyst
  • Market Research Analyst
  • Sales/Project Coordinator
  • Operation Executive
  • Process Associate & Etc...

All Our Programs Include

Instructor-led

Live interactive and classroom training will include the practical approach and assessments on regular basis.

Live Case Study

Case study using industry specific data helps you to get hands on with a good exposure.

Lifetime Placement Assistance

Lifetime Placement Assistance

24 X 7 Support

We will support If any concern is raised related to the training, assignments, projects, case studies & interview questions.

Download Syllabus

The next level of your career starts here.