| MIS Training |
Duration 150 Hrs. |
| Program highlights and Objectives: |
| This program is specially designed for students willing to work as an office administrator, back or front office executive etc. Working professionals who wish to enhance their administrative skill with excel may also join this course. After completion candidate can work efficiently in MS-Excel with advanced features. |
| Course highlights |
- Navigate to the Excel User Interface
- Usage of Formulas
- Cell Reference
- Implementing Different Functions
- Data Analysis with Charts and Graphs
- Filter Function
- Data Forecasting
- Lookup Functions (VLOOKUP, XLOOKUP)
- Pivot Table and Charts
- Conditional Formatting
- Data Validation
- Data Mapping
- Dashboard Creation in Excel
- Introduction of Accounting with Golden Rules
- Company Setup using Tally Prime
- Passing Voucher Entries with Ledger
- Bank Reconciliation Statement
- VBA Introduction with Series Automation
- Decision Making Statement
- Loop
- Array
- Function in VBA
- Database Connection Using Forms
- Programming Charts in VBA
- Introduction to RDBMS
- Database Design and Architecture
- Database Key and Constraints Concepts
- SQL Types
- Creating and Managing Tables
- Manipulating Data
- Basic SQL SELECT Statement
- Restricting and Sorting Data
- Fetch Clause
- SQL Operator
- SQL Function
- Aggregating Data
- Subqueries
- SQL Joining
Final Project
|
| Download Curriculum |
| Exit Profile : MIS Professional |
| Placement assistance will be provided to all successful candidates |
| Training Objective |
|
The primary function of MIS is to report on business operations to inform decision-making. Organizations utilize MIS to improve management, optimize operations, and gain a competitive advantage in their industry. It is a great career choice for fresher’s & working professionals. |
