In this jam-packed session, Excel expert David Ringstrom, CPA, gives you the lay of the land with regard to new features in Excel 2016. Among other things, David covers new chart types, avoiding the pain that can arise from using XLS workbooks, and building interactive maps with just a couple of mouse clicks. Because many users skip one or two versions before upgrading, David includes features added in Excel 2013, such as the Flash Fill feature, Recommended Charts, Slicers, Quick Analysis, and much more. After this session you’ll be able to work more efficiently and capitalize on new features. You’ll also see how Microsoft is drawing a distinction between users that buy one-time licenses for Excel 2016 and those that subscribe via Office 365.
• Avoid disabled features by converting Excel 97–2003 files to modern workbook formats with ease.
• Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions.
• Create interactive geographic maps from Excel data with the free Bing Maps app.
• Cut through the tangles introduced by the revamped File menu.
• Discover how to disable worksheet animation.
• Discover new worksheet functions available in Excel 2016.
• Discover the Flash Fill feature.
• Discover the Recommended PivotTables feature.
• Excel 2016’s Sunburst chart shows relative scale for amounts in a circular chart.
• Explore the Recommended Charts feature in Excel 2013 and later.
• Filter pivot table data based on date ranges by way of the Timeline feature in Excel 2013 and later.
• Illustrate financial statements in Excel 2016 with the new waterfall chart feature
• Jump-start data visualization with the Quick Analysis feature.
• Learn about the IFNA function available in Excel 2013 and later.
• Learn how the Table feature allows you to transform filtering tasks.
• Overcome user interface annoyances by making simple adjustments to Excel’s options.
• Understand how to use the Slicer feature to streamline data analysis within tables and pivot tables.
• Use Box and Whisker charts in Excel 2016 to show data by quartiles and identify outliers.
• Use Excel 2016’s Tree Map chart to visualize data based on relative size.
Delivery Method: Online QAS Self Study.
Level: Basic. This course is best for practitioners considering a move from an earlier version of Excel to Excel 2016 or those who have already upgraded.
Version: David teaches from Excel 2010 in this presentation but every aspect of the material applies equally to Excel 2007, 2013, and 2016.
Prerequisites: Familiarity with Excel
Advanced Preparation: None