Remove leading Apostrophe (‘) in Excel Data from Numbers and Text – How To
This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business...
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 I explained the example of mathematical lookup table to find...
Making Aging Analysis Reports Using Excel – How To
Aging analysis is helping accountants since ages and is one of those reports that are prepared mostly in Excel to track both receivables and payables. So today we are learning how to conduct aging...
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....
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 @...
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...
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...
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 accountants. In many instances SUMIF can be used as an...
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...