What's New in 2013 Excel (Currently Unavailable)

Author: David H. Ringstrom

In this on-demand webcast, Excel expert David Ringstrom, CPA brings his fast-paced teaching style to Excel 2013.

After two hours you'll have the lay of the land in this new Excel version. David will explore new features, as well as identify differences in Excel 2013 versus Excel 2007 and 2010.

Publication Date: April 2013

Designed For
Practioners considering the move from an earlier version of Excel to 2013, or anyone that has already upgraded.

Topics Covered

• Catch up on new features you may have missed or haven't seen in Excel 2007 and 2010 if you skipped a version.
• Find workarounds for user interface changes in Excel 2013 that now require more clicks than previous Excel versions.
• Replace ALL CAP tab names like HOME, INSERT, etc. with Home, Insert, etc. in the Excel 2013 ribbon.
• Understand the nunaces of Excel 2013's new artificial intelligence-based Flash Fill feature.
• Visualize data in new ways with Excel 2013's Recommended Pivot Table feature.
• Discover new worksheet functions introduced in Excel 2007, 2010, and 2013, respectively.
• Unlock data embedded in PDF files: open first in Word 2013, and then copy and paste into Excel.
• Use Excel's Quick Analysis feature to preview conditional formatting, charts, totals, sparklines, and more.
• Watch how Excel has evolved through side-by-side comparisons of user interface changes in Excel 2007, 2010, and 2013.
• Learn about Apps of Office, and how apps differ from add-ins in prior versions of Excel.
• Quickly filter data in new ways by using Slicers in both pivot tables and tables in Excel 2013.
• Use the new Timeline feature to analyze date-based data in new ways.
• Learn which features in the Office Preview version of Excel 2013 didn't make it into the final version.
• View the changes that Touch Mode makes in Excel 2013.

Learning Objectives

• Identify the new features available in Excel 2013, and avoid pitfalls and frustration by understanding differences from previous Excel versions.

Level
Basic

Instructional Method
Self-Study

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
Must be familiar with Excel.

Advance Preparation
None.