If you’d like to learn how the Office 365 version of Excel 2016 differs from previous versions of Excel and perpetual licensed versions of Excel 2016, this course provides the information you need. Historically, each major version of Excel has been identical for all users, but that’s no longer the case. In this comprehensive course, Excel expert David Ringstrom, CPA, discusses updated features and worksheet functions available in the Office 365 version of Excel 2016, shows you step-by-step how to use them, and 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.

Learning Objectives:-

• Describe the MAXIFS function that’s available in certain versions of Excel 2016.
• Name recently released features and improvements Office 365 offers. 
• Define how you can easily map geographic data.

Areas Covered:-

• Mapping geographic data with just a couple of mouse clicks.
• Determining if you have the subscription-based Office 365 version of Excel or a perpetually licensed version.
• Selecting one or more cells from within a selection of cells without having to start over again with the selection process.
• Updating Office 365 to take advantage of recently released features and improvements.
• Learning about the MAXIFS function available in certain versions of Excel 2016.
• Learning the benefits and risks of sharing workbooks via OneDrive in Office 365.
• Viewing historical versions of documents that have been saved to Microsoft’s OneDrive service.
• Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
• Using the Icons command in Office 365 to add emoji-style icons within spreadsheets.
• Discovering new worksheet functions available in Excel 2016.
• Removing the background from pictures within Microsoft Excel.

Who will Benefit?

Practitioners who are thinking of subscribing to the Microsoft Office 365 platform or those who have already done so.