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

by

Watch This Video to Learn Download More Excel Files

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 Download More Excel Files

=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 Download More Excel Files

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 Download More Excel Files

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

Automatic Pricing in Sales Invoice in EXCEL

by
Automatic Pricing in Sales Invoice in EXCEL || Combination of IF Formula, Vlookup Data Validation

Friends, Here in this video, i have explained about some formula combination in excel. we have solved a big problem in excel invoicing that is automatically picking the pricing from Pricing Table into our Sales Invoice format. So we have used Data Validation command and Vlookup Command with IF Else Function to solve this problem … 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

Make Sales Commission Report in Excel (in Hindi)

by
sales commission tracker template for excel , sales commission template excel , employee commission template , sliding scale commission excel template , google sheets commission template , sales commission calculator , sales commission statement , free sales commission report template

Here we have used IFS Formula in Excel to calculate and prepare the Sales Commission Report for our Sales Man. IFS Formula is not available in Excel 2007 but you can use it in the latest version of excel. Watch This Video to Learn Download More Excel Files

Match 2 Data in Excel || Compare 2 Data in Excel || Compare Two Lists in Excel (in Hindi)

by
Match 2 Data in Excel Compare 2 Data in Excel Compare Two Lists in Excel (in Hindi)

Here in this video, i have explained that how to compare two data lists in excel and extract the unmatched data in a new sheet. so watch this video completely to learn how to match 2 data in an excel sheet. Watch This Video to Learn Download More Excel Files