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....
Understanding, Detecting and Correcting Excel errors – #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!
One way to gauge how successful you are is to know how much you have learnt from your mistakes. But learning cannot happen unless you not only identify the mistake but also admit it as...
How to do 2 Way Lookup in Excel – One value to lookup with...
I can safely assume that almost everyone knows about LOOKUP formulas or precisely VLOOKUP. That is probably because sights and sounds of Excel don't go without shouts and screams of lookup formulas. Learning Excel...
My Top 10 personal favourite Excel keyboard shortcuts
Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel keyboard shortcuts that help me immensely when going through my...
Instantly Paste list of Defined Named Ranges in Excel workbook – Quick Tip
Excel's "Named ranges" feature is love at first sight! And whoever knows how they work would agree and must be loving them every bit. And the case with us humans is that whatever we...
Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature...