K2's Road to Excellence with Excel Part 9 and Adagio

This is the ninth of sixteen sessions in Excel that will provide you with the information you need to become an Excel expert. This session will focus on a continuation of formula tips.

In this session we turn our attention to formulas that are even more powerful than those previously discussed. With a firm grasp on the techniques covered in this webinar, you will be able to create accurate calculations more quickly and easily than perhaps you ever imagined.

Learning Objectives

  • Understanding Conditional and Boolean Calculations
  • Using Conditional IF Functions
  • Summarizing Data with SUBTOTAL
  • Customizing and using Error Checking
  • Manage Circular References

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 from the Webinar

Adagio Questions
Answers
How many First Nation organizations in Canada are using Adagio? How many in Ontario?
There are over 200 first nations organizations and businesses using Adagio across Canada. the majority of those are in BC and Northern Ontario.
Does Adagio allow entering costs for projects and then reporting for those projects separately?
Absolutely. Costs might come from PurchaseOrders/Payables, OrderEntry/Receivables or JobCost (depending on their industry and what ‘project’ means to them), and reports or inquiries can be generated from that information, perhaps a custom report depending on what information they need and how they want it organized. Ledger/Financial Statements can also print reports on the Cost Accounts, though it depends on what ‘project’ means to them whether these reports would be useful in this specific regard.