월별 판매 실적 추적하기
이 튜토리얼은 초보자가 월별 판매 실적을 목표와 비교하여 모니터링하기 위한 간단한 판매 추적 스프레드시트를 만드는 데 도움을 줍니다.
3 uses
0 likes
1. Open Excel and create a new spreadsheet titled 'Monthly Sales Performance for [year]'. 2. In the first row, label the columns as follows: 'Month', 'Sales Target', 'Actual Sales', 'Variance'. 3. Enter the names of the months in the 'Month' column from A2 downwards. 4. In the 'Sales Target' column, input the sales target figures for each month. 5. Record the actual sales figures in the 'Actual Sales' column as they occur. 6. Use the formula '=C2-B2' in the 'Variance' column to calculate the difference between the actual sales and the sales targets. Copy this formula down for all months.
✓ Template processed with your variables!