Reverse table using Excel SORTBY function
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.
Excel IF, AND, OR, NOT, TRUE and FALSE functions
Here, we will learn how to use the Excel logical functions: IF, AND, OR, NOT, TRUE and FALSE functions. Later, we will also learn how to construct the IF AND OR statement.
Excel IF and SWITCH functions with VLOOKUP
Here, I will discuss about Excel IF and SWITCH functions and how to use them with the VLOOKUP function.
Excel UPPER, LOWER, PROPER and sentence case functions
In Excel, to change the case of text, you can use the UPPER, LOWER, PROPER and sentence case functions.
Find last column number and convert to letter in Excel
In Excel, to find the last column number in the range and then convert the number to column letter, you can use the MIN, COLUMN and COLUMNS functions and nest the formula in the SUBSTITUTE and ADDRESS functions.
- Go to the previous page
- 1
- …
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- …
- 16
- Go to the next page