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 feature in Excel. But what if we only want to...
FIFO Inventory Valuation in Excel using Data Tables – How To
Inventory can be valued in number of ways, FIFO, LIFO and AVCO being the most famous. To learn few more inventory valuation methods have a quick look at this: What are different inventory valuation methods?
Entities purchase...
Rounding to nearest 1, 10 or 100 in Excel – How To
Don't be frightened I am not giving you any fifth graders' challenge. But in real life you might be facing similar situation where you have a stack of numbers that require to be rounded...
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 learnt to sum the values based on one criteria i.e....
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 all levels. That is why charts and Excel is one...
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 newbie to pro everyone uses SUM formula. We have recently...
How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of...
Functions to Excel is like Sense to Humans. Humans with absent sense are no better than crawlers walking on two legs, without functions Excel is just another program with ability to store information and...
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 problem if you have tens or even few hundreds of...
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 without losing its meaning and value. But what if you...
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 parts i.e. the username (part at the left of @...