Categories
Excel

Switch Rows and Columns using TRANSPOSE in Excel

In this tutorial, we will learn how to use TRANSPOSE function and copy, paste & transpose to switch rows and columns.

Categories
Excel

Use SUM function in Excel

In this tutorial, we will learn how to use SUM function in Excel. This function is used to add all the values in the range cells. You may add individual numbers, cell references, ranges or combination of all three. Microsoft Excel 2021 is used.

Categories
Excel

Use SWITCH function in Excel

In this tutorial, we will learn how can we use SWITCH function in excel, this function is used, switch function checks the value of a cell against another value and returns a corresponding value.

Categories
Excel

Use IFS function in Excel

In this tutorial, we will learn how to use IFS function in excel. IFS function checks whether one or more conditions are true, and returns a value on a first corresponding True condition. IFS function can be used in the place for nested IF functions. Rather than using multiple if functions, IFS function can be used. Microsoft Excel 2021 is used.

Categories
Excel

Use AND function and IF function in Excel

In this tutorial, we will learn about the AND function, and how it is used with the IF function. The AND function only returns the value True or False, but with the IF function it can return the value of our choice. AND function will be nested in IF function. Microsoft Excel 2021 is used.

Use SUMIF function in MS Excel