Contact Customer Support at: 800-964-6033

Financial Forecasting: Proven Excel Techniques for Better Reporting

Summary

Webinar Recording

Recording Price: $199.00

(Includes Proprietary Materials)

You need accurate and reliable financial forecasts to help maintain and grow your company. Forecasting models are built in Excel, but most users never unlock Excel's true power. During this 90-minute webinar, Excel expert, Melissa Esquibel, will guide you through the most vital Excel features to help you make your next financial model dynamic and accurate. Join us to discover:

  • Increasing your efficiency: Time-save but effective Excel techniques
  • Common forecasting pitfalls & mistakes: How to avoid them
  • Excel tools built just for finance: Versatile forecasting models
  • How to use a rolling forecast to improve your budgeting

Program Highlights

  • Excel Techniques to Minimize Forecasting Errors & Save Time

    • Formatting your spreadsheet & building complex formulas
    • Protect sensitive inputs and make formulas easier to craft and audit
    • Strategies to protect & manage multiple sets of forecasting assumptions

  • Versatile Forecasting Models: How to Get More Out of Your Spreadsheet

    • Utilize Excel's Scenario Manager to manage multiple assumption sets
    • Worksheet functions: Compute interest & principal for any time period
    • Goal Seek and more: Essential forecasting tools built into Excel

  • Protect the Integrity of Your Spreadsheets: Best Tools & Techniques

    • Data Validation feature: Restricting user inputs to a range of values
    • Excel's very hidden property: Hide sensitive worksheets in plain sight
    • Grouping and SUMIF: Leverage advanced worksheet features & functions

  • Live Question & Answer Session - Have your questions answered by the expert!

About The Speaker

Melissa Esquibel is a technology consultant, coach, trainer and speaker.

  • She is a consultant, frequent speaker and Microsoft Certified Trainer.
  • Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions through 2010.
  • Melissa has 25+ years experience in information technology with a background in training, technical writing and business risk analysis.

Program Benefits

Join us for this 90-minute webinar to discover hidden Excel tools and functions that can boost your financial forecasting functions and minimize headaches.