Tag: Excel

  • Sales analysis

    Sales analysis

    I need a detailed sales analysis for our e-commerce in Excel. The database contains the following columns: Sale Date, Product, Category, Unit Price, Quantity Sold, Total Revenue, Region, and Payment Method. Please apply the following analyses:**

    1. Monthly summary: Generate a monthly sales chart totaling the Total Revenue for each month.
    2. Analysis by product category: Create a pivot table showing Total Revenue and Quantity Sold by Category.
    3. Top 10 products: Generate a list of the top 10 best-selling products (by quantity) and their corresponding Total Revenue.
    4. Regional analysis: Display a pie chart showing the percentage of Total Revenue by Region.
    5. Most used payment method: Show the percentage of each Payment Method used in total sales.
    6. Price trends: Perform an analysis to check if there is a correlation between Unit Price and Quantity Sold, applying a correlation formula.
    7. Sales forecast: Use the Excel trend forecast function to estimate sales growth for the next three months based on historical data.

    Rating: 1 out of 5.