Ms Excel tutorial- Advanced Excel- Excel for beginner

  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 of id

  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 literally run through a hundred steps with just one