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...
Excel Pivot Table tutorial for Absolute Beginners: Creating your First Pivot Report [2 of...
In Part 1 of this little jump start series on Pivot Tables for Absolute Beginners I explained what excel pivot tables are the science behind...
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...
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...
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...
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....
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...
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...
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...
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...