Month: January 2020
EXCEL Pivot-Table के ये ज़बरदस्त Features आपको नहीं पता होंगे, Pivot-Table in Tabular Form
Watch This Video to Learn
Excel में TOP 2 Ranking Items और उनका Total क्या है कैसे निकाले,with Large Formula & Vlookup Formula
Watch This Video to Learn
=MAX( ) =MIN( )Formula in Excel,Show Negative-Positive Value Separately
Here in this video, i have explained how to separate negative value and positive value in different cells. To separate the negative and positive value we have used =MIN & =MAX formula. Watch This Video to Learn
Top 6: Advanced Excel Shortcuts (Powerful & Faster) in Hindi
If you want to increase your working speed in excel then this video is for you, here in this video i have explained MS Excel Top 6 amazing shortcut keys that will help to work faster and easier. Watch This Video to Learn
Penalty Formula IF employee reach Office Late with =IF( ),=TIME(hr,mm,sec), =MAX( )
Friends, in this video i have explained a formula with the help of which you can calculate the Penalty Amount if Office Employee Reach office late time after office timing. So here i have used MAX FORMULA, IF-ELSE FORMULA AND TIME FORMULA to solve the issue. I hope it will be very helpful for you. … Read more