MIS Training

MIS & Data Analysis Training

Get Price Quote

Needless to say, MIS (Management Information System) is considered very crucial when it comes to managing the business. Right from handling purchased & sold goods data to hiring the employees, everything would be incomplete impossible without MIS. In short, it can be said that if you are a trained MIS professional then it would be easy for you to understand what your business requires and what’s business strength is. Because of the multiple benefits of MIS, people are looking forward to getting enrolled in MIS & Data analysis training. If you are also looking for training institute then consider Prowess Groups for its effective training and detailed course modules. For increasing your database handling skill, you can get enrolled in the Excel course, Advanced Excel course, VBA|Macros, MS-Access SQL and SQL training course. The best part of this training is that candidates will get quality training to shape out their career.

mis training service

Get Price Quote

Management information systems (MIS) is about the study of people, technology, and organization. MIS analysts improve the flow of information within an organization through technology. They apply strong analytical skills, intuitive thinking, and digital expertise to carefully examine how people in an organization use data and technological tools. After performing their research, MIS analysts create strategies for information to be shared in a more effective way. MIS analysts anticipate information requirements, evaluate business processes, and uncover areas for improving information sharing MIS Training iServ Academy have expertise to delivery MIS training where training is imparted by leading MIS developers from MNCs professional . MIS Analyst course will not only help learners to stand out while polish their existing skillset in this domain, but it will also help them take that necessary leap to bigger and more ambitious roles. Students will be able to learn expert level i.e., Excel and Advance Excel, VBA, MS Access, MS SQL, Power BI. We have trained a number of students in MIS domain successfully, subsequently and students are working with top class companies across India.

Mis Practical Trainig in Delhi

Get Price Quote

