Excel's Best New Features
Tuesday, March 19, 2019
2CREDITSComputer Software and Applications
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.
*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