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