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

Gologica Logo

Certified Information Systems Auditor Training

The CISA (Certified Information Systems Auditor) Online Training Course is designed to equip professionals with the abilities and knowledge required to excel within the area of statistics structures auditing, management, and safety.

by Gologica [Claim Listing ]
GICVS Certification Logo

ISO 27001 (Information Security Management System)

Information security management system help us to manage informatic assets of our organization of it part as per international standard ISO 27001.

by GICVS Certification [Claim Listing ]
Codec Networks Logo

CISSP

Certified Information Systems Security Professional (CISSP) is a registered trademark and course developed by (ISC)² and the most globally recognized certification in the information security market.

by Codec Networks [Claim Listing ]
Business Assessment Services Logo

ISO 27001 (Internal Auditor) Course

ISO 27001 (Internal Auditor) course is offered by Business Assessment Services. Business Assessment Services offers a industry leading training programmes to companies and individuals in Quality, Health- Safety, Environmental, Food Safety, Information Security and many other Management system.

by Business Assessment Services [Claim Listing ]
Networkers Champ Logo

CISSP Course

The CISSP certification course in Bangalore offered by Networkers Champ is ideal for professionals preparing for the CISSP exam. The course is aligned to the (ISC)² CBK 2015 requirements and educates you on the industry’s latest best practices.

by Networkers Champ [Claim Listing ]

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