Learn from Excel expert David Ringstrom, CPA, how the Office 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 Office 365 version of Excel 2016, shows you step-by-step how to use them, and 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.

Topics Covered:

  • Deselecting one or more cells from within a selection of cells without having to start over again with the selection process.
  • Updating Office 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 Office 365.
  • Exploring the Help menu introduced in Office 365 that provides immediate access to free training resources.
  • Understanding the risks and nuances of the AutoSave feature in Office 365.
  • 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.
  • Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
  • Visualizing data with a Funnel chart, which is exclusive to the Office 365 version of Excel 2016.
  • 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.

 

Learning Objectives
  • Recognize the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Identify the menu where the Recommended PivotTables feature appears in Excel 2013 and later.
  • Discover the MAXIFS function that’s available in certain versions of Excel 2016.
Last updated/reviewed: March 11, 2024
14 Reviews (66 ratings)

Reviews

5
Anonymous Author
I have enjoyed this instructor's courses before and this course did not disappoint! I really appreciated the extensive background on the different versions and glad to have the high-level background on why/how there are differences. I also enjoyed the realtime demos as well.
5
Anonymous Author
This course was really interesting because I learned about some of the new things I can do with 365. Definitely recommended. However, digging into the differences between various versions of Excel is not too interesting.
5
Anonymous Author
Just received 365 version of office and this was very helpful in guiding me through new features. I would recommend to any one interested in learning some of the not so common things on 365. Very helpful and informative.
5
Anonymous Author
The course does provide a great deal of background and knowledge on the Office 365 commands in excel. The instructor takes the perfect amount of time to go over each topic in great detail but not too much detail.
5
Anonymous Author
Well laid out presentation. Thoroughly explained each MS 365 feature with historical background and then should how each feature worked. Great overview of 365 vs other excel versions.
5
Anonymous Author
I’ve used Excel for many years and continue to learn and utilize commands based on opportunities such as the ones presented. I'm looking forward to the move to the 365 version.
5
Member's Profile
I was really curious about Excel 365 and this course really gave a lot of information on what was different in 365 from other versions. Very informative.
4
Member's Profile
It's a good overview of excel in office 365 but I thought there was a lot of wasted time on the specifics of certain formulas (e.g. the Concat formula).
5
Member's Profile
This course was excellent. I learned a great deal. I appreciate courses such as this because it will help me grow within my career.
5
Anonymous Author
Good course.
4
Member's Profile
Clear and straightforward. Multiple examples provided and real life examples to ease learning. Thank you.
4
Anonymous Author
Well delivered and relevant. Would have appreciated a faster pace.
5
Anonymous Author
Good overview of features only available in Office 365 version.
4
Anonymous Author
This is a great course for new users of Office 365.
show all reviews
Prerequisites
Course Complexity: Foundational

No advanced preparation or prerequisites are required for this course.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Excel Efficiency: Office 3652:17
  Determine If You Have Office 36513:31
  Deselect a Selection ( Office 365 Only )9:24
  Worksheet Function Evolution8:31
  TEXTJOIN Function (Office 365 Only)11:20
  IFS Function (Office 365 Only)6:25
  MINIFS Function (Office 365 Only)11:38
  Insights Feature (Office 365 Only)9:10
  Map Charts (Office 365 Only)8:46
  Background Removal (Office 365 Only)11:38
  Co-Authoring Workbooks ( Office 365 Only)8:17
CONTINUOUS PLAY
  Excel Efficiency: Office 365 1:40:56
SUPPORTING MATERIALS
  Slides: Excel Efficiency: Office 365PDF
  Excel Efficiency: Office 365 Glossary/IndexPDF
  Workbook: Excel Efficiency: Office 365XLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam