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

Creating Scrollable data ranges in Excel – Excel Form Controls: Scroll Bars

If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans! But we humans have another issue and...

Variance Analysis in Excel – Making better Budget Vs Actual charts

Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...

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

Making Birthday and Age Calculator in Excel [How To + Dedication + Prayers]

Last year the same day we learnt how to make a birth date heat map in Excel. So lets another Excel trick exactly one year after. Lets say the date of birth is August 6, 1986....

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

Creating and Working with Dynamic Charts in Excel

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

Extract File Extension from file names in Excel – [Quick Tip]

What if your manager gave you a file with thousands of file names and you have to extract file extensions? If you are following our Excel tutorials on regular basis then it won't be...

Extracting Integer and Decimal portion from a number in different cells – Part 1

When it comes to information then most of the time its about numbers and often numbers come with decimals i.e. numbers that are written as: 9.82 0.9856486 1021587.986244 But what if we are only interested in decimal portion...

Dealing with Telephone numbers in Excel – Dialing in the correct format

Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain...