shopping cart
search

K2's Excel's Best New Features

About This Course:
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.

Agenda / Covered Topics
  • 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
  • Computer Software & Applications
Included Materials

All ACPEN courses include handouts that are available to download. Handouts typically include a version of the slides used by the presenter, as well as a full course manual or other materials.

How To Access Your Course And The Accompanying Materials

You will receive an email directly from ACPEN with instructions for accessing your course and any accompanying materials.

How To Get Your CPE Credits

In order to obtain CPE credit for viewing ACPEN webcasts, you must view the course during the scheduled date and time. Throughout the program, you will be prompted to save three attendance codes per hour. At the conclusion of the program, your CPE Certificate will be issued assuming all attendance codes have been saved and submitted. Detailed instructions for this process are included in the course introduction and in written form as part of course materials.
Continuing Education Credits:

Click the 'Credits' tab above for information on PHR/SPHR, PDCs, and other CE credits offered by taking this course.
Share This:
Facebook CPATrainingCenter.com. 5755 North Point Parkway, Suite 227 | Alpharetta, GA 30022 | 770-410-9375 | support@CPATrainingCenter.com
Copyright CPATrainingCenter.com 2024 | Web Site Development by OTAU
%%chngBtnTxt%%