Multiple ways to change text case in Excel

In this article, we will learn Multiple ways to change the text case in Excel. Scenario: Working on text columns like names column or addres...

Top Excel Interview Questions and Answers

In this article, we will learn what are the Top Excel Interview Questions and Answers. Scenario: The most commonly asked Microsoft Excel Int...

How to COUNTIF with non-contiguous range in Excel

In this article, we will learn How to COUNTIF with non-contiguous range in Excel. Scenario: COUNTIF counts cells on the basis of matched...

How to Find and Replace Multiple Values in Excel

In this article, we will learn How to Find and Replace Multiple Values in Excel. Scenario: We know how to find and replace a single item in ...

Learn different ways to remove duplicates in Excel

In this article, we will Learn different ways to remove duplicates in Excel What Is A Duplicate Value? Duplicate values happen when the same val...

Matrix properties and matrix calculations in Excel

In this article, we will learn How to use matrix and matrix calculations in Excel. Scenario A computer spreadsheet is a series of small bloc...

How to use different types of Regression in Excel

https://docs.google.com/document/d/1A1HKOuZvzJ2qhrjdvwzaNhBuAVEKRImsghlRPIUYPxg/edit?usp=sharing...

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.