|
|
| Accelerate Excel: Excel 2016 Roundup | (160823_N) |
Course CPE: 2 hours
Fields of Study: Personal Development–2 hrs
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught. Such persons are often at a mid-level within the organization, with operational and/or supervisory responsibilities.
Advanced Preparation: None
Delivery Method: Self-Study |
Item
Number: 16PPM0823
Shipping Weight: 0lbs. 0oz. |
| Price:
$147.00 |
|
|
|
|
Recording Date: August 8, 2016
Presenter: David Ringstrom
Program Description:
Excel expert David Ringstrom, CPA, covers the new features available in Excel 2016 during this informative webcast. He demonstrates how to simplify chart-related tasks, how to convert .XLS workbooks to the .XLSX format, and how to create interactive maps from Excel data with the free Bing Maps app. In addition, he explains how to use the Flash Fill feature, the Recommended PivotTables feature, the Charts feature, the Slicer feature, the Quick Analysis feature, and how to overcome user interface annoyances by making simple adjustments. David shares information about new Excel 2016 charts, including Box and Whisker charts, Treemap charts, and Sunburst charts.
Once you understand how Excel 2016 differs from previous versions, you can avoid any pitfalls and frustrations you might have when working in this new version of Excel. David teaches from the version of Excel in use by the majority of attendees, but he explains any differences in Excel 2007, 2010, 2013, and 2016. His webcasts 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. David’s 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.
Topics Typically Covered:
- Avoid disabled features by converting Excel 97 and 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.
After completing this course, you will be able to:
- 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
- Define how to convert .XLS workbooks to the .XLSX format
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
|
|
|
