K2's Road to Excellence - Part 20
Excel Guru, Part 5 Array Formulas and Zoho Books

Array formulas, which work on arrays of data rather than individual cells or ranges, allow users to make calculations that would otherwise be impossible with ordinary formulas. They can perform multiple discrete calculations in a single cell or return results to multiple cells. For example, an array formula can be used to round off totals or subtotals, a feat that is impossible to accomplish with an ordinary formula.

Learning Objectives

  • The different types of arrays
  • Creating an array
  • Using array constant
  • Conditional array formulas
  • Array formulas in Rolling Reports

Zoho Books

Zoho was born in the cloud. Today, we have over 45 online applications that help 40 million users run their entire businesses on Zoho.

During the webinar, we'll walk through Zoho Books, Zoho's cloud accounting platform for Canada. We'll also briefly talk about Zoho's other finance apps: Inventory, Subscriptions, and Expense, as well as how they help a modern businesses offer an integrated accounting experience.

Upon completing this webinar you are eligible to apply for the Zoho Consultant Program, a partnership that allows accountants, bookkeepers and consultants to offer the expansive suite of Zoho apps to their clients.

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

Zoho Question
Answers
How are the banking passwords stored? How secure is the storage? Where is the server located? 
Zoho Books is integrated with a third party service provider - Yodlee for banking integrations. Yodlee is one of the top players in this business used by our competitors as well. Zoho does not store banking credentials.The data for Zoho’s US and Canada customers is stored in Zoho’s data centers in the United States. We are currently in the process of opening data centers in Canada for Canadian customer data.
You said there is one login. How do you give your employees their own login?
By one login, I meant that a single user can login to all the 45+ applications of Zoho using the same set of credentials. For each user, the login is definitely separate and you will be able to provide restricted access roles for employees within the applications.