Microsoft Excel Advanced - Functions And Formulas Jun 2026

| Category | Example Functions | What They Do | | :--- | :--- | :--- | | | XLOOKUP , INDEX/MATCH , INDIRECT | Find a value in a table and return a related value (better than VLOOKUP). | | Logic | IFS , SWITCH , AND/OR inside IF | Perform multiple conditional checks without nesting many IFs. | | Text | TEXTJOIN , TEXTSPLIT , REGEXEXTRACT | Combine or split text flexibly; extract patterns (new in 2024/2025). | | Math & Stats | SUMIFS , COUNTIFS , SUMPRODUCT | Sum or count based on multiple criteria across columns. | | Dynamic Arrays | FILTER , SORT , UNIQUE , TOCOL | Spill results automatically into multiple cells (Excel 365). | | Error Handling | IFERROR , IFNA | Trap and replace errors like #N/A or #DIV/0! . | | Date/Time | NETWORKDAYS.INTL , EDATE , DATEDIF | Calculate working days, shift dates by months, find age. |

: A cleaner alternative to nested IF statements, letting you test multiple conditions in a single, readable formula. Microsoft Excel Advanced - Functions and Formulas

Yes, is an excellent feature set to master. It represents the core difference between basic data entry and true data analysis/automation in Excel. | Category | Example Functions | What They

The syntax =IF(logical_test, value_if_true, value_if_false) is straightforward. However, the power lies in . | | Math & Stats | SUMIFS ,

CONCATENATE is rigid. TEXTJOIN is brilliant.