Excel Expert (Mississauga)

Excel Expert – Refactor & Fix 13‑Sheet Master Costing Workbook (NDA Required)

Project Summary

Seeking an experienced Excel specialist to refactor, validate, and document a 13‑sheet Master Costing workbook. Work includes updating row/line‑item descriptions, adding rows, repairing and re‑linking formulas across sheets, resolving errors, improving performance, and ensuring all totals/math reconcile. This is a confidential project – NDA required.

Key Responsibilities

• Review supplied sanitized workbook and identify structural/formula issues.
• Revise row/line item descriptions and add rows where required, ensuring dependent formulas update correctly.
• Repair, simplify, and re‑link formulas across sheets so all calculations tabulate correctly (no #REF/#VALUE errors or unintended circular references).
• Convert ranges to structured Tables and/or named ranges where appropriate to improve reliability.
• Improve performanc...