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, Sortyby, Filter and Unique. What use 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

Adagio and Excel - Useful Integration in the Accounting Department
Excel is the most popular accounting module on the planet. The ease with which you can move data in and out of your accounting software will contribute significantly to your quality of life!

Find out the comprehensive integration with Excel that Adagio offers, including:
  • Template driven imports and exports for all master and transaction file
  • An ExcelDirect button that drops any grid directly into Excel as a formatted table
  • An ExcelDirect button in the financial reporter that can send a full set of financial statements to Excel as a single workbook
  • ExcelDirect Print buttons on all major module reports that send the most important reports to Excel already formatted as a table
  • Adagio GridView which allows the easy generation of custom inquiries into the accounting data
  • Adagio ODBC which allows industry standard tools to connect directly to the accounting data

Learning Objectives

  • Discuss the need to transfer data between the accounting and other software
  • Learn the benefits of Excel tables
  • See how Adagio allows easy integration with external systems
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