K2's Excel 2013-2019 - Best New Features for Accountants - On Demand (2 hours)

K2's Excel 2013-2019 - Best New Features for Accountants - On Demand (2 hours)

  • $89.00

Course Description

Excel 2013 was a watershed release with many outstanding new features - automated analysis with recommended PivotTables and charts, pure power analysis with the Power View and PowerPivot add-ins, and advanced workbook auditing with Inquire. Excel 2016 and 2019 continues the trend with six new chart types, forecast sheets, and Power Query integration. But that's not all! The latest versions of Excel provide powerful and easy to use new features like Flash Fill, Timelines, Quick Explore drill down and around, Combo charts, and the ability to open workbooks in their own window without losing the ability to copy and paste between workbooks. Attend this webinar and learn how to put the power of Excel 2013-2019 to work immediately to improve your productivity.

Major Topics

  • Automated analysis with Quick Analysis, Recommended Charts, and Recommended PivotTables
  • Quick and easy data filtering with Timelines and Slicers for tables
  • Split, combine, or rearrange data quickly and easily with Flash Fill
  • Better charting, including standalone Pivot Charts
  • Drill down and around with Quick Explore
  • Powerful data analysis with PowerPivot and Inquire
  • Ease time series forecasting with Forecast Sheets
  • The Excel Data Model and table Relationships

Learning Objectives

Upon completing this course, you should be able to:

  • Identify three types of automated analysis in Excel 2013-2019
  • Describe the new Excel Data Model and explain its impact on PivotTable analysis
  • Use combo charts for presenting financial data
  • Distinguish between an ordinary PivotTable and one built using PowerPivot

Who Should Attend: Accounting and financial professionals who want to put the power of Excel 2013-2019 - including Office 365 - and its new features and functionality to use right away

Course Level: Intermediate

CPE Credits: 2 Hours Computer Software and Applications  

Prerequisites: Good working knowledge of Excel

Advance Preparation: None

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.