I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations
I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog
Last week I reached out to a few readers asking them if they are struggling with anything in Excel. One of the readers (Malclom) wrote a very interesting problem about finding shift timings
Let’s see if you can knock it down! Ready for it?Read More
The other day while helping someone out to create a visualization from a performance rating data, I thought of creating a Dot Chart, where dots get filled depending on the score. I really liked what finally came out and thought it would be of much use to you as well!
So, here we go !Read More
Today let me share with you 16 gold nuggets that will help you save your time while crunching numbers with pivot tables! Excel hacks are equivalent to gold nuggets for people like us.. aren’t they? Lets get startedRead More
Often a wrong type of a chart for your data won’t communicate the right message. Charts are made for easier & faster interpretation of data and a wrong chart can do the opposite
I wanted to pour my heart out to help gain the skill of picking up the right chart. I suggest you should bookmark this because I am going to make this pretty comprehensive and awesome!Read More
In this tutorial I am going to take you through a funnel chart visualization. Surprisingly this visualization is not any type of a chart rather it is made up of formulas that have been smartly formatted make it look like a chart.
Let’s get into it!Read More