Webinar: Excel 2013/2016 - Best New Features for Accountants

WK261  |  Partner Virtual Events  |  Intermediate  |  Scheduled

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.

Credits

Number of Credits Type of Credits
2 Other

Prerequisites

Good working knowledge of Excel

Highlights

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 PivotChartsDrill down and around with Quick Explore Powerful data analysis with PowerPivot and InquireFast time series forecasting with Forecast SheetsThe Excel Data Model and table Relationships

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

Preparation

None

Notes

This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.

Prices

Member (Early Bird)
$79.00
Non-Member (Early Bird)
$79.00
Member
$79.00
Non-Member
$79.00
Registration for this event has closed. If you have any question or concerns please give us a call at 615-377-3825 or send us an e-mail at registrar@tscpa.com

Facilitators

Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators