How to Create a Risk Matrix in Excel

  A risk matrix is used to determine the risk in numbers using the impact and possibility index. Impact, possibility or certainty index ca...

Lookup From Variable Tables Using INDIRECT

If you have multiple excel tables and you want to do a dynamic VLOOKUP Function from these tables, you will need to use the INDIRECT function. In ...

How to Lookup From Variable Sheets in Excel

Imagine you have multiple identical sheets in a workbook that contains identical tables (like attendance records of each month in a separate sheet). N...

How to calculate win lose points in Excel

In this article, we will learn How to calculate win-lose points using the VLOOKUP function in Excel. Scenario: Win or Lose are the results o...

How to get currency conversions calculator in Excel

In this article, we will learn How to get a currency conversion calculator in Excel. Scenario : Generally, we come across situations where we ...

How to lookup exact match using SUMPRODUCT function in Excel

In this article, we will learn How to look up exact matches using the SUMPRODUCT function in Excel. Scenario: In simple words, while working...

How to use the AREAS Function in Excel

In this article, we will learn how to use AREAS Function in Excel. AREAS function is a reference function which returns the count of area referenc...

Terms and Conditions of use

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.