MODULE 1. BASIC AND ADVANCED EXCEL What is excel? Workbook, Worksheet, Range, Cell, tab, ribbon, quick access, cell formatting, custom formatting, columns, rows Cell referencing (Relative, Absolute, Mixed), Paste special, Go to special, Table, Print Title & Print Area, Wild Card * and, ï�¶ Basic and Advanced Function ï�¼ Sum, product, Sumproduct, average, max, min, large, small, count, counta, countblank, upper, lower, proper, left, right, mid, len, find, search, randbetween, replace, substitute, abs, concatenate etc. Ï�¶ Logical Function ï�¼ If, Nestedif, and, or, iferror, , countifs, sumifs, iserror, isnumber, istext etc. Ï�¶ Lookkup Function ï�¼ Vlookukp, Hlookup, 2dVlookup, 2dHlookup, Index, Match, Reverselookup, Indrect, Offset etc. Ï�¶ Date Function ï�¼ Date, Day, Month, Year, Edate, EOmonth, Day360, Networkdays, datedif, weekdays, workdays etc. Ï�¶ Data Summarization ï�¼ Pivotable , Data Sorting, Custom Sorting, Filter and Advanced Filter, Text to Column, Remove Duplicated, Group, Ungroup and Subtotal Split and Freeze Panes. Ï�¶ What if Analysis ï�¼ Scenario Manager, Data Table, Goal Seek ï�¶ Data Validation ï�¼ Input Message, Error Alert, Circle Invalid Data, Clear Validation Circle ï�¶ Conditional Formatting ï�¼ New Rules, Clear Rule and Manage Rule ï�¶ Charts ï�¼ Column, Line, Pie, Dougnut etc ï�¶ How to make Excel Dashboard ï�¼ Dashboard Using Pivotable, Slicer, Timeline, From Controls, ChartsHow to Prepare MIS Report ï�¼` IIASM Consultants 10 A, 1ST Floor, Veer Savarkar Block, Sikka M K House, Shakarpur, Near Nirman Vihar Metro Station Gate No-2, Delhi-110092 Phone no: 9212189653 Website: www.iiasmconsultants.com Daily, Weekly and Monthly Bases Reports What is Macro? Types of Macro Relative and Absolute macro. Additional Benefit Mail Merge, Table of Content, Speaking text, Date picker content control What will you get with this course? Assignment, Shortcut commands excel, E-book of Excel and Videos. MODULE 2. VBA ï�¼ Introduction of VBA, Programming in Excel VBA, Macro in VBA Basic, Visual Basic Editor, Project Explore, Immediate Window. Ï�¼ How to write programs in VBA, How to think program in VBA, How to create logic etc. Ï�¼ How to Run program, how to debug program, where apply break points. Ï�¼ Variable, Constants, Array and Data type. Implicit declaration and Explicit declaration. Ï�¼ What is Module? , Procedure, Difference between Function and Subroutine. Scope of Function. Ï�¼ Program`ming Basics: Decisions and Looping ï�¼ For-Next, For-Each, while, do while, until, do until. Ï�¼ Condition and Statement ï�¼ If, Nested-if, Cases, And, Or ï�¼ Strings and Functions and Message Boxes and Input Boxes ï�¼ Errors and the Error Function ï�¼ What is operator and types of operator? ï�¼ The Excel Object Model, Properties and Methods Explained ï�¼ Using Excel to Interact with Other Office Programs and Selecting the Microsoft Word Object Library. Ï�¼ Selecting the Object Library file for Microsoft Outlook, Selecting the Excel Library file ï�¼ Working with Databases, ODBC Link, Using ADO ï�¼ Class Modules, Inserting a Class Module, Creating an Object ï�¼ Outlook Connectivity with VBA ï�¼ How send the mail from outlook to multiple id with VBA ï�¼ Access connectivity with VBA ï�¼ Data fetch, data save, data fetch with query from the Access. Ï�¼ UserForm control. Ï�¼ Access Connectivity with UserForm What will you get with is course Assignment and E-book of Excel. MODULE 3 ACCESS Introduction to Microsoft Access Concept of MS Access How to Start Access Quick Access Toolbar` IIASM Consultants 10 A, 1ST Floor, Veer Savarkar Block, Sikka M K House, Shakarpur, Near Nirman Vihar Metro Station Gate No-2, Delhi-110092 Phone no: 9212189653 Website: www.iiasmconsultants.com Type of Data Type Text Long Number Date & time Currency Auto number Yesno Hyperlink Attachment Calculated Lookup wizard Creating Database and Tables Working with fields and records a. Modify Table b. Find and Replace c. Sorting and filter General Properties Field size Format Input Mask Caption Default Value Validation rule Validation text Required Allow zero length Index Lookup Text Box Combo Box List Box Relational Database Techniques ï�� Types of Relationship 1. One to one 2. One to many 3. Many to many Referential Integrity Cast Cade Update Cast Cade Delete Joins Working with Queries Select Query Make Table Append Query Update Query Cross tab Query Delete Query Working with Forms a. Overview b. Form Wizard c. From Scratch d. Form design e. Sub Forms f. Form Commands g. Sorting and filter h. Switch-board Working with Reports a. Report Wizard b. Report Design c. Report Calculations d. Report Format e. Report Summary f. Report labels g. Report Printing Sharing Data with Word and Excel a. Importing d. Export Working with Charts Working with Pivot-Charts` IIASM Consultants 10 A, 1ST Floor, Veer Savarkar Block, Sikka M K House, Shakarpur, Near Nirman Vihar Metro Station Gate No-2, Delhi-110092 Phone no: 9212189653 Website: www.iiasmconsultants.com MODULE 4 PAY ROLL PROCESSING ï�¶ How to prepare Salary Structure for New Joining. Ï�¶ Defining & Calculating Salary Heads (Basic, HRA, MA, TA, SA etc.) ï�¶ Designing & Calculating CTC. Ï�¶ Calculations Tax Deducted by Source (TDS). Ï�¶ Defining & Calculating Gross Net Salary. Ï�¶ Education Cess ï�¶ Discussion on Compensation & Benefits. Ï�¶ Calculating Statutory Compliances: PF, ESI, Gratuity and Bonus as part of CTC. 4.1 PAYROLL REPORTING ï�¶ PF report in Excel Sheet ï�¶ ESI report in Excel Sheet ï�¶ Professional Tax Report Please find the course and fee details. Classes & Course can be designedcustomize as per request. Fee According to Module:- Module 1 to 4 â�� Course Duration is 100-120 Hours Rs. 16,500- Module 1 to 3 â�� Course Duration is 70-80 Hours Rs. 12,500- Module 1 to 2 â�� Course Duration is 40-50 Hours Rs. 10,500- Module 1, 2 & 4 â�� Course Duration is 40-50 Hours Rs. 12,500- Note:- 1. Classes will be provided as per student requirement. 2. Arrange Extra Doubt Classes as per student requirement after training. Add On Benefits:- Free Trial Class by Professional MIS Expert Free Study Material Free All Training Classes Videos 100% Job Guarantee

MIS Training

Get Price Quote

MIS Training, Advanced Excel Training, Excel Training Courses

MIS Training

Get Price Quote

MIS Training, C Programming Course, MCSE Training

Industry Level MIS Training

Get Price Quote

Industry Level MIS Training

MIS Training

Get Price Quote

MIS Training, Excel Training Courses, vba macros training

MIS Training

Get Price Quote

MIS Training, microsoft project training, HVAC Training

MIS & Data Analyst Training

Get Price Quote

MIS & Data Analyst Training, HR Generalist Training

Professional Training For MIS

Get Price Quote

Professional Training For MIS, sql course

MIS Training

Get Price Quote

MIS Training

MIS Training

Get Price Quote

MIS Training, eps recycling machine