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.