Multiple Column Data Validation Lists in Excel – How To
Today we are learning how to make dynamic multi columnar data validation lists in Excel that helps display much more data in the drop down list and are far superior and flexible than usual...
Creating Currency Converter in Excel [How To]
In the world we live in where almost every country has its own distinct currency and value, we almost always feel a need to convert one currency to another. These days it is easy...
Excel Conditional VLOOKUP – Switching Between Multiple Lookup Ranges
We all love LOOKUP functions in Excel and the heart favourite is VLOOKUP. We are well introduced to VLOOKUP and have already seen VLOOKUP in action several times, but we never came across a...
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...
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...
Making dynamic Chart of Accounts, Journal + Ledgers in Excel – How To
Excel is one of the favourite tools for accountants and for everyone else who has anything to do with accounting information. It is a tool of choice when it comes to data extraction and...