• Greater Noida, Uttar Pradesh (201306)
  • +91-9999902945, 0956056150
  • plairesoftwares@gmail.com

MIS VBA Course

  • Complete Package

    for 2 Months

  • Complete MIS with Advanced Excel,VBA Macro,Access and SQL

  • Curriculam : 26 Modules
  • Duration: 2 Months
  • 11000/- Rs
  • Register Here

  • Advanced Excel

    for 1 Month

  • Complete Advanced Excel With All Features.

  • Curriculam : 11 Modules
  • Duration: 1 Month
  • 6500/- Rs
  • Register Here

  • MIS And VBA

    for 1 Month

  • Complete Advanced Excel And VBA Fundamentals.

  • Curriculam : 14 Modules
  • Duration: 1 Month
  • 7500/- Rs
  • Register Here

  • Access & Sql

    for 1 Month

  • Complete Advanced Access And SQL Fundamentals.

  • Curriculam : 12 Modules
  • Duration: 1 Month
  • 6500/- Rs
  • Register Here
MIS Training with Advanced Excel, VBA Macro, Access and SQL

Course Description


This course help to the beginners and professional as well to enhance their technical skills to create MIS reports at corporate level.


Module 1&2 Basic and Advanced Excel


 
  • Overview of basic Excel skills
  • Basic Short Keys
  • Worksheet Operations
  • Cell Operation
  • Format Cells
  • Freeze Panes
  • Techniques of Paste Special
  • Protect Worksheets & Workbooks

 
  • Time Saving Utilities
  • Format Painter
  • Text to Columns with fixed and delimited parameters
  • Data Sorting using custom list
  • Summarizing data using Auto Outline

 
  • Concept of Cell Referencing
  • Relative Referencing
  • Absolute Referencing
  • Mixed Referencing

Important Functions in Excel


 
  • AND
  • OR
  • NOT
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • MAX
  • MIN
  • UPPER
  • LOWER
  • PROPER
  • RIGHT
  • LEFT
  • MID
  • POWER
  • SUM
  • SUMIF
  • AVERAGE
  • EXACT
  • CONCATENATE
  • LEN
  • NETWORKDAYS
  • IS FUNCTIONS
  • MATCH
  • IF
  • VLOOKUP
  • HLOOKUP
  • SUBTOTAL
  • SUMPRODUCT
  • NESTED FUNCTIONS

 
  • Name Manager
  • Defining List using names
  • Use of Names in Advance Reports

 
  • Conditional Formatting
  • Conditional Formatting using Formulas & cell values
  • Highlighting Duplicates
  • Calculation based Conditional Formatting

 
  • Data Validation
  • Different Data validation in Excel
  • Using list in validation

 
  • Charts in Excel
  • Elements of Charts
  • Major charts used in Excel

 
  • Pivot Table
  • Pivot Table creating Methods
  • Rearranging a Pivot Table
  • Filtering Pivot Table Data
  • Performing Custom Calculation
  • Creating Dynamic Dashboards using pivot charts and Slicer
  • Consolidating Data from external source or multiple files in less than a minute

Array Functions for quick conditional calculations



 
  • Data Filter
  • Normal Data Filter
  • Advance Filter
  • Calculation based filter
  • Filter using wild cards

 
  • Summarizing data using Subtotal
  • Analyzing data with What-If Analysis
  • Determine unknown with Goal Seek
  • Analyze data with Data Table
  • Sparklines for Data trends
  • Error handling Tips and Tricks

Module 3 Visual Basic Programming & Dashboard Preparation


 
  • Variables, Arrays, Constants, Data Types, Modules, Functions and subroutines
  • Decisions and Looping, Strings and Functions and Message Boxes, Operators, Debugging, Errors and the Error Function, Dialogs, Common Dialog Control, Command Bars and Buttons.
  • Excel Object Model, Object Model--Main Objects, Business tool objects.
  • Charts and Graphs, Working with Databases, API Calls, Class Modules, Pivot Tables, Ribbon
  • Converting Labels to Numbers and Numbers to Labels, Transposing a Range of Cells, Adding Formula Details into Comments, Calculating a Range, Reversing a Label, Who Created the Workbook, Evaluating a Cell, Sorting Worksheets into Alphabetical Order, Replacing Characters in a String, Timed Events, Auto-Totaling a Matrix of Numbers, Absolute and Relative Formulas, Cells Containing Formulas, Alternate Rows and Columns of the Spreadsheet, Changing a Range of Values, Cells by Reference to a Master Cell, Hidden Sheets Without a Password.
  • VBA Automation Programme: Data distribution ,Data consolidate ,Outlook connectivity program ,User from programs ,data base connectivity with access ,Data insert program ,Data fetch program, Workbook Consolidation Programme, Report Automation, Sample of Productivity Report, Sample of Break Schedule & Time Report, Absenteeism , Shrinkage Report, Sample of Sales Dashboard, Sample of KPI Dashboard & many more as per student requirement.

Module 4 MS Access

 
  • Table
  • Query
  • Form
  • Report
  • Primary Key
  • Foreign Key
  • inked tables
  • Relationships
  • Calculated fields
  • Input mask
  • Importing Data
  • Exporting Data
  • Connectivity with Excel to Access
  • Access To Excel
  • Access to Word

Module 5 SQL (Structured Query Language)

 
  • What is SQL
  • Clauses
  • tables
  • views
  • trigger
  • cursor
  • query
  • procedure
  • all join
  • functions(aggregate functions, date & time functions, mathematical functions, string functions etc
  • DDL commands (create, alter, drop, truncate)
  • DML commands (select, insert, update, delete)
  • DCL commands (grant, revoke)
  • DTL commands (commit, rollback)

Copyright © 2013 Plaire Technologies. All rights reserved.