Financial Forecasting: Proven Excel Techniques for Better Reporting
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
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.
Join us for this 90-minute webinar to discover hidden Excel tools and functions that can boost your financial forecasting functions and minimize headaches.