K2's Road to Excellence - Part 12
Dynamic Arrays and Doc.It
Wednesday September 11, 2019 at 12.00pm ET


A new type of formula group is coming to Excel for Office 365 - Dynamic Arrays. In this session we will introduce you to this group of powerful new formulas including Spill, Sort, Sortby, Filter and Unique. What used to be complicated is now simple with these functions.

Learning Objectives

  • What versions of Excel support Dynamic Array Formulas
  • How to refer to a Dynamic Array result
  • How to correct for spill errors
  • How to use Sort and Filter

Managing Excel Documents and Improving Workflow Efficiency with Doc.It
Now that you’re an Excel guru, learn how Doc.It helps you organize Excel documents with our Document Management solutions. In addition, we’ll take a look at one of the hottest technology topics in the industry, improving workflow efficiency.

Learning Objectives

  • Learn how Doc.It manage Excel documents, as well as all other document types
  • Learn how Doc.It helps accounting firms improve workflow efficiency and keep track of all projects
  • Learn how document management & workflow software integrates with your firm’s existing software (tax, accounting & bookkeeping, time & billing, etc.)
Earn verified PD credits - Attendees must answer at least 75% of poll questions during the live webinar to earn 1 verified PD credit. Attendees who do not answer at least 75% of poll questions during the live webinar earn 1 non-verifiable PD credit.

Register to attend a live webinar and you'll receive the link to the recording and the teaching files within 10 days of the session. Recorded webinars can be viewed when it's convenient for you at the office or at home, and on any device. 

More Ways to
Earn Verified CPD


Access the many courses from the leader in providing CPD to professionals throughout North America.
Catalogue of upcoming webinars