MIS Executive Course

Module 1         Basic Computer

• • • Basic Concept of Computer
    • English Typing
    • Hindi Typing
    • Data Entry

MS Word

• • • Font & Paragraph Formatting
    • Editing, Saving & Printing Text Documents
    • Inserting Table
    • Header & Footer
    • Smart Art
    • Page Breaks
    • Using List & Styles, Spelling & Grammar Check
    • Understanding Document Properties & Tabs
    • Mail Merge
    • Document Views & Macros
    • Saving & Protecting Sheets Documents
    • Project Work

Advanced Excel                           

• • • Introduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)
    • All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
    • Entering and Editing Data.
    • Inserting and Deleting Row or Column.
    • Formatting Data
    • Auto fill Lists ( Default lists & Creating new lists)
    • Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
    • Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
    • Charts (Working With Charts)
    • Logical Functions (IF, AND, OR, NOT, IFERROR)
    • Financial Functions (PMT, PV, RATE, FV, DB)
    • Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, XLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
    • Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
    • Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
    • Project Work
    • and many more…

MS PowerPoint

• • • Creating & Printing Slides
    • Adding Custom Animation
    • Using Slide Transitions
    • Using Charts, Graphs & Photo Album
    • Creating Professional Presentation
    • Project Work

Internet

• • • Introduction to Internet
    • Browser Basics
    • Downloading, Searching, Surfing and Storing Data
    • Online Forms Submission
    • Online Bill Payment
    • Online Ticket Booking
    • and many more..

Module 2     

MIS Reports

• • • Types of Reports: Operational, tactical, strategic
    • Creating Reports: Templates, data collection, presentation
    • Automating Reports: Macros, scheduled reports
    • Project Work
    • and many more….

Pivot Tables

• • • Basics: Creating, designing pivot tables
    • Advanced Techniques: Grouping, calculated fields, charts
    • Insights: Analyzing data, using slicers, timelines
    • Project Work
    • and many more….

Dashboard Creation

• • • Introduction: Purpose, types of dashboards (Operational, Analytical, Strategic)
    • Excel Dashboards: Data prep, chart selection, using slicers
    • Advanced Excel: Pivot tables/charts, Power Pivot, dynamic dashboards
    • Design Principles: Layout, color usage, readability
    • SQL Integration: Pulling live data, combining with Excel for dashboards
    • Advanced Features: Real-time dashboards, automation, sharing/collaboration
    • Project Work
    • and many more….

Module 3     SQL

• • • Create, Manage Databases and Tables
    • Insert, Update, and Delete Data in tables
    • Select with filters(where) and Sorting(Order By)
    • Use join to combine data from multiple tables
    • Use functions like Sum,Avg, Count, MIN, and MAX
    • Create table relationships with foreign key
    • And Many More…

Module 4

• • • Personality Development
    • Interview Preparation
    • Job Skill Training

• We expect some basic understanding of English.
• No age restriction.
• Basic writing and reading skills.

• We expect students must have basic understanding of windows fundamental. However No academic qualification restriction. Students having little understanding of basic accountancy and economics will help in rapid completion of course.

Target Audience:

• Students preparing for jobs in various industries like accounting, finance, and data analysis.
• Professionals aiming for roles in MIS, data management, and business analysis.
• Small Business Owners who want to manage business operations and reports effectively.
• Accountants transitioning from manual systems to computer-based systems.
• Anyone looking to improve computer, data analysis, and reporting skills to boost career prospects.