Yes, I created a report using Excel based on a dataset from a fictional company called Cosmetics Inc. The project began with cleaning raw sales data by removing duplicates, standardizing inconsistent formatting such as capitalization in product categories and handling missing values. Once the data was cleaned, I used Excel’s VLOOKUP function to match and pull in additional details, such as customer region information tied to specific sales entries. This allowed for a more comprehensive view of the data. I then created a PivotTable to summarize total sales by product category and region. This helped visualize which products were top performers in different markets and included filters for product names and regions. Overall, the report significantly improved data clarity and provided valuable insights for evaluating product performance and regional trends.

I have strong experience completing high-level Excel analysis. I'm skilled in cleaning and organizing large datasets using functions like TEXT, TRIM, FIND/REPLACE, and Power Query to ensure the data is accurate and structured properly for analysis. I also use advanced tools like pivot tables, VLOOKUP, CONCATENATE, and conditional formatting to draw insights. I’m confident using Excel for both detailed data preparation and high-level analytical work that supports better business decisions.

Honestly, I don't know much about the Barksdale product lines though I do know that Barksdale is a leading brand in manufacturing highly engineered control products. By manufacturing pressure, temperature, level, and flow control devices, companies across different industries can optimize operations and drive their productivity.