techguruplus

Excel में ये फंडा आपको नहीं आता होगा || Excel Hidden Tricks (Hindi)

by

Watch This Video to Learn        

=RandBetween( ) Formula Part-2 in Excel (in Hindi)

by

RandBetween( ) Formula (in Hindi) Secret Excel Formula( ) Very Important video for Accountants & Professionals and office users. Watch This Video to Learn        

Excel में Mobile Data कैसे Filter करें || Len Formula in Excel (Hindi)

by

Watch This Video to Learn    

EXCEL Pivot-Table के ये ज़बरदस्त Features आपको नहीं पता होंगे, Pivot-Table in Tabular Form

by

Watch This Video to Learn      

MACRO (PART-7)-VBA Code for Unhide All Excel Sheet with a Shortcut

by

Here is the code to unhide all excel sheets at one click:-  Sub UnhideSheet() Dim Sheet As Worksheet For Each Sheet In Worksheets: Sheet.Visible = True: Next Sheet End Sub Watch This Video to Learn        

=MAX( ) =MIN( )Formula in Excel,Show Negative-Positive Value Separately

by

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

by

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( )

by
if else formula, time formula, penalty formuala, max formula, if else formula in excel, time formula in excel, penalty formuala in excel, max formula in excel, excel hidden formula, excel secret formula,

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

How to Make Word-Cloud for Official Presentation for PowerPoint / Word / Excel or for Website

by

Friends, Lots of times when we make any type of presentation, we need an effective image as related to our topic as we are presenting. If you search on the internet, you will find that people enter a word cloud in their presentation, or in a file or on their website post. so here in … Read more

TOP-3 Excel Hidden Shortcut keys & Commands Best Time-Saving Tricks

by

Friends here in this video i have explained about AutoCorrect Command and how can we use AutoCorrect Command in our daily routine. We can save lots of time by using this command in excel. I have applied Auto Correct Command in our Billing Format. Also, i have explained that how to play with months in … Read more