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!
I thought of recording a quick video for a random chat and show you around my workplace. Since we may or may not have met, just wanted to say a quick HI 😉Read More
With the default sorting option you can sort the data (text, numbers, dates etc..) in ascending/ descending or alphabetical order but what if you want to have your own sorting criteria?
In that case Custom Sorting comes to rescue, this little trick can help you save countless hours of manual work
Let’s check it outRead More
Here is a fun challenge for this weekend. Recently I was asked a question that if I could separate the data from a single cell in different columns?
Sure enough I did that but I wanted to figure out if there was an even smarter way to do thatRead More
Have you ever used a regular item for a non regular use? Let’s say using a bangle for opening a bottle of coke or tapping a tea spoon for making noise 😆 Funny indeed but these fixes at times are pretty robust.
On a similar note, let’s take a look at how can you unusually use Data Validation drop down feature for creating ON/OFF (show/hide) switches for your Charts / CalculationsRead More
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