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