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!
Hello there, all you lovely and goodly people! Read this short story
The other day I was sitting with a friend helping him with some Recruitment Analysis Dashboard
Friend : Hey can we also see the demographics by position applied for ?
Me : (doing while I was saying it) So let’s add position in the Inputs Sheet and covert this into a Table, now let’s refresh our Pivot and add a slicer on Positions Field and apply our sexy formatting on it and stack it in our Dashboard!
Done! Dude check this now..
Friend : (with his jaw dropping) Man, you are fast. I love the speed
Sorry, I dint mean to brag at all :D. If you have stayed with me for a while you know this is easy, no brainer stuff.
Today let’s exchange some speed tricks and make each other a hell lot faster and to do that I need your help. Here is the plan!Read More
I called over my friend, Puneet Gogia from www.excelchamps.com (once again) to teach us how can we use VBA to copy a Chart from Excel to a PowerPoint PresentationRead More
Quick Recap of what happened yesterday!
Yesterday was Sunday (23 Apr) and I binged like a mad man. Blueberry Jam Cake, Salted Lentils, Stuffed Pranthas, Beer, Chicken, Ice-Cream, oh yes.. and the lunch was separate 😀
But I burnt this all.. How ?? I walked for an hour in a scorching summer evening holding my notorious Son (often found dancing on my head)
In less than 20% of my day’s time, I burnt all the junk that I ate throughout the day. Classic example of 80-20 rule
You’ll find a ton of real life (business) examples which abide by the 80-20 Rule. Let’s take an example of how would you perform 80-20 (a.k.a Pareto) analysis in ExcelRead More
Ranking is one of the very common aspects of data analysis. In this post you’ll not only learn how to rank data in excel but also apply some variations to your ranking criteria.
Let take a look 3 tricks for ranking data in ExcelRead More
Hello there lovely fellas!!
If you and I interact on the emails you know that a few days ago, I promised you a free course on Excel Chart. This course will teach you the basics of Creating, Editing and Formatting Charts in Excel
Here are some nifty details about this course!Read More