Advance Excel – MIS Specialization - Excelcomputerinstitute

Advance Excel – (MIS Specialization)

(Skill Level)

Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

1. Customisation of software

Customisation of Ribbon.
Customisation of Quick access tool bar.
Customisation of display of software.
Customisation Sheet.

2. Functions of excel

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

3. List Sort & Filter

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

4. Creating Formulas that Manipulate Text

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

5. Creating formulas that lookup values

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

6. MIS with Pivots Tables

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

7. MIS with Xlookup Function

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

8. Types of Charts

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

9. Conditional Formatting

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

10. Special Paste content

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

11. Protect Workbook

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

12. Count and sum Function

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

13. Use of Data Validation

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

14. Dashboard

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

Overview
Eligibility Criteria
Certification
Duration

Whether you are considering a career in data analytics or looking to enhance your skills on the job, Excel training can be valuable in preparing you for a variety of promising roles.

SSC Completed / HSC Completed
Pursuing or Completed B.COM / BMS / BBA / BBI / BAF / BFM / M.COM / CA / CS.
Accounting Students
Other Undergraduates / Graduates.

SSC : Smart Skill Council Certification.

DiTRP ( Digital Information Technology & Research For Professional)

CBITVT : Central Board of IT & Vocational Training.

MKCL : Maharashtra Knowledge Corporation Limited

45 Days.

Overview