Excel Functions for Finance: Build Better Spreadsheets for Analysis
Recording Price: $199.00
(Includes Proprietary Materials)
If you're a manager, understanding the fundamentals of using specialized functions in Excel can greatly help you make efficient financial decisions that impact your company or department. Excel can be one of your most powerful tools for financial modeling, forecasting and budgeting. Join us for the 90-minute webinar that provides real world solutions to the financial data problems your company faces every day, including:
Understand formula and function mechanics that make your work easier
Essential functions (If, VLookUp, IfError) to automate your workbooks
Discover Financial functions to forecast debts and investments
Create Charts that put sharp 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 ensure the right decisions for your business
Strategies to protect & manage multiple sets of forecasting assumptions
Minimize Forecasting Errors & Save Time in Excel: Spreadsheet Techniques
Work with 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
Live Q&A Session: Have Your Questions Answered on the Spot!
About The Speaker
She 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 through 2010.
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).