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!
The word ‘Class Interval‘ takes me back to the math class in school. Trust me, I had a tough time understanding Class Intervals and Frequency Distribution jargons. Several years later (now) when I finally believe I have understood its meaning and application, I want to keep it really simple for you and talk about 3 different ways to create it in Excel
All English and no Jargons.. promise!Read More
Quite often we have to get rid of background patches in the images that we use in our presentations. Let’s take an example of Goodly logo with a white background patch visible when placed on a grey box. Is there a way to remove that patch and have a clean logo?
Of course there is and I am going to be sharing 2 ways to do it..Read More
In Part 2 of Infograhic Charts, I’ll share with you to create this interesting infograhic in Excel. Here we have a single human icon, which dynamically gets filled depending on the value chosen in the drop down
Here is how it is created..Read More
The source of inspiration for this chart came when Shuttershock was charging me for downloading a similar infographic chart. I din’t buy, I am thrifty 😉 It helped me save a couple of bucks and also come up with a way to make an infographic chart in Excel
Let’s do this together! Shall we?Read More
The roots of this blog post come from the following conversation from one of my training sessions
Participant : “Chandeep, the other day I went with my wife to buy a new mobile number. Since my wife is a bit finicky about astrology, she requested the shopkeeper to show us mobile numbers totaling to 9. The shopkeeper, along with his dirty looks sent me a dump of numbers and asked me to do it myself”
Me : I was trying to come up with a formula while he sharing his ordeal of manually totaling up phone numbers
Let’s dedicate this blog post to that lady and to everyone else who needs a total of digitsRead More