Excel Skills
Excel Skills
Data Cleaning and Preparation: Skilled in handling large datasets, removing duplicates, filtering, sorting, and formatting for analysis.
Formulas and Functions: Proficient in using essential functions like VLOOKUP, IF, SUMIF, COUNTIF, TEXT, CONCATENATE, LEFT, RIGHT, MID, and logical formulas.
Pivot Tables & Pivot Charts: Experienced in summarising and visualising data using pivot tables and pivot charts for reporting and insights.
Data Analysis: Able to analyze trends, compare variables, and build dashboards using charts and conditional formatting.
Dashboards and Visualisation: Designed interactive Excel dashboards using charts, slicers, and conditional formatting for real-time analysis.
Data Validation & Error Checking: Utilised tools such as data validation, named ranges, and error tracking to ensure data integrity.
My Excel Project
This dataset provides a comprehensive view of retail sales transactions, customer demographics, and product performance across various categories. It is structured to support analysis of sales trends, customer behavior, and commission structures.
This dataset contains detailed sales records for mountain bikes across multiple countries. It includes customer demographics, product details, and financial metrics. The file is designed to support pivot table analysis and Excel-based data exploration.