National Registry of CPE Sponsors

National Registry of CPE Sponsors

NASBA Logo

Course Library

Financial Forecasting: Leverage Excel Shortcuts & Time-Saving Tricks

Nov 15, 2016 Traliant
Excel is one of the key tools of the trade for those in finance and accounting disciplines. In this webinar, you’ll learn how to tame unruly data, derive information from data elements, and present it with impact and clarity to decision-makers and stakeholders. Upon completion of this course, you’ll be able to: Recognize whether your data is in the right shape to take advantage of Excel’s advanced tools Identify functions to calculate present and future values Derive additional information from raw data to add dimension to your forecasts Display trend information in formats other than charts Use PivotTables to keep your forecasting data nimble Define a named range and explain how it can reduce repetitive steps in your financial analysis Identify the right approach to data that grows and changes over time Utilize Excel’s newest features to make your reporting understandable to non-financial professionals Define a dashboard and create one without buying special add-ins Predict future trends based on historical data Blend datasets to generate a single report Join data with look-up capabilities in Excel beyond VLookUp Convert your financial forecast charts and reports from Excel into PowerPoint Use web-based data in your Excel workbooks
Course Registration
Loading