Advance Excel & MIS Training with VBA Macros

Part : -1 5 Hours

All Excel option & Command

Part : - 2 3 Hours

Data Analyzing & Chart

Part : - 3 1.5 Hours

Protection Method

Part : - 4 10 Hours

Formulas

Add-in and automation functions Cube

Database and list management Date and time

Engineering Financial

Information Logical

Lookup and reference Math and trigonometry

Statistical Text and data

Array Formulas

Formulas Nesting

Create Formulas

Part : 5 5 Hours

MIS Reporting

Method of : -

Monthly , Weekly , Daily Quarterly Report

Variance Report

Compare Report

Sales Report

Sales Report Analyzing

Part : - 6 Excel VBA Marcos 25 Hours

VBA For Excel - Level 1

The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties

Excel Objects - Workbook Included, Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars

Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants

Loops, Types of Loops, Loop Pitfalls

Effective Decision Making, If/And/or, Select Case, Dates and Times

Workbook and Worksheet Events

Debugging and Error Handling, Prevention, Good Habits, Runtime Errors

Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features

User Defined Functions, Good vs Bad, Arguments, Calculation

Controls, ActiveX, Control Toolbox, Control Properties, Control Parents

VBA For Excel - Level 2

UserForms Introduction

Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops

Multi-Page Control, Creating a wizard using the Multi-Page Control

Validating the User Inputs, Some Useful Methods and Functions

When to apply Validation, Control Events

Which Controls to use and When

Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls

Option Buttons and Checkboxes in Detail, True or False

Creating Template Controls, Using the RefEdit Control

Finding the Active Control, Creating Controls at Runtime

Part : - 6 5 Hours

Report Auto Mation

Advance Excel & MIS Training Institute

Online Advance Excel & MIS Training Program Live Training with Excel VBA and MIS. Training Features: - VBA Macros , MIS Reporting, Advance Formulas, Array Formula, Custom Formatting and Report Automation etc.