In this article, we will learn about how to Link references with another workbook in Excel. Why do we need to access another workbook? Somet...
In this article, you will learn how to highlight the most recent date in the range. We will use Conditional formatting option along with MAX funct...
Option button or Radio button is used to choose the predefined option from the multiple options. For example: Male or Female? English or Hindi? Yes...
Here are the links where you can find more Shortcuts:- 250 Excel Keyboard Shortcuts 150 Mac Keyboard Shortcuts 10 Most Useful Keyboard Shortcuts S...
In this article, we will learn how to use Goal Seek function in Excel 2016. Goal Seek function is a tool of What-if-analysis used to get the desire...
Q21. What is Countif function and how to use it? Answer: We use Countif function to count the specified cells, with a given condition or criterion....
Q11. Is it possible to make Pivot Table using multiple sources of data? How? Answer: Yes, this is possible by using data modelling technique. St...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
