Excel Tips

Four methods to split full names into separate columns: formulas, Flash Fill, Text to Columns, and handling middle names and suffixes.

Use conditional formatting to automatically color-code overdue (red), approaching (yellow), and on-track (green) items based on due dates.

Three methods to find and remove duplicate rows based on specific columns in Excel. COUNTIFS flagging, concatenation keys, and the built-in Remove Duplicates tool.

Six methods to convert text dates to real Excel dates. Covers YYYYMMDD, DD/MM/YYYY, dot separators, date-time stamps, and mixed formats.

Turn hundreds of daily transactions into an auto-updating monthly summary using SUMIFS, COUNTIFS, and AVERAGEIFS. Includes Pivot Table alternative.

Use NETWORKDAYS to count working days excluding weekends and holidays. Includes WORKDAY for due dates and custom weekend schedules.

Build running totals that accumulate within each month and reset on the first of the next month. Two formula approaches plus category breakdowns.

Calculate percentage change, year-over-year growth, and CAGR correctly in Excel. Handles zero baselines, negative numbers, and visual indicators.

Use CONVERT for weight, distance, and temperature. Build rate tables for currencies. Format phone numbers, pad zeros, and handle mixed-unit columns.

Three ways to count distinct values: UNIQUE+COUNTA for Excel 365, SUMPRODUCT for all versions, and Pivot Table Distinct Count.