Module 1: MS-Excel

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

Module 2: VBA | Macros in VBA

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

Module 3: SQL

• Database concepts
• Installing and also setting up Database
• 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 also Functions
• Datetime and also Functions
• Sorting
• Grouping, Having
• Filtering with Where, like, in etc
• Removing Duplicates
• Relationships between tables
• Joins – Inner, Outer, Crossa and also Self
• Aggregate Functions
• Triggers – Query Optimization Techniques
• Sub Queries
• Views
• Union, Union all, Intersect, Except
• Indexes and also using indexes for query performance
• Procedures (Basic and parameter based)
• Functions
• Transactions – Begin, Commit, Rollback
• Working with JSON and XML data
• using spatial data types, managing users and also permissions
• using roles and privileges
• Ensuring data security and also encryption

Module 4: Ms Access

• Access Environment
• Access table creation
• Working with Tables
• Properties in Access
• Data types in Access
• Data Migration and also 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

Module 5: Python

• Installing Python
• Running Python scripts
• Python ide (Jupter notebooks, Pycharm, VS code)
• Variables and Data type,
• Basic operators, Input & Output
• Conditional Statements (if, Elif, Else) , Loop( For, While )
• Lists, Tuples, Sets, Dictionaries, Defining functions
• Function Arguments and also Return values
• Lambda functions, Importing modules
• Standard library modules
• Creating and using packages
• Reading & Writing files
• Working with CSV and JSON files
• Try, Except, Finally, Raising exceptions
• Classes and Objects, Methods, Inheritance
• Polymorphism, Abstract Classes and also Methods
• Static and Class methods
• Encapsulation lterator
• Creating generators using Yield
• Numpy, Arrays
• Array operations, Advanced array manipulation
• Mathematical and Statistical function
• Pandas, Data structures, Data operations
• Data manipulation, Data cleaning, File I/ O with pandas
• Matplotilb, Baisc plots
• Plot customization, Subplots, Advanced plots
• Seaborn, Relational plots, Matrix plots
• Scikit, Basic concepts
• Supervised learning
• Unsupervised, Model evaluation, Model selection
• Tunning, Pipeline and also Workflow

Module 6: 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