Buy and Sell Analysis in Excel | Breakdown Alert, Status, History and Forecast скачать в хорошем качестве

Buy and Sell Analysis in Excel | Breakdown Alert, Status, History and Forecast

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵FREE EXCEL SPREADSHEET DOWNLOAD: https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we will learn how to perform a purchase and sales analysis in Excel using a purchase spreadsheet or a sales spreadsheet to forecast and analyze stockouts, see the months that sold the most, see if the analyzed products or the customers or suppliers follow a pattern of purchase volume and sales volume. In Excel, we can perform several interesting analyses, for example: If the purchase volume matches the sales Step 1: Have standardized columns in both spreadsheets (Purchases and Sales), such as Product, Date, Quantity. Step 2: Create a PivotTable consolidating the data from both spreadsheets to compare the quantities purchased vs. sold. Step 3: Use the SUMIF() or SUMPRODUCT() function to calculate the difference between the volumes. --- If each product maintains a stable sales volume Step 1: Use a PivotTable to see the evolution of sales by product, segmented by month. Step 2: Create a line graph for each product and see if there are fluctuations. Step 3: Use the STDEV() formula to measure the variation in volumes. --- If each customer maintains the same purchase volume Step 1: Create a PivotTable with the columns Customer, Month and Quantity Sold. Step 2: Use a trend graph to analyze if there are decreases or increases in the purchase volume. Step 3: Calculate the average and standard deviation of purchases to see if there are variations. This generates an alert if there is a drop of more than 20% or an increase of more than 20%. If each supplier maintains the same sales volume for me Step 1: Create a PivotTable with the columns Supplier, Month and Quantity Purchased. Step 2: Use a stacked column chart to visualize changes in supply. Step 3: Compare periods using SUMIFS(). This shows the difference in a supplier's purchase volume between two months. #ExcelenteJoão #Excel #Dashboard