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

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

How to LOOKUP using ONLY Conditional Formatting in Excel

Few days back we learnt how to do 2-way lookup i.e. looking up the value against two criteria. You can learn it in detail here: How to do 2 Way Lookup in Excel – One...

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

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

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

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

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

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

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