K2's Excel's Best New Features - Updated for Excel 2021! (2 hours)

K2's Excel's Best New Features - Updated for Excel 2021! (2 hours)

  • $79.00


Description

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions and Office 2021, Microsoft continues to pack new features into the popular spreadsheet tool. Enhancements to data analysis tools, new functions, and improved collaboration opportunities are available in more recent Excel versions. For those who know about these new features and apply them, exciting opportunities for improved productivity await. Take advantage of this opportunity to learn how you can put Excel’s best new features to work right away! 

Major Topics

  • Learn how to work with Dynamic Arrays
  • Using Excel’s new XLOOKUP and XMATCH feature
  • Improvements to Power Query and why the matter to you
  • New collaboration and commenting options in Excel

Learning Objectives

Upon completing this course, you should be able to:

  • Apply primary new functions available in Excel, including STOCKHISTORY, SORT, and FILTER
  • Employ Excel’s co-authoring feature to collaborate in real-time with other users
  • List at least three new functions that capitalize on Excel’s Dynamic Arrays feature
  • Utilize Excel’s XLOOKUP and XMATCH functions to locate data in spreadsheets

    Course Information

    • CPE credit: 2 hours Computer Software and Applications
    • Prerequisites: Fundamental knowledge of Microsoft Office Excel
    • Program level: Intermediate
    • Advance preparation: None
    • Who should participate: Accounting and business professionals seeking to use Excel’s newest features