|
There's a right way to do things and a long way. How much time are you spending, scrubbing, arranging, calculating, architecting your financial spreadsheets. From budgets to dashboards, there are shortcuts, tips and tricks to get your data in the right place and provide you the information you need to make sound decisions. 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.
Key Learning Objectives
- 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
- Define a dashboard and create one without buying special add-ins
- Join data with look-up capabilities in Excel beyond VLookUp
- Convert your financial forecast charts and reports from Excel into PowerPoint
|
|
|
|
|
|
|
|
Melissa P Esquibel
Melissa specializes empowering office software users to get the software to work for them, rather than the other way around. As a Microsoft Certified Trainer (MCT) and Microsoft Office Specialist Master (MOSM) with more than 25 years in business application technology, Melissa has a unique ability to make learning programs enjoyable and valuable.
|
|
View More
|
|
|
|
|
Host This Webinar At Your Organization
Become a Speaker
