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

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

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

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

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

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

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

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

Restructuring (Normalizing) data for Pivot tables using Pivot tables – How To

Last time I discussed the use of Power Query to restructure data for pivot table purposes if it is not arranged in columnar format. Today we will be learning how to normalize the data for...
12,798FansLike
2,152FollowersFollow