Excel Formulas

Here, we will learn how to calculate the total days left in the given month using the Excel EOMONTH and DATEDIF functions in one formula.

Here, we will learn how to use the Excel logical function: IFERROR. Later, we will also learn how to perform multiple XLOOKUPs to SUM with the IFERROR function.

Here, we will learn how to filter and exclude columns using the Excel SORT, TAKE and CHOOSECOLS functions in one formula.

Here, we will learn how to convert horizontal data to vertical using the Excel WRAPCOLS and TOROW functions in one formula.

Here, we will learn how to combine multiple lists into a single list using the Excel WRAPROWS and TOCOL functions in one formula.