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

Check out more Information System courses in India

Edudelphi Logo

CISSP Certification

Certified Information Systems Security Professional (CISSP) By International Information Systems Security Certification Consortium (ISC)²

by Edudelphi [Claim Listing ]
Novelvista Learning Solutions Private Limited Logo

Certified Information Systems Auditor (CISA) Training & Certification

CISA training and certification course aim towards delivering knowledge regarding governing and controlling IT enterprises to perform effective security audits. CISA (Certified Information System Auditor) certification is acknowledged across the globe as the standard of Business systems.

by Novelvista Learning Solutions Private Limited [Claim Listing ]
NVT Quality Certification International Logo

ISO 27001 (ISMS) Lead Auditor Course

ISO 27001 (ISMS) Lead Auditor Course is offered by NVT QC NVT QC has carried out audits and offered training programs worldwide. We have the global presence and experience necessary to help organizations to capitalize on opportunities in developed and emerging markets.

by NVT Quality Certification International [Claim Listing ]
Web Brains Logo

CISA

The CISA course is useful for anyone looking to improve their information systems auditing skills or take the CISA certification exam. The course provides the practical understanding needed to demonstrate knowledge in the topics covered in the CISA exam.

by Web Brains [Claim Listing ]
Shreyas Quality Management System Logo

ISO 27001 (ISMS)

ISO 27001 training is offered by Shreyas Quality Management System. The programmes are conducted by expert faculties using modern training tools, case studies, exercises etc. and are highly interactive and make learning a great experience.

by Shreyas Quality Management System [Claim Listing ]

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