Attend upcoming webinar and earn continuing education credits. Financial Forecasting: Leverage Excel Shortcuts & Time-Saving Tricks | | | | | | | November | | 15 | 3 pm - 4:40 pm ET | | | | | | | | | 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 Reviews from Past Attendees
100% of attendees said they would recommend this course to others. "Helpful tricks." "Clear and precise - good presenter." | | | | | | | Melissa P. Esquibel, President of MPELLC, is a Microsoft Certified Trainer and Microsoft Office Master Specialist. Previously, Ms. Esquibel served as an EDP auditor for the Federal Reserve Bank of Chicago and performed data security and disaster recovery work for the banking, manufacturing, and financial services industries. Ms. Esquibel graduated summa cum laude from Strayer University. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 850 on-demand courses | | | | | |
No comments:
Post a Comment