Author name: David Gul

Use VLOOKUP to match order numbers, invoice IDs, or any lookup value across two spreadsheets. Step-by-step guide with examples and common fixes.

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

Fix extra spaces, inconsistent casing, text-formatted numbers, and mixed date formats from CSV and CRM imports using TRIM, PROPER, VALUE, and more.

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

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

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

Assign status labels automatically based on scores, dates, or multiple conditions. Nested IF, IFS, and lookup table approaches compared.

Make a second dropdown change its options based on the first selection using Named Ranges and INDIRECT. Step-by-step with screenshots.

Protect formulas and structure while letting users type in designated input cells. Step-by-step sheet protection setup with best practices.

Three methods to consolidate data from multiple sheets: Power Query, manual copy-paste, and VSTACK. Includes adding a source identifier column.