Astute Excel: Office 365
Presented by David H. Ringstrom, CPA
Learn from Excel expert David Ringstrom, CPA, how the Microsoft 365 version of Excel 2016 differs from previous versions and perpetually 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 updated features and worksheet functions available in the Microsoft 365 version of Excel 2016, shows you step-by-step how to use them, and shares helpful keyboard shortcuts and tips.
Topics Covered:
- Deselecting one or more cells from within a selection of cells without having to start over again with the selection process.
- Updating Microsoft 365 to take advantage of recently released features and improvements.
- Mapping geographic data with just a couple of mouse clicks.
- Jump-starting pivot tables by way of the Recommended PivotTables feature in Excel 2013 and later.
- Streamlining the decision-making process with the IFS function in Microsoft 365.
- Exploring the Help menu introduced in Microsoft 365 that provides immediate access to free training resources.
- Understanding the risks and nuances of the AutoSave feature in Microsoft 365.
- Discovering how Microsoft 365 no longer immediately clears the clipboard when you carry out a simple action, such as typing or inserting rows before pasting data.
- Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Microsoft 365.
- Visualizing data with a Funnel chart, which is exclusive to the Microsoft 365 version of Excel 2016.
- Using Microsoft’s free Excel Online service to view and edit spreadsheets that use features from Microsoft 365 that aren’t compatible with other versions of Excel.
- Removing the background from pictures within Microsoft Excel.
Learning Objectives:
- Recall the benefits and risks of sharing workbooks via OneDrive in Microsoft 365.
- Identify the menu where the Recommended PivotTables feature appears in Excel 2013 and later.
- Describe the MAXIFS function that’s available in certain versions of Excel 2016.