Course Library
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
Share: