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

Excel Pivot Tables – Grouping Data by Date and Time

Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for...

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

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

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

Budget Vs Actual – Analyzing Profit and Loss Statements in Excel using Pivot tables

This tutorial is effectively a continuation of last tutorial on profit and loss statements using pivot tables in which we learnt how to make a report in Excel using pivot tables feature to make...

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

Make a distinct count of unique values in Excel – How To

Excel is a love of life for everyone who wants to tame the data by making much larger data in short yet precise data without losing its meaning and value. But what if you...

Making Cash flow summary in Excel using Pivot tables with data on multiple worksheets

Cash flow summaries are scary because of piles of data. But it is a routine work and accountants have to go through it every accounting period (monthly, quarterly and/or annually). Few days back I was approached...