Certificate In Management Information System

by AICPE (All India Council For Professional Excellence) Claim Listing

Certificate in Management Information System course is offered by AICPE. As all our courses are designed by experienced professionals, academic experts, and technicians; they're scientifically developed, relevant, and high compatible with the prevailing work environment.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

AICPE (All India Council For Professional Excellence) Logo

img Duration

1 Month

Course Details

Certificate in Management Information System course is offered by AICPE. As all our courses are designed by experienced professionals, academic experts, and technicians; they're scientifically developed, relevant, and high compatible with the prevailing work environment.

Our content and modules are practical highly effective and relevant. All our courses are aimed at transforming individuals into employable and skilled human resources; competent to serve private and public sectors at various levels; start their own enterprises or be trained in their chosen vocation.

 

Course Objectives:

  • To equip students with essential Excel skills, including database functions, lookup functions, and data analysis techniques.
  • To provide an understanding of MIS concepts and the practical application of MIS in real-world scenarios.
  • To prepare students for self-employment opportunities in data analysis, reporting, and MIS consulting.

 

Syllabus:

  • Module 1: Excel Basics and Database Functions
  • Introduction to Excel and its interface.
  • Formatting cells and sheets.
  • Excel operators, logical and text formulas.
  • Formula error checking and troubleshooting.
  • Database functions: DSUM, DAVERAGE, DCOUNT, DGET.
  • Module 2: Cell Referencing and Lookup Functions
  • Relative, absolute, and mixed cell referencing.
  • Creating absolute/mixed references.
  • Problems with absolute/relative cell referencing.
  • Lookup functions: VLOOKUP, HLOOKUP, INDEX, and MATCH.
  • Advanced lookup techniques with XLOOKUP.
  • Module 3: Pivot Tables and Charts
  • Creating and formatting PivotTables.
  • Page Field in a PivotTable.
  • Modifying PivotTables.
  • Creating and formatting PivotCharts.
  • Primary and secondary chart types.
  • Trendline charting and scatterplots.
  • Module 4: Complex Formulas and MIS Reporting
  • Complex formulas: IF, nested IFs, AND, OR, IFERROR.
  • MIS reporting and dashboard techniques.
  • Automatic row-wise subtotal.
  • Data validation with list.
  • Cell-range naming and grouping.
  • Module 5: Charting, Conditional Formatting, and Data Import
  • Creating multiple chart types.
  • Trendline charting and scatterplots.
  • Conditional formatting for data visualization.
  • Protecting sheets, workbooks, and files.
  • Importing data from text files and the web.
  • Module 6: Introduction to Macros and Data Analysis
  • Developer tab in Excel.
  • Recording and running a macro.
  • Understanding and editing VBA code of macros.
  • Data cleaning techniques.
  • What-if analysis and forecasting.
  • Nagpur Branch

    F-21, Sai Regency Apartment, Nagpur

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy