Contact Us

Comments

New comments are not allowed.

Popular posts from this blog

How to create a Macro Button in Excel?

  How to create a Macro Button in Excel? How to insert button in Ms Excel? MACROS IN EXCEL -  https://youtu.be/tvw6rPbJHtc If you have tasks in Microsoft Excel that you do repeatedly, you can record a  macro  to automate those tasks. A  macro  is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. Follow this link to get worksheet used in the tutorial: https://drive.google.com/file/d/1JAqx1ADxHbhPcOHNhS1dDiyYXRfkY7a3/view?usp=sharing # Some important point to remember before creating a Macro- ∆ If you want to save macros, then you must save your workbook in a macro-enabled format *.xlsm ∆ The macro name should not contain any spaces. ∆ Always fill in the description of the macro when creating one. This will help you and others to understand what the macro is doing. MACRO BUTTONS Macros make life easier. Buttons make life easier.  You can literal...
Read more

How to create Multiple Dependent Dynamic Drop-Down List in Excel ?

Image
  How to create Multiple Dependent Dynamic Drop-Down List in Excel ? DYNAMIC DROP-DOWN LISTS IN EXCEL A drop-down list is an excellent way to give the user an option to select from a pre-defined list. Worksheet used in the video: https://drive.google.com/file/d/1lrXvpWaaqtKwtjKo4mSJTPYsB3vow1TH/view?usp=sharing A drop-down list that is dynamic, can expand or contract depending on changes to the source data. Learn how to create a drop-down list in a cell using the new UNIQUE function to make the list dynamic. UNIQUE FUNCTION UNIQUE is a Dynamic Array Formula that returns all the unique values from a data range. In other words, it removes duplicates from a data set. Learn how to create a drop-down list in a cell using the new FILTER function to make the DEPENDENT Drop-down list dynamic. FILTER FUNCTION The Excel FILTER function returns a range filtered on criteria you define. It can also handle multiple AND/OR criteria. Note- In the SOURCE FIELD(of Data Validation), Instead o...
Read more

Vlookup with match function in Excel

 Vlookup with match function in Excel VLOOKUP FUNCTION IN MICROSOFT EXCEL VLOOKUP FUNCTION STANDS FOR VERTICAL LOOKUP. It looks for a value in the leftmost column of a table. It has four components: 1. VALUE - The value you want to lookup from your table. 2. RANGE- The range in which you want to find the value. 3. COLUMN NUMBER- The number of column within your defined range, that contains the return value. 4. TRUE or FALSE- False or 0 means Exact match and True or 1 means approximate match #Different ways of using Vlookup function in excel https://youtu.be/CmowjVmGRiw #Match Function in MS Excel https://youtu.be/yRy_AdWXeIg Follow this link to get worksheet used in the video- https://drive.google.com/file/d/1XotTUZ7uZt9oPqQUYA28gEOEXQ_Phcj5/view?usp=sharing MATCH FUNCTION IN EXCEL Learn Match Function in Excel with the help of examples. The MATCH function searches for a specified item in a range ...
Read more