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!
Here are a few exclusive border shortcutsRead More
A while ago I wrote a post on how to use Advanced Filter? Today let’s delve further into a bit of automation of the advanced filter applicationRead More
Looking up pictures can be interesting and can possibly be used in different scenarios. Here is a quick sneak peak into how can you do a Picture Vlookup!!Read More
Sometimes you may have a need to create a dropdown list which should be dependent on another dropdown. For instance in the above example depending on the company that you choose (A, B or C) in the Company dropdown, the respective products appear in the products dropdown.
Trust me its not difficult but just a couple of logics combined together to make this dropdown pudding. Let’s do it.. Shall we?Read More
Here is a fun and also really quick way to replicate formatting in your chartsRead More