MIS Practical Training
Management Information Systems
MIS The unique courses where student will learn Management and Technical field both. This course contains technical subjects all management relevant subject. The program provides students with the broad perspective needed to advance in their managerial careers. Combination of Management and Technical courses make it simple.
What is the Curriculum of MIS?
Following are the main curriculum of MIS
Basic and advance excel provide Basic/Advanced Understanding of Excel, ensure user can make advance analysis with the help of those tools. It is user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel.
Introduction to excel, Basic Understanding Menu and Toolbar, Introduction to totally different class of functions like Basics, Mathematical and applied math, Date and Time, Logical, search and References, Text and data like
Count, Vlookup, Countifs, Counta, Match, Sum, Find, Search, Countblank, Average, Max, ABS, SUMIF, SUMIFS, Index, Offset Lower & Upper, Proper, Trim, LEN, Left, Right, Mid, CONCATENATE, Subtotal, AND, OR, EOMONTH, EDATE, Networkday, Today, Weekday, Weekmumber, Workday, Hlookup, Iferror, Import and Export information, Pivot Table & Chart, Protect/Unprotect sheets/workbooks. Worksheet info and Print show
DASHBOARD & VBA
Dashboard reports enable user to induce high-level summary of the business and facilitate them create fast choices. Dashboards square measure typically referred to as MIS, that provides data that organizations need to manage themselves with effectively.
To outline KPIs (Key performance Indicator), client Service Dashboards or Project Management Dashboard (Gantt Chart)
Dashboard reports supported Tables and range or Charts/Graphs or each.
Introduction to Programming Introduction to thinking flowcharts & algorithms:- outline objective, begin & finish points; distinctive resolution & breaking it into sequent steps Writing associate degree formula in small stages directions, flowcharts, method flow diagrams. surpass Macros- associate degree introduction
the ability of Macros – What , When, the way to use Macros. Introduction to object bound programming Objects, Its functions, ways and properties Introduction to Events
Details of events, however & once to use of events, getting ready to ‘Macro’ Visual Basic Editor (VBE) – Developer Tab, Security
Introduction to the VBE, Properties window, Project someone, word protection of code the way to use the VBE – options, Options, Intelligence technology
Debugging mode, Bookmarks, Breakpoints, Watch window, Immediate window and Locals window integral VBE facilitate Feature – Tips and Tricks. Terms like ‘Compile’, ‘Debug’ ‘Keywords’ etc. Recording Macro
If associate degreed once to use Macro recorder with the code a lot of On surpass Macros – I Structure of an surpass book from
VBA purpose of read – Common Objects
MS surpass Objects like Applications, Work sheets, Workbook,etc. Codeing plateform , Variables and Constants
What square measure variables and constants?
style of variables; however and once to use variables to store data.
Typical Variable naming epitome once to use constants or Variables a lot of on surpass Macros – II Loops
For-Next, For-Each, Do-While, for every Loop Decision-making and Code Branching
If-Then-Else, Select-Case, And/Or conditions User outlined functions (UDF)
What square measure user outlined functions. the way to produce & use them.Form Controls vs. ActiveX Controls stepping into the Code MsgBox and Input Box operating with knowledge in surpass
knowledge varieties in surpass worksheets, like Dates, Texts, Nulls etc. operating with workbooks, worksheets, ranges, cells etc.
operating with dynamic ranges. protective worksheets, cells and ranges. operating with multiple files. gap & Saving files
Introduction to User Forms
operating with User Forms & User Forms events
User kind Controls
the way to use knowledge validation within the management
Use of Text Box,Label,Drop down, list box, image Box
what’s the employment of Message confine VBA
looking out knowledge into to the info and finding records from the info
Connecting VBA to Outlook
causation Email to multiple Users through VBA
the way to establish affiliation between VBA and net someone to open any net information processing system through VBA
knowledge Validation & Input restrictions Effective secret writing
Testing and Debugging your code
Effective Error Handling
Automation Development Report & Live Project