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...

Making Dependent Drop-down Lists in Excel – How To

Excel drop down list is one of the most useful features in Excel that are used in a variety of ways from data entry in Excel to interactive Excel dashboards. Drop down lists serve multiple...

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...

Automating Data Entry using Data Validation in Excel

This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...

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...

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...

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...

Create Data Validation lists from Unsorted data with duplicates in Excel [How To]

Today I finally decided to make an Excel dashboard on debtors aging analysis. The main reasons to do this dashboard were that: I thought now enough knowledge has been delivered to my cult followers that...

10+ Excel features in Home tab that every beginner MUST learn

1 Don't just Paste, Paste Special! Position in tab: Clipboard group>Paste button drop down | Shortcut: Alt+Ctrl+V This one is definitely a speciality in Excel's arsenal of features. Normal paste option only put what you copy...

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...