Categories
Excel

Use SUMIF function in Excel

In this tutorial, we will learn how to use SUMIF function in MS Excel. This function adds the values in a range that meet a specified criteria or condition.

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.

Categories
Excel

Highlight cells using Conditional Formatting in Excel

In this tutorial, we will learn how to highlight cells using Conditional Formatting. Conditional Formatting is based on a specified condition, when that condition is true, the appearance of the cell changes. MS Excel 2021 is used.

Categories
Excel

Use AND function in Excel

In this tutorial, we will learn how to use AND function in Excel. AND function is a logical functions that checks if all the conditions in the arguments are true. MS Excel 2021 is used.

Categories
Excel

Use Nested If function in Excel

In this tutorial, we will learn how can we use Nested If function. Basically, we use a function as the argument of another function which we refer to as nesting and the function is Nested function. For this tutorial, we will make a grading system using Nested IF function. MS Excel 2021 is used.

Categories
Excel

Generate random numbers in Excel

In this tutorial, we will learn how to generate random numbers in Excel. RAND() and RANDBETWEEN() can be used to generate random numbers. MS Excel 2021 is used. For this tutorial, we will be using RAND function and RANDBETWEEN function. RAND() :This function returns a random real number between 0 and 1. RANDBETWEEN(bottom, top): This […]

Use SUMIF function in MS Excel