Cart 0
K2's Excel's Best New Features - On Demand (2 CPD Hours)

K2's Excel's Best New Features - On Demand (2 CPD Hours)

Course Description

 

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, 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 Covered

  • New functions available in Excel 2016 and newer, including subscription-based Excel versions
  • How to collaborate more effectively in newer versions of Excel
  • The importance of Dynamic Arrays and related functions
  • The continued evolution of Power Query

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

    • CPD credit: 2 hours Computer Software and Applications
    • Prerequisites: Fundamental understanding of Excel spreadsheets
    • Program level: Intermediate
    • Advance preparation: None
    • Who should participate: Accounting, financial, and business professionals Accounting, financial, and business professionals who want to work with Excel spreadsheets more efficiently and effectively

    Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.