How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency...

In almost every office of the world when it comes to money accountants come to excel. Although excel can handle money matters but when it comes to currency by default we have Dollar ($)...

How to make a basic Tax calculator in Excel

Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small change you might have to punch millions of calculator keys...

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

10+ ways to SUM Top N values in Excel data range – Ready to...

We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...

Running Totals and Running Balance with Excel Pivot Tables – How To

Last time when I discussed how to do running totals and running balance using Excel many different ways were discussed but one was left for today which is doing running totals and running balance...

How to sort Rows horizontally left to right instead of Columns vertically top to...

Sorting is one of the many good things excel offers. And it does make our job a lot easier once the data is arranged in particular order. However there is one limitation to the...

Entering data on multiple Excel worksheets in one go

If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different...

Count Specific Weekday or Weekdays within Data range containing Dates

Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is...

Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...

A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in...

Excel Pivot Tables – Grouping Dates by Week Within Months, Quarters or Years –...

Earlier we learned about grouping and ungrouping time related information very easily using excel pivot tables. It saves huge amount of time in preparing summary pivot table reports with different dimensions of time. However, we...