10+ ways to SUM Top N values in Excel data range – Ready to...
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel...
Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function...
A classical scenario to understand the excellence of Excel. There might be situations where we would like to split the email address in two...
Randomly Select a Name from a list in Excel – How To
Suppose you have a long long list of customers from which you have to select a random name. Now this is certainly not a...
Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his...
How Excel VLOOKUP Works: How to use it – Explanation with Example
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better...
Excel SUMIFS function – Summing up Invoices based on multiple criteria
Excel conditional functions are part of almost every worksheet. The logical test functions help us carry out different operations easily. While discussing SUMIF we...
Make a distinct count of unique values in Excel – How To
Excel is a love of life for everyone who wants to tame the data by making much larger data in short yet precise data...
Using SUMIF function with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially...
Making Interactive Charts in Excel [How To]
Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at...
How to Highlight Blank Cells in Excel using Conditional Formatting [Quick Tip]
With huge data pinpointing blank cells is near to impossible. Sometimes back we learnt how to fill blank cells with zero using Go-To special...