Formulas & Functions

Use TEXTBEFORE and TEXTAFTER to split email addresses, codes, and labels at a delimiter in Excel, with older-version fallback formulas and a full verification checklist.

Use the TEXT function to create clean month and year labels from Excel dates while keeping the original dates available for calculations.

Learn lock formula cells fast with a practical Excel example, clear steps, and a quick verification check.

Use SORTBY to create a dynamic sorted view of Excel data while leaving the original table unchanged.

Create a dynamic list of unique values in Excel, remove blanks, and keep the result updated without using Remove Duplicates.

Use Excel’s FILTER function to return a dynamic list that updates automatically when the source data or criteria change.

Create a two-way Excel lookup with INDEX and MATCH to return the value at the intersection of a selected row and column.

Use SUMIFS to total one month of Excel data with reliable date criteria, then copy the formula across a monthly summary without missing records.

Count overdue tasks in Excel with COUNTIFS by testing the due date, completion status, and blank cells in one practical formula.

Build an Excel IF formula with AND and OR to test multiple conditions, return clear outcomes, and avoid unnecessary nested formulas.