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.

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

OBJECTIVES

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