K2's Road to Excellence with Excel Part 4 and Telpay

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

This is an On Demand webinar lasting 1 hour.

Learning Objectives

  • Review of printing basics
  • The important print settings
  • Defining what to print
  • Headers and Footer
  • Using the Camera

Expand Your Service Offerings with Telpay for Business™

Bill payments are just the beginning with Telpay for Business. Learn how you can offer additional services to your customer base in the areas of currency conversions and forwards and mobile time tracking & payroll. Telpay continues to expand its product and payroll partner program with the addition of TelpayFX and PayTickr.

Learning Objectives
  • Understand how Telpay FX enables you to offer a new service to your customers with currency exchange requirements
  • Understand the benefits and efficiencies provided to your customers by PayTickr, the most recent addition to Telpay’s Payroll Partner Program, including GPS-enabled location tracking of employees and the ability to control cash flow by future-dating your source deductions separate from your payroll submission.
  • Position Telpay for Business as a comprehensive solution to your customers’ electronic payment service needs.

Earn Verified CPD


Access the many courses from the leader in providing CPD to professionals throughout North America.
K2's Excel PivotTables for Accountants
Catalogue of upcoming webinars

Questions & Answers From This Webinar

Excel Questions
Answers
Are the margins in inches or metric?
My margins are in English. If you go to File|Options|Advanced|Display under the ruler box you can change it to centimeters
if you set the parameters in page set up will it automatically apply to any new sheets that are added or dragged into your workbook?
No, it won’t. Check out the section in my notes about print settings on multiple sheets.
Can Watermarks be printed/included in Excel?  I always have had to print to PDF and then add the Watermark to the PDF document.
Unfortunately getting a watermark into Excel is not an easy task. I sure wish you could do it the same way as you do in Word. Click on this link to see how to add a watermark in Excel.
How do you get that quick print button in your home menu?
Check out this link.
Is it possible to use the camera feature from one workbook into another, as opposed to just different sheets in the same workbook?
Absolutely you do it the same way.
Where do you find the camera if you don't want to add it to your quick bar? And does this work to insert into a word document?
You can add the camera tool to a custom group on the ribbon if you prefer not to add it to the quick access tool bar. You can insert it into a Word document. Check out this video.
I may have missed it.....how do we add the camera to the quick access toolbar?
See above.
Are the videos that are sent to us stored remotely?  If so, how long are they available?
The webinar recordings are available to view from our YouTube channel and will be accessible for 24 months.
Question on printing --- if you have one column, say 100 lines long, and you want lines 1-50 to print on the top left, then lines 51-100 to print starting at the top right, so it's all on one page in 2 columns, how do you do that?
One way would be to create a recorded macro that would first move questions 51-100 up to the top right, print the selection and then move everything back the way it was. Not difficult to do. Or you can setup a separate sheet and use the camera tool to do the layout you want to use for printing.
Telpay Questions
Answers
Why would we use Telpay instead of our bank to make and receive payments?
Telpay has a great number of advantages. Please see a full list here.
Curiosity makes me ask- are you using Blockchain technology?
No, we are not using blockchain technology.
Can Telpay pay US vendors from customers USD chequing account and/or can customer receive USD into their USD chequing account?
 
Will Telpay develop the USD receiving function?
Getting USD money in is a really big problem for one of my customers.
You can pay US vendor using an USD account in Canada, but not using a USD account in the US.  Our collections service is not available for USD accounts at the moment. We don’t have in our near future any scheduled upgrade feature that includes receiving USD.
 
Via our partner AFEX, TelpayFX can accept incoming payments from the US but it would be USD converted into the customer's CAD account, not USD to USD.
Do you need to subscribe to Telpay first before you can use PayTickr and/or Telpay FX?
No you do not need to subscribe to Telpay before using Telpay FX or PayTickr.
Are there extra fees for YE reports?
T4’s are $3 per employee, includes the T4 Summary Report.
ROE’s are $2 per employee.