Excel

Workbook Overview

Data-Workbook-1-Excel.docx captures foundational Excel proficiency from the JustIT bootcamp, started December 2024. Tasks span Days 1-4, covering data protection laws, retail sales manipulation, bike sales pivots, SWITCH categorization, and executive presentation prep.​

Key Skills Demonstrated

• Compliance Knowledge: Detailed explanations of Data Protection Act, GDPR (fines up to 4% revenue), Freedom of Information Act, and Computer Misuse Act, with real-world examples like secure customer data handling.​

• Data Manipulation: Converted ranges to tables, sorted by age, calculated SUM/AVERAGE commissions on retail-salesdataset.xlsx.​

• Pivot Tables & Formulas: Analyzed Day3Task1BikeSalesPivotLab.xlsx for markets like Germany's Nordrhein-Westfalen (top sales) and UK (all segments); used SWITCH for sales volume categories (High >600, Medium 300-600, Low <300).​

Analysis Highlights

Identified California as most profitable (35-64 demo), France leading under-25 profits, and South Australia as lowest. Built visuals for board delivery, recommending PowerPoint for static charts and prospecting for audience relevance.​​

Career Impact

This workbook proves production-ready Excel for ETL, reporting, and stakeholder communication, bridging to Python/SQL/Power BI projects. Seeking Liverpool data roles—contact benjamincaseyfletchergmail.com.​