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.
₹ ₹5000.00/- only (30 Seats Only)
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
