Author name: David Gul

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.

Reference cells in closed workbooks using file-path formulas, VLOOKUP across files, and Power Query. Three methods with broken link management.

Extract invoice numbers, SKUs, zip codes, and other values from mixed text using LEFT, MID, RIGHT, FIND, Flash Fill, and TEXTAFTER.