Excel Essentials: Excel 2016 Roundup


Overview
In this informative course, Excel expert David Ringstrom, CPA, covers the best new features available in Excel 2016. David teaches you about new chart types, such as the Waterfall chart for illustrating financial statements, nuances associated with the Funnel chart, and a handful of new worksheet functions available to Office 365 subscribers (these aren’t available to users who have purchased perpetual licenses for Excel 2016). He also gives you a sense of the new Forecast feature and shows you how to avoid accidentally shutting down Excel 2016 until you’re ready.

Objectives

  • Define the new features available in Excel 2016.
  • Identify the differences in Excel 2016 from previous versions in order to avoid the pitfalls and frustrations than can result from a lack of understanding.
  • Recall how to use the Flash Fill feature, the Recommended Charts feature, the Slicer feature, and the Quick Analysis feature.
  • Learn how to create tables in an Access database
  • Explore the different types of data that can be stored within an Access table.
  • Design queries to return exactly the data that you’re seeking
  • Easily move data between Excel worksheets and Access tables

Emphasis
  • ​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. 
  • 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 Sunburst chart for displaying hierarchical data in a circular chart. 
  • Use Excel 2016’s Treemap chart to visualize data based on relative size.
Who Should Attend:
Practitioners interested in learning more about Microsoft Access.

Prerequisite
None

Preparation
No advance preparation required
 
Level of Knowledge
Basic
 
CPE Credit
2 Hours
 
Delivery Method  
Group Internet Based
 
NASBA Field of Study
Computer Science

Author
David H. Ringstrom