Excel Functions for Finance: Build Better Spreadsheets for Analysis
Excel is the most powerful tool for financial modeling, forecasting and budgeting. For managers, understanding how to use the specialized functions in Excel will greatly help you make effective financial decisions that impact your department, and improve the bottom-line.
In this comprehensive, 90-minute webinar we'll show you dynamic Excel functions, features and shortcuts that allow you to easily and quickly analyze important financial data. Join us to learn:
- Formula and function mechanics that make your work easier
- Essential functions (If, VLookUp, IfError) to automate your workbooks
- Financial functions to forecast debts and investments
- How to create charts that put focus on performance and progress
Techniques for Financial Forecasting and Planning
- Accurately track variances before they become major problems
- Forecast more precisely for fewer surprises at reporting time
- Plot cash flows against expenses to support important financial decisions
Build Better Spreadsheets for Financial Analysis
- Make line item accountability less of a mystery for supervisors and managers
- Compare finance and investment options to make the best financial decisions
- Strategies to protect & manage multiple sets of forecasting assumptions
Minimize Forecasting Errors & Save Time in Excel: Spreadsheet Techniques
- Use formulas across worksheets to make short work of budgeting
- Tools to summarize your detailed data into easy-to-read formats
- Use named ranges to make formula building a cinch
Question and Answer Session - Hear expert answers to real-world questions!
About the Speaker
Melissa Esquibel is a consultant, frequent speaker and Microsoft Certified Trainer.
- Melissa's consulting career spans banking, manufacturing, telecommunications, energy and insurance, which allows her to provide real-world examples and applications. She has enabled everyone from rocket scientists to real estate brokers to put the "productive" back in office productivity software.
- Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions.
- Melissa has 25+ years experience in information technology with a background in training, technical writing and business risk analysis
During our 90-minute webinar, our expert instructor will build a budget workbook from a sample chart of accounts using an intermediate set of Excel skills. Participants should be experienced in basic functions (sum, average, count) and comfortable with simple formula building (=A1+B1).