Webcast: K2's Excel 2013/2016 - Best New Features for Accountants (XKEBN217)
Tell a Friend About This EventTell a Friend
 

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. But that's not all! Excel 2013 provides 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 bet

8/9/2017
When: 08/09/2017
12:00 PM until 2:00 PM
Where: Webcast
K2 Enterprises
United States
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

Acronym XKEBN217
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for Accounting and financial professionals who want to put the power of Excel 2013/2016 and its new features and functionality to use right away
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

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. But that's not all! Excel 2013 provides 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. Excel 2016 continues the trend with six new chart types, forecast sheets, and Power Query integration. Attend this webinar and learn how to put the power of Excel 2013/2016 to work immediately to improve your productivity.

Objectives

Upon completing this course, you should be able to:

  • Identify three types of automated analysis in Excel 2013/2016
  • 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

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 PivotCharts
  • Drill down and around with Quick Explore
  • Powerful data analysis with PowerPivot and Inquire
  • Fast time series forecasting with Forecast Sheets
  • The Excel Data Model and table Relationships