TEXT Function in Excel: Format Dates and Numbers in Formulas
Use Excel’s TEXT function to format dates, numbers, percentages, times and leading zeros inside formulas, with a format-code cheat sheet and fixes for common mistakes.
Use Excel’s TEXT function to format dates, numbers, percentages, times and leading zeros inside formulas, with a format-code cheat sheet and fixes for common mistakes.
The Excel date functions you need at work: TODAY, DATE, EDATE, EOMONTH, NETWORKDAYS (including Friday–Saturday weekends), WORKDAY, DATEDIF for age and service, and WEEKDAY.
Look up a value based on two or more conditions with XLOOKUP: the boolean method, the joined-columns method, and FILTER for multiple results, plus an INDEX/MATCH version for older Excel.
Learn Excel’s UNIQUE, SORT, SORTBY and FILTER functions with simple examples: get unique lists, sort automatically, filter with multiple conditions, and fix the #SPILL! error.
Use ChatGPT, Copilot, Gemini or Claude to write, explain and fix Excel and Google Sheets formulas. Includes a prompt template, 8 ready-to-use prompts, and how to check the results.
Share Google Sheets the right way: viewer, commenter and editor access, link sharing, protecting ranges and sheets, expiry dates, and checking who has access.
Learn how to use IMPORTRANGE to pull live data from one Google Sheets file into another, allow access, combine it with QUERY, and fix common #REF! errors.
QUERY is the most powerful function in Google Sheets. Learn SELECT, WHERE, ORDER BY, GROUP BY, LIMIT and LABEL with easy examples you can copy into your own sheets.
Learn when to sort, filter, or use slicers in Excel. Step-by-step instructions for multi-level sorting, filtering by text, numbers and dates, the FILTER function, and slicers.
Create a chart in Excel in seconds, pick the right chart type for your data, and clean it up with 8 simple design tips so it looks professional in any report.