What to Expect in Excel 2016

Price: $29.99

CPE Credits: 2.0

Category: , ,

Course Number: VCXE16DR

Excel 2016 - New features -Video CPE

Description:
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

AuthorDavid Ringstrom,CPA

Publication: May 2016

Format:  On-demand webcast.
David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session. David is happy to answer questions about the materials by email.

Run-Time: 1 hr; 42 minutes

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
• Define new chart 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.

 

Description:
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

AuthorDavid Ringstrom,CPA

Publication: May 2016

Format:  On-demand webcast.
David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session. David is happy to answer questions about the materials by email.

Run-Time: 1 hr; 42 minutes

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
• Define new chart 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.

 

  • “Thank you for a high quality CPE resource. As a CPA in a small nonprofit, I find your library quite helpful to meet my needs. I appreciate the service.”- 

    - Cheryl

  • “It is rare that i can actually say that I enjoyed a CPE course but I found this one informative and very interesting, relying more on the author’s examples and not just quoting tax code!  [Healthcare Reform: The affordable Care Act Tax Provisions]

    - Thomas

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet