fbpx

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

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

X