Microsoft Excel 2016 Benefits and Hazards in Office 365 - 2018

Topics

• Discovering new worksheet functions available in Excel 2016
• Determining if you have the subscription-based Office 365 version of Excel or a perpetually licensed version
• Learning about the MINIFS function available in the Office 365 version of Excel 2016, as well as how to use the MIN function as an array formula that will achieve the same effect in any version of Excel
• Learning about the MAXIFS function available in the Office 365 version of Excel 2016
• Exploring pivot table options that can only be set in the Office 365 version of Excel 2016
• Discovering the Recommended PivotTables feature
• Embedding 3D models into Office 365 spreadsheets, while seeing what`s viewable in other versions of Excel
• Mapping geographic data with just a couple of mouse clicks in the Office 365 version of Excel 2016
• Seeing the benefits and risks of sharing workbooks via OneDrive in Office 365
• Using the Icons command in Office 365 to add emoji-style icons within spreadsheets
• Providing feedback about the Office 365 version of Microsoft Excel directly from within the application
• Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of 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

Who should Attend

• CPA`s
• Accountants
• Controllers
• CFO`s
• Income Tax Preparers
• Excel User
• Financial Consultants
• Enrolled Agents
• Auditors
• IT Professionals
• Bookkeepers
• Human Resource Personnel
• Government Personnel
• Marketers