dots bg

Certification in Advance Excel with MIS

Excel MIS Report is an Act of Information Management System use-case where Excel is employed as the data storage and management system. Data/Business Analysts and Business Head/Managers coordinate with each other and generate interactive reports. These reports are sent to the higher authorities or decision-making board to take action against the reports obtained and ensure they rectify the issues faced, and achieve improvement.

Course Instructor

₹5500.00 ₹10000.00 45% OFF

To enroll in this course, please contact the Admin
Contact Admin
dots bg

What You’ll Learn

  • Customisation of Ribbon
  • Customisation of Quick access tool baar
  • Customisation of display of software
  • Customisation Sheet

  • LEN
  • UPPER
  • LOWER
  • PROPER
  • Date Related worksheet functions
  • Current Date Function
  • Time Function

  • Create A Column List of Item in Excel
  • Import A List of Items from Cells
  • Use Your Custom List
  • Edit Or Delete a Custom List
  • Create A Custom List in Excel
  • Quick Sort
  • Multi- Level of Sorting
  • Custom Sort Order
  • Subtotal Function
  • Advance Filter
  • Filter Data from One Worksheet to Another Excel

  • Join two or more cells
  • Changing the case of Text
  • Extracting characters from string
  • Counting specific characters in cell
  • Find error

  • Introducing Lookup Formula
  • Functions relevant to lookups
  • The VLOOKUP functions
  • The HLOOKUP function
  • Lookup Function

  • Specifying the data
  • Specifying the location for the pivot table
  • Laying out the pivot table
  • Formatting the pivot table
  • Modifying the pivot table

  • Simple XLOOKUP
  • Two-way XLOOKUP
  • Double data XLOOKUP
  • Horizontal lookup
  • Left lookup
  • Exact match
  • Approximate match

  • Understanding how excel work on charts
  • Parts of a charts
  • Creating charts
  • Working with charts
  • Understanding Chart types
  • Making chart sheet
  • Making Chart Sheet

  • Information about Conditional Formatting
  • Conditional formatting by using graphics
  • Formatting using data bar
  • Find Duplicate values
  • Remove Duplicates

  • Pasting Formulas
  • Pasting Values
  • Pasting Formats
  • Pasting Comments
  • Pasting Validation
  • Mathematical operations

  • Protecting worksheet
  • Unlock cells
  • Sheet Protection options
  • Protecting workbook
  • Requiring a password to open workbook
  • Saving workbook as a PDF file

  • COUNT, COUNTA, COUNTBLANK, COUNTIF
  • SUMIF, SUMIFS
  • Subtotal Count
  • Using Functions in Pivot Table

  • About data Validation
  • Specifying validation criteria
  • Types of Validation
  • Drop down list
  • Customisation

  • Excel Project management dashboard
  • Project Status Dashboard.
  • Interactive Sales Dashboard
  • Customer Service Dashboard
  • Dynamic Dashboard using Excel Slicers