What you’ll learn
- Detailed Monthly Sales Tracking
- Goal Setting
- Variance Analysis – Budget vs Actual
- Business Decisions Making
- Business Analytics and Intelligence
- Inventory Planning
- Goal Evaluation
- Pricing Decisions
- Revenue Reporting
- Revenue Calculation
- Management Planning
- And Much More!
Requirements
- No special tools or knowledge are required
- A passion to learn
- Basic Microsoft Excel is useful but not required
Course Batches
Course Curriculum
| Introduction | |||
| Course Introduction | 00:00:00 | ||
| Excel Basics | 00:00:00 | ||
| Sales Tracking Template Creation | |||
| Blank Slate – Starting the Build | 00:00:00 | ||
| Forecast and YTD Formulas | 00:00:00 | ||
| Average Formulas and Totals | 00:00:00 | ||
| Formatting and Graphs | 00:00:00 | ||
| Year 2 Setup | 00:00:00 | ||
| Year 3 Setup | 00:00:00 | ||
| Year 1 Specific Data Tracking | |||
| Setup of Headers and Sheet for Year 1 | 00:00:00 | ||
| Year 1 Finalize | 00:00:00 | ||
| Year 2 and Year 3 Setup | 00:00:00 | ||
| Additional Reporting and Forecasting Information | |||
| Quarterly Review Setup | 00:00:00 | ||
| Useful Forecasting Information | 00:00:00 | ||
| Course Conclusion | |||
| Course Conclusion | 00:00:00 | ||
Course Reviews
No Reviews found for this course.