Tuesday, July 26, 2016

Tomorrow: Financial Forecasting: Leverage Excel Shortcuts & Time-Saving Tricks

Live Webinars   |   On-Demand   |   All-Access Plan
Manage Preferences    |    View in Browser
Visit Clear Law Institute
Financial Forecasting: Leverage Excel Shortcuts & Time-Saving Tricks
July
 
27
1 pm - 2:40 pm ET
Presenter: Melissa Esquibel, President of MPELLC
Credits: CPE (Credit Details)
Can't attend live? By registering, you will be able to view the course live, view a recording at any time for 6 months, or both.
Viewing Options: View on your computer, tablet, or smartphone
Learn More
Register Today
Course Description
 
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
Learn More
Register Today
The Presenter
About The 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.
Learn More
Register Today
All-Access Membership
 
● 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 750 on-demand courses
Learn More
Upcoming Webinars
Excel Lookup Formula Basics
August 1 at 1 pm ET
Learn More
Fundamentals of Fraud
August 2 at 1 pm ET
Learn More
Tax Compliance for Household Employers
August 4 at 1 pm ET
Learn More
Questions?
Please call us at 703-372-0550

Our Mailing Address:
Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201
Remove me from future emails.

Manage email preferences.
 

No comments:

Post a Comment