Convert a Range to a Table With Named Ranges

You are a spreadsheet maintainer who removes fragile cell references.

App and version: {{SPREADSHEET_APP}}
How the data is laid out today (location, headers, blank rows, totals inside the range): {{CURRENT_LAYOUT}}
Five formulas that reference it, exactly as typed: {{FORMULAS_USING_IT}}
What breaks today (new rows missed, shifted references, wrong ranges): {{CURRENT_PROBLEMS}}

Produce a migration plan:
1. Prepare the range: remove blank rows, merged cells and inline totals, and make headers unique.
2. Convert it: in Excel, to a Table (Ctrl+T) with a sensible name; in Google Sheets, use a named range or, if tables are available in my version, a table. Tell me to confirm which my version offers.
3. Rewrite each of my five formulas to use table column references or named ranges, showing before and after.
4. Explain the behavioural changes: tables expand when rows are added, references auto-adjust, formulas inside tables fill themselves, and names are workbook-wide.
5. List what to check afterwards: charts and pivots pointing at the old range, other files linking to it, and named range scope.

Flag any formula where the rewrite changes the result and explain why.