Case-Study-Recipe

Case Study 1 – Multi Choice Question-Answer Model in Excel

NOTE : There are many interlinked articles for separating basic lesson from this main article. View those links if you want to learn Basics. Hello Excel Modelers, Yes you heard it right. I am sure after going through this article thoroughly, you will gain a great insight on implementing various SIMPLE (simple if you know and […]

Sniping Tool

Snipping Tool – A hidden Treasure in your Windows OS

Hello Presentation Givers, If you give a lot of support/demo to clients through screenshot then this is the best tool for you to start using “Snipping Tool” instead of old “PrntScr” button. Snipping Tool is a screenshooting utility included in Windows Vista and later. It can take screenshots of an open window, rectangular areas, a […]

Dynamic Drop Down Excel

Dynamic Drop Down List Excel

Hey Excel Dynamic User, I am going to show you one very important technique to create a Dynamic Drop Down List Excelin cells (of course with data validation but with addition to function “INDIRECT”) with n number of dependency you can create. I have tried to make it shortest and easy to understand with 5 […]

Camera Tool Excel

Camera Tool Excel or Paste linked picture

Hey Excel Tricky presenters, I am glad that you are here to unlock the hidden feature in your Excel i.e. Camera Tool Excel. However in recent update there is similar command available which performs the same function as Camera Tool Excel, i.e. Paste as Linked Picture. We will cover both of this command with GIF […]

Subscribe for Newsletter