Microsoft Excel is one of the most preferred spreadsheets used in the corporate world, as well as individually, having displaced Lotus about a quarter of a century ago. Its latest version, MS Excel Office 365 version, was released in 2016. This version differs from earlier ones in many ways. To start with, the latest version is no longer identical for all users. Other novelties include:
- More access to what other authors are doing in other MS programs such as Word, PowerPoint and OneNote;
- Ability to attach files from OneDrive and to automatically configure permissions
- Option of freedom in reviewing, editing, analyzing, and presenting Office 2016 documents from around a wide variety of devices, including PC, Mac, android phones and tablets.
A complete explanation of these new features, and more importantly, how to use them for quicker work, will be offered at a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance. David Ringstrom, a leading, globally known expert on MS Excel, will be the speaker at this webinar.
Want to gain mastery of using MS Excel 2016? Then, please enroll for this webinar by visiting http://bit.ly/2FqBqBa
The aim of this webinar, which is essentially about how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016; is to help participants get a complete understanding of the ways by which to understand and optimize the uses of MS Excel 2016.
Full understanding of the latest version of MS Excel
At this webinar, the speaker will explain the ways in which the 2016 version has been updated with new features. He will describe worksheet functions in a step-by-step manner of how to use them. David will also show important keyboard shortcuts and tips, which will reduce the time needed to work on this program.
David will help the participants of this webinar overcome the frustrations of not getting the functions right. The highlight of this webinar is the teaching methodology that David will adapt: he will first show each technique on a PowerPoint slide with numbered steps, and, will later repeat the same for Office 365. He will thus demonstrate each technique twice. Also explained at this webinar is the differences in the perpetual licensed versions of Excel 2016, 2013, 2010, or 2007, for which he will hand over detailed handouts and an Excel workbook that includes most of the examples that he will use during this webinar.
David will cover the following areas at this webinar:
- Determining if you have the subscription-based Office 365 version of Excel or a perpetually licensed version
- Discovering new worksheet functions available in Excel 2016
- Learning about the MAXIFS function available in the Office 365 version of Excel 2016
- 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
- Discovering the Recommended PivotTables feature
- Exploring pivot table options that can only be set in the Office 365 version of Excel 2016
- Mapping geographic data with just a couple of mouse clicks in the Office 365 version of Excel 2016
- Embedding 3D models into Office 365 spreadsheets, while seeing what’s viewable in other versions of Excel
- Using the Icons command in Office 365 to add emoji-style icons within spreadsheets
- Seeing the benefits and risks of sharing workbooks via OneDrive in Office 365
- Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365
- Providing feedback about the Office 365 version of Microsoft Excel directly from within the application
- 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.