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 […]

Share
All About "Named Ranges" in Excel

All About “Named Ranges” in Excel

Hello Super Excel Users, In this post I am going to cover every aspect of Named Ranges. What is a named range? Cells are generally named for a column and row that intersect, like A1 or C3. A range of cells is indicated by the colon between the beginning and ending cell of the range, […]

Share
Access Rights in Excel

Access Rights configuration for users in Excel

Hello Secretive Excel Users, Have you ever wanted to give access to only particular worksheets to some user and hide some worksheets for particular user. Below is the perfect solution you would like to implement. First in step by step with screenshots. Later in Video. Step 1 Create a worksheet called “Access Rights” as below […]

Share
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 […]

Share
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 […]

Share

How to create drop down in Microsoft Excel?

Hello Excel Lovers, In this animated GIF below, I have shown how to create drop down list in cells in Microsoft Excel with Data Validation Function. Share your views on this trick and how it helped you at your work in comments! To Subscribe to the courses go to Courses page and be effective user […]

Share

Subscribe for Newsletter