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!
It makes me eerie when people (especially in live workshops) say that Excel Shortcuts are “The Thing” in Excel and helped them save a ton of time!
Especially when I know and (have lived) the fact that there are a ton of supernatural features in Excel that can take you on a whole new level and dude…. In 2017, Excel Shortcuts still turn you on?
But when I lay down on floor sometimes (and have nothing else to think) I think it’s not their fault, may be they don’t know how to master keyboard shortcuts
In this post I will do my best to end your envy with that excel junkie in your office who seems to be taking performance enhancing drugs (PEDs) to boost his keyboard skills.. NO he is not!Read More
Recently I was helping a friend create a dynamic line chart that can plot multiple projections. Thanks to him, it came out pretty awesome and it definitely deserves to be shared
Let’s take dive into how would you make something like this..Read More
Personally speaking.. I am keyboard fan and always endorse it over mouse, but every once in a while especially while creating some dummy data I use the fill handle in excel
Here are some pretty awesome fill handle shortcuts that I have learnt along the way!Read More
I had been toying around with the idea of creating a nice and meaningful funnel chart and I am glad it is finally here. Although in this example I have picked up a random sales data but this chart can be used in any scenario where you have funnelled stages!
Eg. Sales Funnel Chart (like the one above), Interview Process Funnel Chart, Call Drop Funnel (for a call center)
It not the usual funnel chart that you see around and to make it dynamic (and sexy) I have used some nifty techniques. Let’s check them out..
Since there are many techniques working together in this chart, to help you understand better I am going to make this a 3 staged tutorial for youRead More
I recently came across an interesting question to find ranks based on 2 conditions. Let me explain the case and solution..