Budget vs. Actual Profit Loss Report using Pivot Tables
This is continuation of our earlier post Preparing Quarterly and Half yearly P&L using grouping option. You can also do budget v/s actual comparison using Pivot Tables. For this we will use calculated items feature of Excel PivotTables.
To begin, we have to add one more column to our data. I have added column Data Source to the end of data table. Existing data is marked as Actual and I have added more data rows which are marked as Budget. You can download new file with updated data and basic Pivot P&L.
Quickly Turn off Gridlines in Excel 2003 using Forms Toolbar [Excel Tips]
These days I rarely use Excel 2003. But when I do open the trusty old software, I always look for opportunities to improve my productivity with it. And I am pleasantly surprised to find a shorter and faster way to turn off grid lines on spreadsheets in Excel 2003. (I like my spreadsheets without any […]
Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]
In a follow up to last week’s how to visualize survey data in excel, we will explore how you can create an incell dot plot panel chart. Please follow the links in the article to get more commentary and insights from established persona in the visualization world (including Stephen Few, Naomi, Jon etc.)
Make your Chart Legends Legendary
We all know that legend can be added to a chart to provide useful information, color codes etc.
Today we will learn how to make the chart legends smarter so that they provide more meaning and context to the chart, like this:
This type of legend can be more useful than a plain legend as this provides more useful information without taking up too much space.
Use CTRL+Click to speed up your formula entry [Quick Tips]
Sometimes we think there is very little we can improve in something and then we come across an idea that would change our perceptions. I have been writing excel formulas for such a long time that it was easier to remember when I first shaved than when I first wrote a formula. (may be, because […]
Automatic Rolling Months in Excel [Formulas]
Often when we are making spreadsheets for forecasting or planning we would like to keep the starting month dynamic so that rest of the months in the plan can automatically rolled. Don’t understand? See this example: This type of setup is quite useful as it lets us change the starting month very easily. We can […]
There are Easter Eggs in this Post!!!
It is Easter Time again. Although I am not in Scandinavia (where Easter is a big thing) any more, we have a rather biggish family gathering here at PHD household during this weekend. We are also having anna prashanam for the little ones. It is the ceremony we do in India when kids eat rice […]