Webcast: K2's Profiting with Excel's Best New Features (XKEPE117)
Register Tell a Friend About This EventTell a Friend
 

Excel is a staple of the business professional’s toolbox, yet, all too often, new features remain undiscovered and underutilized, leading to inefficiencies and errors. In this session, you will learn about the best new features recently added to Excel and how to put them to work for you and your team to increase productivity, accuracy, and profit.

 Export to Your Calendar 7/27/2017
When: 07/27/2017
9:00 AM until 11:00 AM
Where: Webcast
K2
United States
Presenter: Steven Phelan


Online registration is available until: 7/25/2017
« Go to Upcoming Event List  

Acronym XKEPE117
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 use Excel more effectively and efficiently
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 is a staple of the business professional’s toolbox, yet, all too often, new features remain undiscovered and underutilized, leading to inefficiencies and errors. In this session, you will learn about the best new features recently added to Excel and how to put them to work for you and your team to increase productivity, accuracy, and profit.

Objectives

Upon completing this course, you should be able to:

  • Identify and implement three types of automated data analyses in Excel
  • Use Flash Fill to split, combine, and rearrange data quickly and easily without using commands or complicated formulas
  • Utilize Excel’s Data Model and identify their impact on PivotTable analysis
  • Create Charts and PivotTables more quickly than ever
  • Obtain insights into data using business intelligence features in Excel

Topics

  • Use new Excel tools available in Excel 2013 and 2016
  • Utilize six new charts added in Excel 2016
  • Discuss PowerPivot, Power Query and Power View for business intelligence