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.
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.
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.
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.
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.
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.
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 […]
In this tutorial, we will learn how can we use IF condition in excel. IF function is one of the logical functions in MS Excel. This function returns the result either True or False based on a condition. MS Excel 2021 is used.
In this tutorial, we will learn how to make a Pie chart in MS Excel. Pie chart is used to show the distribution of a data. It is in the form of a circle and is divided into slices to show numerical proportion. MS Excel 2021 is used.
Pareto chart is the combination of bar chart and line chart. The bar graph represents a values in descending order while line graph represents cummulative total of the values. MS Excel 2021 is used.
