Mobile Edition


Excel's Best New Features (ACEBNF01)

 
Date:Thursday, December 7, 2017
Time:2:00 PM - 4:00 PM
(Registration at 1:30 PM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Thomas G. Stephens
Vendor:ACPEN
Course Level:Intermediate
Early Bird Price:$79.00 FICPA Members, $109.00 Non-Members

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 key new features added to Excel 2013 and Excel 2016 and how to put these features to work. Among the new tools you will learn about are Data Models, Flash Fill, and Enhanced Drill-Down and Around on PivotTables. You will also learn about six new charts added in Excel 2016 and how to use PowerPivot, Power Query, and Power View for business intelligence. Join us in this session to 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 and accuracy.

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


Major Topics:
  • Computer Software & Applications


Who Should Attend:
Accounting, financial, and other business professionals who want to learn how to use the new features found Excel in Excel 2013 and Excel 2016

Prerequisite:
Fundamental knowledge of Microsoft Office Excel

Advanced Preparation:
None

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.