Microsoft Excel

I have a comprehensive understanding of key Excel functions and tools. My skills include pivot tables for data summarisation and XLOOKUP for advanced lookups, as well as commonly used functions like COUNTIF and SUMIFS for conditional calculations. I also effectively use CONCATENATE for combining data, and TEXT functions like TRIM and SUBSTITUTE for cleaning datasets. In addition, I leverage conditional formatting to highlight trends and charting capabilities to visualise insights. Furthermore, I develop interactive dashboards that combine these tools to present data-driven solutions and insights.

Please find my Excel projects below:

Pivot Tables + Dashboards
Bike Sales Data

Bike Sales Dashboard

KEY SKILLS: IFS, Bar Charts, Line Charts, Pivot Tables, Slicers and Dashboards

The project above delves into cleaning data from bike sales data to present an interactive dashboard with slicers allowing for an in-depth comparision of consumer buying habits.

Data Cleaning
Presidential Data

KEY SKILLS: TRIM, PROPER, Filter, Fixing Dates and Removing duplicates

The project above delves into cleaning data from a fictional presidential campaign to display adjusted names, presidential parties, and salaries effectively and accurately.