CERTIFICATE IN MANAGEMENT INFORMATION SYSTEM

Duration: 1 MONTH

Course Syllabus

  • Basics of Excel, Formatting, Database Functions :
    • Excel Operators, Logical & Text Formulas./ Formula error checking. Excel Sheet Formatting. Date and time functions, Datebase functions like DSUM, Daverage, DCOUNT, DGET.
  • Relative, Absolute & Mixed Referencing :
    • Creating Absolute/Mixed References. Problems with Absolute/ Relative Cell Referencing
  • Look up Functions :
    • VLOOKUP() - a practical perspective.VLOOKUP()w.TRUE - When & Why ? VLOOKUP() with MATCH() 2-D lookup.INDIRECT() + Range Naming for 3- D lookup INDEX() and 2 MATCH(), XLOOKUP
  • Pivot Tables, Pivot Charts & Power Pivot :
    • Creating, Formatting Simple PivotTables, Page Field in a PivotTable. Formatting a PivotTable. Creating / Modifying a PivotChart
  • Complex & Logical Formulas :
    • IF(), Nested IFs, AND(), OR(), Combo Logics; IFERROR().
  • MIS Reporting & Dashboard Techniques :
    • Automatic row-wise Subtotal, Gridlines, Data Validation (list), Cell-Range Naming, Grouping. Build Business reports like Sales, Inventory, Salary Report, Dashboards, etc.
  • Charting & Conditional Formatting
    • Creating Multiple Chart Type, Primary, Secondary Chart, Trend line Charting, Scatterplot, Conditional Formatting
  • Protection, Validation, Import of Data:
    • Protecting sheets/ workbooks / Files, Importing Data from Text Files / Web
  • Macro Application :
    • Developer tab; Record & Run a Macro, Understanding & Editing VBA Code of Macros.
  • Data Cleaning :
    • Learn Data Cleaning Techniques.
  • Data Analysis :
    • What if Analysis, Forecast.

Read More

Eligibility

.


Back to top