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 their working through example and explained how pivot table let...

Making Cash flow summary in Excel using Pivot tables with data on multiple worksheets

Cash flow summaries are scary because of piles of data. But it is a routine work and accountants have to go through it every accounting period (monthly, quarterly and/or annually). Few days back I was approached...

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

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

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

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

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

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

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