K2E Canada Inc
  • Home
  • TRAINING
    • SEMINARS
    • WEBINARS
    • CONFERENCES
    • ROAD TO EXCELLENCE WEBINAR SERIES
    • INSTRUCTORS
  • OFFICE TIPS
  • ABOUT
  • CONTACT
  • Home
  • TRAINING
    • SEMINARS
    • WEBINARS
    • CONFERENCES
    • ROAD TO EXCELLENCE WEBINAR SERIES
    • INSTRUCTORS
  • OFFICE TIPS
  • ABOUT
  • CONTACT

K2's Road to Excellence with Excel Part 15 and Intuit

VIEW THE WEBINAR
QUESTIONS & ANSWERS
TEACHING MATERIALS
This is the fifteenth in a series of sessions in Excel that will provide you with the information you need to become an Excel expert. This session will focus on array formulas. An array formula performs calculations on the data in one or more arrays, returning either single or multiple results, making them highly useful for carrying out many Excel calculations.

Learning Objectives

  • Explain array formulas and how they differ from ordinary formulas
  • Identify an array formula from the Formula Bar
  • Compose array formulas from the keyboard
  • Describe common accounting situations where array formulas would be useful
  • Understand array constants and how they are used

What's New in QuickBooks Online

Picture
Catch up on all of the biggest features and updates to QuickBooks Online from the
past quarter from the teams that built them.
 

Learning Objectives

See What's New in QBO
  • Sales Tax Updates
  • QBO Advanced Payroll powered by Wagepoint
  • Projects

See What's New in QBO Accountant
  • Practice Management
  • QuickBooks Tax

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

Excel Questions
Answers
Could we manually enter the {} instead of holding down the Shift, Ctrl and Enter?
No
When you type 'tran'..... and transpose shows...how do you select it so you don't have to type it all....enter does not work?
Double click on trans or press the tab key to have the autocomplete suggestion completed.
Idea for new seminar:  Excel functions you didn't know about.  Alan used two of them today:  Large, and Transpose.  I'm sure there are many I could use but don't know of.
Thank you. We will consider that.
Can Array Constants be used across workbooks similar to macros saved in personal workbook? Or must exist in each file?
No, they only exist in each file.
I still don't understand where you would use array constants. It seems to be a lot of work for very little benefit. Can you give us some examples where you would use this in practice?
If I am repeating certain text or values a number of times in a workbook I will create an array constant so I can enter the data quickly. With the array constant given a defined name it is very easy to use in a formula and avoid problems caused by people changing the workbook; for example deleting a cell in your constant values listed on a worksheet.
When using the Max formula, how do you automatically display the name of the item that corresponds to the max finding?
You could use index/match on the max result. Check out this YouTube video.
What is an example of a scenario(s) where you might make use of a constant array?
See above.
Intuit Questions
Answers
Can I use QBO Accountant version for work with a client's QB desktop file?
For ‘Work’ or the practice management space in QuickBooks Online Accountant – yes, you can use a desktop client in this space. You cannot however access the desktop client from this space.
Can a client upgrade the subscription from essential to plus in QBO without having to create a separate account?
Yes! Please see their subscription in the account menu.
I wish the Work Tab was the default when you sign into QBOA.
It can be! Bookmark the page when you're on Work.
Is Intuit improving the desktop edition of QB or is the focus only on QB online?
Intuit is still doing lots of work into improving QuickBooks desktop editions. We put out many new releases for 2018, and will continue to support it.
Why don't you have pre-filled G/L accounts for suppliers like in the desktop version?
We are working through a number of workflows, and I can say that we’re aware of this one. Keep up the feedback, that helps our product managers prioritize new builds in QuickBooks Online.
How do you get a QBOA account that a client has signed up for in error deleted?
Please give our support team a call – they can help out with this.
For GST payments, why doesn't the amount payable go directly in to the payables subledger like the desktop version for manual cheque processing?
We're working on it.

Training & Education

Webinars
Seminars
Conferences
Road to Excellence Webinar Series
Instructors

Tech News

K2 Office Tips

More

Privacy Policy
About
Contact
K2E Canada Inc.  |  591 Highway 221  |  North Kingston, NS Canada B0P 1R0  |  (902) 200-9207
© 2018 K2E Canada Inc. ALL RIGHTS RESERVED.