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
Here is a fun challenge for this weekend. Recently I was asked a question that if I could separate the data from a single cell in different columns?
Sure enough I did that but I wanted to figure out if there was an even smarter way to do thatRead More
Have you ever used a regular item for a non regular use? Let’s say using a bangle for opening a bottle of coke or tapping a tea spoon for making noise 😆 Funny indeed but these fixes at times are pretty robust.
On a similar note, let’s take a look at how can you unusually use Data Validation drop down feature for creating ON/OFF (show/hide) switches for your Charts / CalculationsRead More
There are ton of ways to work faster in Excel and often the little nick-nacks take more time than other things. I am sure that there is no end to the available shortcuts in Excel but for now let’s take a look at a few most commonly done little tasks in excel and ways to do them a lot fasterRead More
Last week I participated in Chandoo’s Visualization Challenge, where we were given some raw data and had to make a meaningful visualization (Dashboard) out of it. In this post I am going to share everything about how I went along in creating this dashboard.Read More
Every once in a while I make a timeline in PowerPoint to show how the tasks are scheduled over time. I thought it would be nice to have a template in Excel where I just add events and dates and the chart is created by itself.
So today it is time for a short tutorial on a timeline chartRead More