In this short video tutorial YOU Will Learn important excel formulas used in creating employees id card System through excel. Following are the key discussions of this tutorial : 1 Lookup formulas 2 data validation in excel 3 picture lookup formula in excel 4 name manager in excel 5 Drop Down list in Excel. 6 […]
In this short video tutorial YOU Will Learn important excel formualas used in salary sheet and payslip, Gross , Taxes , Loan , Advances and Allowances , Also creating individual payslip & enevelpe printing. Following are the key discussions of this tutorial : 1 mod formula to calcualte leap year 2 sum , randbetween […]
In this short video tutorial YOU Will Learn important excel formulas used in attendance sheet or calendar, Following are the key discussions of this tutorial : 1 Different type of count formulas 2 Date , text formulas. 3 Conditional formatting & colors function. 4 Data Validation tips and tricks. 5 Drop Down list in Excel. […]