Excel Projects

Excel Skills

Used advanced formulas including INDEX/MATCH, IFERROR, and XLOOKUP to dynamically retrieve and clean data
Created interactive dashboards using pivot tables, slicers, and named ranges for self-serve reporting
Built custom KPI trackers with conditional formatting and dynamic charts
Automated repetitive tasks and workflows using Excel macros and VBA scripting
Performed trend and outlier analysis using built-in functions like AVERAGEIFS, COUNTIFS, and STDEV.P
Used Power Query for advanced data cleaning, merging, and reshaping
Linked Excel to external data sources (CSV, SQL Server, web APIs) for live data updates
Applied structured referencing and Excel Tables for scalable models
Used TEXT, LEFT, RIGHT, LEN, and CONCAT for text manipulation and data transformation
Created dynamic date-based reports using EDATE, MONTH, and TODAY()
Built Excel calculators and simulators for business decision support
Applied data validation and dropdown lists for user-friendly input control
Designed dashboards optimised for both desktop and printable formats
Ensured model transparency with consistent formatting, documentation, and error handling

This section showcases how I’ve used Excel to build custom tools, automate reporting, and visualise performance KPIs in a business context.

Tools: Excel, Power Query, Pivot Tables, Conditional Formatting
Key Topics: Reporting automation, KPI tracking, spreadsheet modelling
Example Use Case: Created a dynamic quoting tool in Excel for Utility Warehouse, replacing a broken internal system
Goal: Improve pricing accuracy, streamline quotes, and reduce customer complaints