Excel Functions

Here, we will learn how to use the Excel dynamic array function: SORTBY. Later, we will also learn how to reverse the table using SORTBY and the COLUMN function.

Here, I will discuss about Excel IF and SWITCH functions and how to use them with the VLOOKUP function.

In Excel, to change the case of text, you can use the UPPER, LOWER, PROPER and sentence case functions.