Data Analysis

Demonstrating real-world data analysis using Google Sheets and Excel, with a focus on accuracy, reporting, and process efficiency | Skills directly transferable to finance and accounting.

Line chart showing reduced photography and editing times, reflecting continuous improvement.

Comparison of weekly vehicle volumes across sites, used to identify patterns and balance resources.

Cross-branch analysis showing variations in efficiency to support resource planning.”

Workflow

Average vehicles photographed per day each week, providing insight into workload capacity and helping optimise workflow planning.

The data itself

Advanced Excel Formulas

Using formulas to automate calculations, improve accuracy, and analyse large data sets for better decision-making.

Detailed tracking spreadsheet with 400+ entries so far, ensuring accuracy and up-to-date records through checkbox validation.

Precision

Consistent data entry and tracking, ensuring accuracy for performance monitoring and process improvement.

Formula for converting car registration year to actual month and year of registration