Collaboration & Communications
  • Course Overview
  • Quick note
  • Module 1 Introduction
  • Improved Collaboration - What are the changes?
  • Sharing
  • What are notes
  • Comments and Mentions
  • Notes Comments and Mentions
  • Translations in Excel
  • Natural Language Search
  • Help and Natural Language Search
  • Activity
  • Quiz
Performance Improvements
  • Module 2 overview
  • What changes have been made to Saving and Restoring files
  • Restoring files
  • What improvements have been made to Accessibility
  • Accessibility
  • What other Other general performance improvements have been made
  • What are Ideas
  • Ideas
  • How to deselect extraneous cells
  • the Left Click trick
  • test your knowledge
  • Activity
  • Activity solution
Working with Functions
  • Module 3 Introduction
  • Understanding IFS
  • IFS
  • How to use SWITCH
  • SWITCH
  • How to use TEXTJOIN
  • TEXTJOIN
  • TEXTJOIN nested IF
  • 8 limitations of VLOOKUP removed with XLOOKUP
  • How to use XLOOKUP
  • XLOOKUP - Exact Match
  • XLOOKUP - Match modes
  • XLOOKUP - Search mode
  • test your knowledge
  • Activity
  • Activity solution
charting, visualizations
  • Module 4 Introduction
  • What enhancements have been made to images and graphics?
  • 3D images and SVG icons
  • Funnel charts
  • How to insert a funnel chart
  • Inserting and working with Filled Map Charts
  • How do I create and understand Box and Whisker charts
  • Box and Whisker plots
Pivot Tables and Excel Power Tools
  • What are rich data types?
  • Using Rich data types
  • Changes and Improvements to Pivot tables
  • Adding columns by example
  • Course Conclusion