K2's Road to Excellence - Part 5
Excel and Adagio

This is the second of the 2019 Excel Guru sessions series that will focus on Excel Tips and Tricks.

How much do you know about Excel and the features and functionality it provides that could make a difference in your personal day-to-day productivity? Most accountants and other business professionals use less than 20% of the functionality of this product. Are you taking advantage of the features that are best for you? This session is sure to deliver many thought-provoking ideas and tips for getting better results with less effort and in less time.

Learning Objectives

  • Identify key productivity-enhancing Excel functionality and features
  • Differentiate between Excel functions and features to obtain the best fit for your objectives
  • List capabilities that have direct application to your practice or business
  • Apply the knowledge gained to improve your personal productivity

Adagio Financial Reporter
Financial statements form the heart of any accounting system, bringing together the final resting place of all the debits and credits. Entry level products such as Sage 50 or Quickbooks provide a basic set of statements, more than adequate for most small businesses. But what about larger organizations? Not-for-profits reporting to different stakeholders such as operational managers, directors, funding agencies and auditors. How can the different reporting needs of these constituencies be met? Adagio is designed specifically to meet the needs of accounting professionals.

The Adagio Financial Reporter is a full spreadsheet, with all the computational horsepower of Excel and most of its formatting capability. With Adagio, you won’t have to spend weekends in Excel generating operational statements for your managers and Directors. We’ll give you a guided tour of the powerful financial reporter so you can see how simple life can be.

Learning Objectives

  • See how financial statement format can be independent of the chart of accounts
  • Find out how adding an account or department can be automatically accommodated without having to edit a financial statement
  • Group financial statements together to create a complete set of statements for a bank, director or funding agency
  • Distribute reports as PDFs or Excel Workbooks
  • Drill down from a number on the statement to the underlying details and balanced journal entry
  • Access a source document PDF with a single click of the mouse

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

Questions & Answers

Excel Questions
Answers
I have Microsoft Office 365 Business but do not see the "Inquire" add-in.
Inquire is only available in the Office 365 ProPlus and Enterprise editions. You can upgrade your subscription to gain access to Inquire and several other advanced features. Inquire is also available in the perpetual license versions of Professional Plus starting with 2013.
Adagio Questions
Answers
Can Adagio do a rolling twelve month P&L?
Yes
Didn't Adagio have a module that could be used to export from Sage 50 desktop and use that for financial statements but still be able to be connected back to Sage and drill down on numbers or change date and change the report?  Can this financial reporter be used that way?  Price?
Yes – Adagio FX. Budgets must be maintained in Adagio FX, not in Sage 50. Price is $1,600 + 20%/year for Upgrade Plans.
Can documents be attached to a 'Job number"?
We have not yet released Adagio JobCost 9.3A which will include Document attachment, but this functionality is planned for that time.