Inside Excel 2016
About This Event
Description
Excel expert David Ringstrom, CPA, covers the new features in Excel 2016 in this informative webcast. David shows you how to simplify chart-related tasks, how to convert XLX workbooks to the XLSX format, and how to create interactive maps from Excel data with the free Bing Maps app. He also explains how to use the Flash Fill feature, the Recommended Charts feature, the Slicer feature, the Quick Analysis feature, and much more. After participating in this webcast, you'll have gained an understanding of how Excel 2016 differs from previous versions, which will help you avoid any pitfalls and frustrations you might experience when working in this new version of Excel.
Objectives of the Presentation
Apply the new features available in Excel 2016
Recognize how to avoid pitfalls and frustration by understanding the differences in Excel 2016 and previous versions of Excel
Define how to convert XLS workbooks to the new XLSX format
Apply the Flash Fill feature
Apply the Slicer feature to streamline data analysis within tables and pivot tables
Recall how to use the Recommended PivotTables feature
Why Should you Attend
Learn about the new and beneficial features available in Excel 2016. David's courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. His detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Areas Covered
Avoiding disabled features by converting Excel 97-2003 files to modern workbook formats with ease
Comparing and contrasting IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
Implementing user-interface changes in 2016 that have vastly simplified chart-related tasks
Converting XLS workbooks to the up-to-date XLSX format with just two keystrokes
Creating interactive geographic maps from Excel data with the free Bing Maps app
Cutting through the tangles introduced by the revamped File menu
Discovering how to disable worksheet animation
Learning about the Flash Fill feature
Understanding how to use the Recommended Pivot Tables feature
Editing PDF documents in Word 2016, which are useful for unlocking data you wish to edit in Excel
Exploring the Recommended Charts feature
Jump-starting data visualization with the Quick Analysis feature
Learning how the Table feature allows you to transform filtering tasks
Dealing with annoying changes to Print Preview in Excel 2010 and later
Understanding the risks and rewards of double-clicking on the Fill Handle feature in Excel
Navigating large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
Overcoming user interface annoyances by making simple adjustments to Excel's options
Understanding how to use the Slicer feature to streamline data analysis within tables and pivot tables
Who can Benefit
Accountants
CPAs
CFOs
Financial consultants
Controllers
For Registration
http://onlinecompliancepanel.com/webinar/INSIDE-EXCEL-501226/JAN-2016-ES-WORLDCONFERENCE
Note: Use Promo code SMEVB and get 10% off on registration (Valid till Jan 31st)