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.

 

  • Your ethics course was the most interesting and clear course I have taken. I usually dread the years it is required but this year was a pleasant surprise.

    - Terry

  • I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

    - Mark R.

  • “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

    - California Ethics Course