Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...
Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...
Generally, we are only use maximum "30 formulas" in our day to day routine. let's explore with below formulas and let me know which one is your favorite. Vlookup If Iferror Sum Count Sumif Countif CountA Index Match Left Right Mid Tri...
Purpose: Get a random number between 0 and 1. Return Value: Any decimal number between 0 and 1. Syntax: =RAND() Usage: RAND() function will returns a number between 0 and 1. For example, = RAND()...
A business intelligence (BI) dashboard is a data visualization tool that consolidates and displays the current status of metrics and key performance indicators (KPIs) for an organization, department or...