Excel
9 articles tagged Excel.
Excel FILTER Function With Multiple Criteria, Sorted With SORT and SORTBY
Filter Excel data on several conditions with FILTER, keep only the columns you need, and sort the result with SORT and SORTBY, with fixes for #CALC!, #SPILL! and #VALUE!.
Office Scripts: Automate a Weekly Excel Report With Power Automate
Write an Office Script that totals last week's sales by region, writes a formatted summary sheet and returns the figures to a scheduled Power Automate flow that emails them.
Remove Duplicates and Count Unique Values in Excel: 5 Methods That Work
Remove duplicate rows, list unique values and count them in Excel with Remove Duplicates, Advanced Filter, UNIQUE, COUNTIF and a PivotTable Distinct Count.
Split and Combine Text in Excel With TEXTSPLIT and TEXTJOIN (Examples)
Split cells into columns or rows with TEXTSPLIT, pull out names and email domains with TEXTBEFORE and TEXTAFTER, and join lists with TEXTJOIN, with fixes for common errors.
XLOOKUP vs VLOOKUP in Excel: Differences and Formulas With Examples
Compare XLOOKUP and VLOOKUP on one sample table, with copy-paste formulas for exact, left, approximate, wildcard and two-criteria lookups, plus fixes for common errors.
Automate Overdue Invoice Reminder Emails with Power Automate
Build a scheduled Power Automate flow that reads an Excel table of invoices, finds overdue unpaid ones, emails reminders through Outlook and logs each reminder to avoid duplicates.
Clean Messy Spreadsheet Data with AI in Excel and Google Sheets
Use Copilot in Excel, the Google Sheets AI function, TRIM and Flash Fill to tidy and categorise messy data, with a checking routine and the limits to know.
Power Automate Desktop for Beginners: Automate a Repetitive Task
Install Power Automate for desktop, record and edit your first desktop flow, use the Excel actions, and learn what you need before running it from the cloud.
Power Automate Scheduled Flow: Send a Daily Report Email from Excel
Build a scheduled cloud flow that reads rows from an Excel table, formats them as an HTML table and emails the report every weekday morning.