MIS Executive Course

BPA offers MIS Executive Course Training, that is, Management Information System meaning a computer-based system enabling managers with the tools to organize, evaluate and efficiently manage departments within the organization. The system is in place to ensure that business-related data is stored correctly and is easy to access and refer to whenever the need arises. The role of the management information system (MIS) manager is to focus on the organization’s information and technology systems. MIS manager typically analyzes business problems and then designs and maintains computer applications to solve the organization’s situation. MIS Executive Course training at BPA Educators is specially designed after a lot of research and according to the need of the industry and multiple corporations. BPA Educators provides the best MIS executive course in Rohini, Delhi.

You will also Receive

• Study Material
• Sessions on Personality Development, Time Management, Career options
• 3 Live project
• A Certificate of Professional Training after the Completion of the Course
• OJT(On the Job Training)
• OJT Certificate
• Expert Advice

Modules of MIS Executive Course

MS-Excel

• Basics
• Lookups
• Advanced Filters
• Pivot Table and Charts
• Combining Data from Multiple Worksheets
• Extracting data page wise
• Slicer/TimeLine
• Data management and security
• Formatting for reports
• Data Analysis with what-if, goal seek ec
• Formulae in Excel(Text, Logical, Maths)
• Advance charts, graphs
• Data validation,protect/unprotect sheets & workbook
• Financial analysis(NPV, IRR etc.)
• Power pivot, Power query
• Dashboard

VBA|Macros in VBA

• Dashboard Designing
• VBA Operators, Expressions, Data types and variables
• Looping
• Subs, Functions, Arrays, Logics and Advanced Array Formula
• Programming with VBA Macros
• Error Debugging and Protecting Code
• Creating Custom Worksheets
• User Forms
• Connecting excel VBA and other platforms

SQL

• Queries in SQL
• Insert Data
• Create Data
• Alter Data
• Update Data
• Deleting Data
• Data Sources
• Selecting Rows
• Selecting Columns
• Data Types
• Strings and Functions
• Numeric and Functions
• Datetime and Functions
• Sorting
• Grouping, Having
• Filtering with Where, like, in etc
• Removing Duplicates
• Relationships
• Joins
• Aggregate Functions
• Triggers
• Sub Queries
• Views

Ms Access

• Access Environment
• Access table creation
• Working with Tables
• Properties in Access
• Data types in Access
• Data Migration and Importing
• Relationships
• Access Forms
• Design Mode
• Wizard Mode
• Creating Subforms
• Display Summary Data
• Runtime Forms
• Access Forms
• Design Mode
• Wizard Mode
• Charts in Report
• Calculated Fields
• Sub Reports
• Runtime Reports

Business Communication

• Interview skills
• Email writing
• Presentation skills
• Body language
• Communication skills

CAREER OPTIONS AFTER MIS EXECUTIVE PROGRAM

• Data Analyst
• MIS Analyst
• MIS Support Executive
• MIS Professional
• Finance Analyst
• MIS Executive

Duration: 4 to 6 Months

Enroll Now