Office 365 Spring 2020 Update

Office 365    |    Intermediate
  • 3 videos | 17m 33s
  • Includes Assessment
  • Earns a Badge
As a Microsoft 365 subscriber, you'll get constant updates on your Office tools. In this update you'll see what's new in Excel, Word and PowerPoint 365 in Spring 2020. In this course, you'll learn how to use the Focus Mode in Word 365 to get a clearer, distraction-free view of your document. You'll also see how to turn your slides into animated GIFs in PowerPoint 365. And in Excel 365, you'll learn how to use the new XLOOKUP formula, which allows you to look up values both vertically and horizontally.


  • Learn how to use read and focus mode
    Export your presentation in different formats
  • Use the vlookup, hlookup and xlookup formulas to cross-reference data lists and check for missing values


  • 5m 33s
    Word 365 features a Read Mode that can be useful if you want to read your document, with a limited interface. Once the read mode is active, you can browse your document and still access certain tools. You can also access the Focus mode if you need to read your document free from the tool ribbon. FREE ACCESS
  • 5m 39s
    If you want to share your presentation with a user who does not have PowerPoint 365, you may have to convert your document. The program features a wide variety of formats that can be used to store your presentation. You can even export individual slides as images. FREE ACCESS
  • Locked
    3.  Cross-referencing data with formulas in Excel
    6m 21s
    In Excel 365, you can use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists. This is useful when checking for missing values in your lists. You can also use XLOOKUP for finding data in a table or data range in one list by using a search term from another list. FREE ACCESS


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.