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
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
Even if you have no idea what is custom formatting, these tricks will help you win over some common formatting needs for your dataRead More
Recently I conducted a survey, to find out what are your pain points while using Excel in everyday work. I found that a majority of us struggle with writing Excel Formulas. Hmm… So I spent a few days recording ex-plainer videos for about 100 most used functions in Excel.
I have explained each formula
As of now I have completed about 40 of the 100 videos and will wrap the remaining in a few days. AND YOU MUST BOOKMARK THIS PAGERead More