Jon Lazo

I help business owners and teams make sense of their data. Leveraging a degree in Science Education and a structured analytical approach, I don't just calculate numbers; I transform raw, messy spreadsheets into clean datasets, interactive visual summaries, and clear business takeaways in fluent C1 English.

Core Technical Capabilities:
Spreadsheet Mastery (Excel; Google Sheets): Advanced lookup formulas (`XLOOKUP`, `INDEX/MATCH`, `VLOOKUP`), conditional logic, formulas, and collaborative cloud workflows.
Data Cleaning; Quality Control: Power Query transformations, text/number standardization, missing record handling, and Data Validation rules to eliminate errors.
Dashboards; Visualization: Dynamic Excel dashboards using Slicers, Pivot Tables, and Pivot Charts for real-time tracking.
*Data Storytelling; KPI Summaries:* Translating complex metrics into clear, easy-to-understand written executive summaries and key bullet points for decision-makers.

Whether you need a messy spreadsheet overhauled, an interactive reporting dashboard, or a clear visual summary of your operational metrics, I deliver structured, logical, and easy-to-use solutions.