ADVANCED EXCEL SHEET

Complete knowledge on advanced Excel Sheet-all formulas & shortcut keys with their usage.
V Look up - formulas and its application
H Look up - formulas and its application
Auto & Advanced Filters - formulas and its application
Goal Seek- formulas and its application
Freeze Panes - formulas and its application
Pivot Table-Formation of charts & presentation
Macros- formulas and its application
Spilt- formulas and its application
Data Validation-searching & application
Transpose-its application.

MIS REPORT
Count if, Network days, Attrition-all formulas, Round sum, and, if,
Formatting of MIS