1.MS EXCEL
Addition/SUM
Multiplication
Condition.
If You Get Some Mistake Plz Give Me Time For Solve It.
Thanks🥰
01. Set Page Accurately
02. Set Word Processing Where From You Should Be Start –Obey The Condition
03. Set Date Of Today Date
04. Set 11 Digits Of Mobile Number (Bd)
05. Unique Product Id Validation
06. Pcs. Word Set With Quantity
07. Catch Total Amount By Multiplication (Item * Rate)
08. Catch Grand Total From All Amount (Sum Of All Amount)
09. Discount From Grand Total (Using Condition And Formula)
10. Vat From Grand Total (Using Condition And Formula)
11. Get Payable Amount Deduct (Discount From Summation Fo Grand Total And Vat)
12. Follow the Job Sheet For Writing Font Size...
Condition.
If You Get Some Mistake Plz Give Me Time For Solve It.
Thanks🥰
01. Set Unique Validation Emp ID ( Data>Data validation>Custom)
02. Set Drop Down list of Designation (Data>Data validation>List>Give Source)
03. Set Auto fill Salary by Using Designation Name (Use Formula/Function)
04. Take HR from Basic Salary (Using Formula/Function)
05. MA follow to Job Sheet (or set by Yourself)
06. PF follow to Job Sheet (or set by Yourself)
07. IT Follow Job Sheet (or set by Yourself)
08. Gross Salary Follow Job Sheet (or set by Yourself)
09. Net Salary Follow Job Sheet (or set by Yourself)
10.Min/Max Follow Job Sheet (or set by Yourself)
11.VLOOKUP Follow Job Sheet (or set by Yourself)
Condition.
If You Get Some Mistake Plz Give Me Time For Solve It.
Thanks🥰
THANKS FOR JOIN WITH ME