Excel Functions

Here, we will learn how to use the Excel dynamic array function: TAKE. Later, we will also learn how to remove the last n rows using TAKE.

Here, we will learn how to use the Excel dynamic array function: TEXTSPLIT. Later, we will also learn how to find average, sum, max, min and count using TEXTSPLIT with the AVERAGE, SUM, MAX, MIN & COUNT functions.

Here, we will learn how to use the Excel logical function: IFS. Later, we will also learn how to assign a grade based on the given score using IFS with the RIGHT and VALUE functions.

Here, we will learn how to use the Excel text functions: UNICHAR and UNICODE. Later, we will also learn how to generate circled numbers/alphabets.

Here, we will learn how to use the Excel text function: MID. Later, we will also learn how to separate each letter of text using MID with the COLUMN function.