Excel sheet reconciliation

Automating weekly Excel report reconciliation through effective formula usage. The core task involves reconciling numbers across spreadsheets on a weekly basis through manual data entry and calculations. The goal is to enhance efficiency and reduce redundancies by leveraging Excel's powerful functionalities like SUMIF, COUNTIF, VLOOKUP etc. Experience with advanced formulas, Pivot Tables and automation through Macros is required. Bidders should detail process of analyzing current manual steps and improving it through formula-driven approach to automatically fetch, calculate and reconcile data with minimal human intervention weekly. Knowledge of best practices for task repetition and automation in Excel will be an added advantage. Important note is that my laptop is protected by company so I cannot use Copilot in my laptop.