Understanding Excel CHOOSE() function [Intro]
"Your life is what you choose it to be"
In essence whatever we give to life it returns the same. If we give peanuts, it will return peanuts. If it is 1 life will return...
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...
Building a reference to specific Worksheet based on Cell value using Formula
Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more...
Excel Drop Down List using Data Validation and Excel Tables that updates dynamically –...
Excel drop down lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. Data validation help us make such drop down lists easily.
For...
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...
Determine number of currency bills or notes for any amount – Currency bill Calculator...
Here is the situation, you are working somewhere and handling cash every second. You have to manually determine how much number of bills of each denomination you need to payout certain amount of cash. Instead...
Using Excel Custom Number Formatting as Data Validation Tool
Excel custom number formatting feature is immensely powerful. From hiding things to formatting telephone numbers correctly, to changing colours to use them to insert symbols in data or chart, it is definitely of great...
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...
Dynamic Financial Scenario Analysis using Excel
No denying that Excel is one of the best things happened to financial analysis world. Excel makes financial modeling and reports for decision making possible in all sorts of way. Excel is as able...
Make Budgets in Excel with Expenditure Limit – Budget Ceiling using Data Validation ...
Budgets help control the expenditures even before they actually incur. The concept of budget is to provide a ceiling or cap to expenditures so that departments or cost centers don't exceed a certain limit.
If...