EXCEL
EXCEL
Embedded Files
· In the sheet ‘Retail_sales_dataset’ add all available data between columns A –N into a ‘table’
· In the sheet ‘Retail_sales_dataset’ add all available data between columns A –N into a ‘table’
· Using the Max, Min and Average function in cell 'R17, 18,19'
· Using the Max, Min and Average function in cell 'R17, 18,19'
· Using the ‘SUM’ function, show me the commission total in cell ‘R7’
· Using the ‘SUM’ function, show me the commission total in cell ‘R7’
· Using the ‘AVERAGE’ function, show me the average commission in cell ‘R10’
· Using the ‘AVERAGE’ function, show me the average commission in cell ‘R10’
· Total Revenue of all the products.
· Total Revenue of all the products.
This image is a snapshot of a pivot table and slicers from the ‘Retail_sales_dataset’
Sum of Total Sales: This table summarizes the sales percentages by gender (Female and Male) and product category (Beauty, Clothing, and Electronics), further broken down by age categories (adult, senior, and young adult).
For each category, the percentages for Female and Male sales are shown.
Slicers: At the bottom of the image, slicers are present for:
Gender: Filter data by Female or Male.
Category: Filter by adult, senior, or young adult.
Product Category: Filter by Beauty, Clothing, or Electronics.
In this project, I created a line chart for Revenue vs Profit, a bar chart to show the Revenue by Country and a pie chart to show comparisons between age groups.
In this project, I created a line chart for Revenue vs Profit, a bar chart to show the Revenue by Country and a pie chart to show comparisons between age groups.
The image shows a pivot table that summarizes sales percentages across different product categories—Beauty, Clothing, and Electronics—broken down by gender and age groups like Adult, Senior, and Young Adult.
The image shows a pivot table that summarizes sales percentages across different product categories—Beauty, Clothing, and Electronics—broken down by gender and age groups like Adult, Senior, and Young Adult.
This image provides valuable insights into consumer purchasing patterns, revealing how different demographics contribute to sales in each category. It's fascinating how pivot tables can turn complex datasets into actionable insights, helping businesses tailor their strategies to meet the needs of their customers more effectively.
This image provides valuable insights into consumer purchasing patterns, revealing how different demographics contribute to sales in each category. It's fascinating how pivot tables can turn complex datasets into actionable insights, helping businesses tailor their strategies to meet the needs of their customers more effectively.
Page updated
Google Sites
Report abuse