Objective: Learn how to perform sales forecasting in Excel using historical data Dataset Overview: Use the 'invoice date' and 'price' columns from the dataset. For simplicity, let's aggregate the sales data by month to forecast monthly sales. Assignment Steps: Prepare the Data: Open your Excel workbook with the imported file provided Create a new sheet or table to summarize sales data by month. Use the SUMIFS function to sum the 'price' for each month. Ensure your sales data is sorted in chronological order. Create a Time Series Chart: Highlight your summarized monthly sales data and insert a line chart to visualize the sales trend over time. This step helps in understanding the data pattern before forecasting. Use Excel's Forecast Sheet Feature: Select your monthly sales data. Go to the "Data" tab on the Ribbon, and click "Forecast Sheet" to open the forecast dialog. Choose a line chart or a column chart for your forecast. Set your forecast end date. For practice, forecast the next 12 months of sales. Excel will automatically generate a forecast based on your data, using the Exponential Smoothing (ETS) algorithm