Recent Posts

Here, we will learn how to use the Excel information function: ISERROR. Later, we will also learn how to compare data with errors using ISERROR with the IF function.

Here, we will learn how to use the Excel text function: SUBSTITUTE. Later, we will also learn how to sum cells with text and numbers using SUM with the SUBSTITUTE function.

Here, we will learn how to use the Excel text functions: CHAR and CODE. Later, we will also learn how to generate capital and small letters.

Here, we will learn how to use the Excel logical function: SWITCH. Later, we will also learn how to extract country from phone number using SWITCH with the LEFT function.

Here, we will learn how to use the Excel dynamic array function: DROP. Later, we will also learn how to extract the last n rows using DROP and the ROWS function.