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

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

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

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

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

Making Profit and Loss Statements in Excel using Pivot tables

Being an accountant myself trust me I hate numbers and all that journals and "T" accounts. But its necessary to get to much meaningful financial statements like Statement of Financial Position (Balance sheet) and Profit...

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

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

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

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...
12,795FansLike
2,154FollowersFollow