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