You’ll learn from Excel expert David Ringstrom, CPA, how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Historically, each version of Excel has been identical for all users, but that’s no longer the case. In this comprehensive course, David discusses the 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.
- Learning the benefits and risks of sharing workbooks via OneDrive in Office 365.
- Understanding the risks and nuances of the AutoSave feature in Office 365.
- Learning about the MAXIFS function available in certain versions of Excel 2016.
- Embedding 3D models into Office 365 spreadsheets while seeing what’s viewable in other versions of Excel.
- Providing feedback about Microsoft Excel directly from within Office 365.
- Using Microsoft’s free Excel Online service to view and edit spreadsheets that use features from Office 365 that aren’t compatible with other versions of Excel.
- Removing the background from pictures within Microsoft Excel.
- Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
- Viewing historical versions of documents you’ve saved to Microsoft’s OneDrive service.
- Using the Icons command in Office 365 to add emoji-style icons within spreadsheets.
- Streamlining the decision-making process with the IFS function in Office 365.
- Accessing the superscript and subscript commands with a mouse click instead of by way of the Format Cells dialog box.
Delivery Method: Online QAS Self Study.
Advanced Preparation: None