Hi, My name is Chandeep!
Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel
Let me get you started by sending you smart ebooks on Excel and Powerpoint!
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
Take a look at this case and think about how are you going to solve it without using IF / AND or any other Logical function