About Course Introduction  

MIS utilizes data technology, and individuals, business procedures to record, and store process data to produce data that decision-makers can use to settle on everyday decisions.

The best MIS Training Institute in Delhi is the APTRON Delhi. MIS uses the abbreviation for Management Information Systems and In a nutshell and MIS is the collection of frameworks, hardware, and procedures, that all People work together to process and store produce data that is helpful to the association.

Best MIS Training Institute in Delhi

APTRON Delhi is India’s greatest result-oriented MIS Institute in Delhi. Learn every skill to implement MIS Course in Delhi. We have 15+ experience in this Industry. APTRON Delhi is the best MIS Training in Delhi for every professionals and student and100% Record Placement success. Learn MIS Concepts Of MIS Training Course in Delhi and Fast-Track your Career in MIS Services with Practical Hands-on Training, Designed by Industry Professionals to Get the Best Jobs in Top MNCs.

 

Course Content Covered in MIS Training Course

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

© Copyright MIS Training in Delhi:- APTRON Delhi

Contact Me

Office:   APTRON SOLUTIONS DELHI

             Bhikaji Cama Place, Delhi 110066

            Phone: +91-706-527-1000

           Website: http://aptrondelhi.in/