Webinar Details

Accelerate Excel: Benefits and Hazards of Office 365/Excel 2016

Tuesday, June 26, 2018

12:00 p.m. Mountain time (MT)

Program Description

After attending this comprehensive live webcast, you’ll understand how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Historically, each major version of Excel was identical for all users, but that’s no longer the case. Because the Office 365 version is evolving—sometimes monthly—you’ll want to be prepared to deal with frustrations you might encounter as well as capitalize on new features.

Excel expert David Ringstrom, CPA, explains updated features and worksheet functions available in the Office 365 version of Excel 2016 and shows you step-by-step how to use them. He also shares keyboard shortcuts and tips that will help you work more efficiently in Excel. If you’re thinking of upgrading to the latest version of Excel, this presentation is just what you need.

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. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics Typically Covered

Accessing the superscript and subscript commands with a mouse click instead of by way of the Format Cells dialog box.
Determining if you have the subscription-based Office 365 version of Excel or a perpetually licensed version.
Discovering how Office 365 no longer immediately clears the clipboard when you carry out a simple action, such as typing or inserting rows before pasting data.
Discovering new worksheet functions available in Excel 2016.
Editing Excel workbooks in real time with colleagues and viewing co-authored changes within seconds.
Embedding 3D models into Office 365 spreadsheets while seeing what’s viewable in other versions of Excel.
Exploring the Help menu introduced in Office 365 that provides immediate access to free training resources.
Exploring the risks and benefits of participating in the free Microsoft Office Insider program.
Jump-starting pivot tables by way of the Recommended Pivot Tables feature in Excel 2013 and later.
Learning about the MAXIFS function available in certain versions of Excel 2016.
Learning about the MINIFS function available in certain versions of Excel 2016.
Learning the benefits and risks of sharing workbooks via OneDrive in Office 365.

Learning Objectives

After completing this webinar, attendees will be able to:

Demonstrate an understanding of new features and functions available in the Office 365 version of Excel 2016.
Identify alternatives that work in all versions of Excel for the new CONCAT, TEXTJOIN, SWITCH, IFS, MAXIFS, and MINIFS worksheet functions.
Apply pivot table specific options in the Office 365 version of Excel 2016 to minimize repetitive work.

Who Should Attend

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

Presenter(s)

David H. Ringstrom, CPA
Mr. Ringstrom is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

CPE Credit

Program Level: Basic	Prerequisites: None	Advanced Preparation: None
Delivery Method: Group Internet-Based	CPE Credits: Two (2) Hours	Fields of Study: Computer Software & Applications

Buy Now