It is a part of MS Office . Temp Plate concept is attached with each and every Master in Payroll system.
Final MIS Out put is depend upon Basic Available Data :
SQL : Extraction : Modification : Beautification : etc.
Linking : Rounding Off concept : if and else
Macro writing : Corresponding changes : Ratio analysis.
Data Extraction and Report Generator.
Advanced Excel is practice oriented Job
V-lookup : Pivot Table :
This function is connected with Static MIS and as and when required MIS Reports.
In Payroll we are using this Advance Excel for Data checking and Sample Checking etc.