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

Excel Pivot Table – Introduction: What, Why and How for Absolute Beginners [1 of...

Excel is surely a cavalry of features. And if we count the ways in which each feature can be useful just makes the whole think almost countless. However, for every feature one must know...

Prepare (Normalize) the data for Pivot Tables using Power Query

Pivot tables is a love of life for many Excel heads for its ability to move elements of reports easily is pure awesomeness. Pivot table has greatly improved since improv. But it still has limitations. And one...

Dynamic Common Size and DuPont Analysis Financial Statements in Excel

What if you have to make few analysis together in Excel like common-size analysis, ratio analysis and duPont analysis, well this is what I did this weekend. And the best part is that it...

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

Grand Totals to the left of Excel Pivot Table instead of default right

In pivot tables by default grand totals appear at the right end of the report. But sometimes the pivot table is so wide that user just can't see the grand totals and we have...

Excel Pivot Table Slicers: Old Filters got Overhauled!

First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...

Stock Ageing Analysis Reports using Excel – How To

Stock is one of the most important investment made by the entity. Optimum quantity and turnover period is essential for entity to be successful. Faster the conversion, better the prospects for entity as inventories...

Making Aging Analysis Reports using Excel Pivot Tables – How To

Last time when I discussed preparing aging analysis in Excel, I used formula approach to do it. I used the combination of IF and TODAY functions and then used conditional formatting and sparklines to...

Making Sales Dashboard using Excel Slicers – How To

So many reasons why not to hate Excel dashboards. They are beautiful, they are dynamic, they make everything super easy to understand. And not to mention it one cool way to grab attention at...