all-courses

Course Duration :

45-60 Days 8 Weeks 5 Days

Register For Free Demo





MIS Training Course Fee and Duration

Track Regular Track Weekend Track Fast Track
Course Duration 45 – 60 Days 8 Weekends 5 Days
Hours 2 hours a day 3 hours a day 6+ hours a day
Training Mode Live Classroom Live Classroom Live Classroom
This is an approximate course fee and duration for MIS. Please contact our team for current MIS course fee and duration.

MIS Training Institute in Delhi

The Mis and Vba Macro training will prepare you to make the numerous reports and data analysis for your Management, stake holders, business partners or for anybody who is straightly or indirectly involve in business. Though industry is affecting very fast in field of data and Data Analytics. Mis and Vba Macro is most perilous area in any business for taking the critical decisions to run business.

For preparation of the multiple reports you need to have the strong hand on MS Excel and VBA Macros. The areas which should be really good are, Strong Formula Writing Skills, Strong Data Presentation Skills, Strong Analytic Skills, Strong Interpretation skills by using MS Excel, and you should have the strong Excel VBA Macros Skill also to cure the repetitions, means if you repeat a activity multiple number of time on day to day basis, weekly basis or monthly basis, that can be done by using VBA Macros Skills.

VBA stands for Visual Basic for Applications. It’s a programming language that permits you to control just about everything in Excel. At MCM Infotech you will learn how to generate Macros that can be run from things like: – button on a spreadsheet, the excel Ribbon – in fact, lots of places. Learning VBA Excel will permit you to do a lot more with the software than you can do through the standard spreadsheet view.

Module 1- Basic & Advanced MS Excel 2013 with Dashboard

  • Introduction to Excel, Basic Understanding Menu and Toolbar
  • Lookup, VLookup & HLookup
  • VLookup using Array formula, Dynamic / Reverse VLookup, Index & Match function
  • Advanced Filter and Custom Sorting
  • Create Dynamic Graph & Chart
  • Advanced Filter
  • Advanced Pivot Table
  • Grouping/Ungrouping
  • Combining Data from Multiple Sheets
  • Extract data page wise
  • Use Slicer /Time Line
  • Spark line
  • Preparation of Dashboard
  • Using camera tools for Dashboard
  • Using Interactive Control in Excel Dashboards (Scroll bar, Check Box, Radio Button, Drop Down list, etc)
  • Dashboard using Power BI Tools
  • Data Validation
  • Number & Conditional Formatting
  • Protection
  • Goal Seek, Solver, Scenario, Data Table
  • Logical Functions
  • Financial Functions
  • Create web Query link MS excel with any Website
  • Recorded Macros /Edit Macros
  • Relative Cell References
  • Viewing a Macro Module
  • Executing Macros

Module 2- VBA Programming using MS Excel

  • Introduction to VBA Programming
  • Understanding The VBA Editor
  • Understanding Macro Code
  • Variables and Data Types in VBA
  • VBA Operators and Expressions
  • Conditional Statement if..Then..else
  • Looping Statement / Repeating Actions with a Loop
  • Creating Functions with VBA
  • Arrays
  • Events – driven programming in VBA
  • Excel Object Model (Properties, Methods, Events, Collections Worksheets, Workbooks, Ranges (Cells), Charts)
  • Creating User Form
  • Protect VBA Code
  • Create ADD Ins

Module 3- MS Access 2013

  • Exploring the Microsoft Access Environment
  • Designing a Database
  • Building a Table & Linking Tables (Defining Primary Keys, Linking Tables )
  • Managing Data in a Table
  • Importing and exporting the data
  • Creating and Using Queries (Parameterised Query, Cross tab Query, Find Duplicate)
  • Action Query (Update/Delete/Select/Append Query)
  • Designing a Form
  • Designing a Report
  • Automating tasks with Macros and VBA
  • Setting up an Access Web App
  • Building Basic Web Apps
  • Access Options relating to Multi-user Issues
  • Record Locking

Module 4- SQL (Structured Query Language) using SQL Server

  • SQL Fundamental
  • Creating Tables Using SQL
  • Protecting Data
  • Improving performance
  • Manipulating Data (DML)
  • Controlling Transactions
  • SELECT Statement in SQL
  • From and Where Clause
  • Multiple Tables Query using Joins
  • Combining results
  • Functions in SQL
  • Creating Nested Queries

Register For Free Demo



Enquiry Form
close slider

HURRY Up..!!! be among first 10 students to register get an additional 20% discount on Any IT Courses.

Name
Mobile
Message