Excel Data Entry & Comparative Analysis

I have several existing Excel sheets that need to be cleaned up, completed, and aligned so that I can run a clear comparative analysis across them. The assignment covers “all data analysis and entry,” meaning every column, note, or irregular figure in the files must be checked, corrected where necessary, and documented.

Once the data is reliable, I need a concise comparative analysis that highlights key differences and similarities between variables, periods, or categories (depending on what the cleaned dataset reveals). I am comfortable with a straightforward approach—well-structured tables, pivot charts, or any other Excel-native methods—provided the insights are easy to read and ready for decision-making.

Please deliver:
• A fully cleaned, de-duplicated master workbook
• A separate worksheet (or dashboard) that presents the comparative analysis with clear visuals and summary metrics
• A brief written explanation of your methodology and any notable findings

Fluency in advanced Excel functions (Power Query, Pivot Tables, LOOKUPs) will make the job faster, but use whichever tools you prefer as long as the final output remains in Excel format and is reproducible on my end.