Excel Dexterity: Office 365 (video)

  • Credits: 2
  • Format: Self-Study Video
  • Field of Study: Computer Software
  • Author/Speaker: David Ringstrom
Course ID: Advanced Preparation: Experience Level:
DR-613.21 None Overview
Published Date: Program Prerequisites: Other Course Formats:
© June 2020 Basic Understanding of Technology N/A
COURSE DESCRIPTION

Historically, each version of Excel has been identical for all users, but that’s no longer the case. In this on-demand webcast, Excel expert David Ringstrom, CPA, explains how the Office 365 version of Excel 2016 differs from previous versions as well as perpetual licensed versions of Excel 2016. David discusses updated features and worksheet functions available in the Office 365 version of Excel 2016, and he shows you step-by-step how to use them. He also shares helpful keyboard shortcuts and tips.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel 2016. He draws your attention to any differences in the perpetual licensed versions of Excel 2016, 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. In addition, David provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics include:
  • Updating Office 365 to take advantage of recently released features and improvements.
  • Visualizing data with a Funnel chart, which is exclusive to the Office 365 version of Excel 2016.
  • Preventing pivot tables from automatically resizing columns when you refresh or filter the data.
  • Exploring the risks and benefits of participating in the free Microsoft Office Insider program.
  • Removing the background from pictures within Microsoft Excel.
  • Jump-starting pivot tables by way of the Recommended Pivot Tables feature in Excel 2013 and later.
  • Viewing historical versions of documents that have been saved to Microsoft’s OneDrive service.
  • Analyzing your data with artificial intelligence by way of the Insights feature in Office 365.
  • Embedding 3D models into Office 365 spreadsheets while seeing what’s viewable in other versions of Excel.
  • Deselecting one or more cells from within a selection of cells without having to start over again with the selection process.
  • Mapping geographic data with just a couple of mouse clicks.

Learning Objectives:

After reading the course material, you will be able to:

  • Name recently released features and improvements Office 365 offers.
  • Identify the menu where the Recommended PivotTables feature appears in Excel 2013 and later.
  • Define how you can easily map geographic data.

Who Should Attend:
  • All Certified Public Accountants (CPAs)

Qualifies and Approved with all State Boards of Accountancy and the following sponsorship’s:
NASBA