K2E Canada Inc
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG

K2's Road to Excellence - Part 16
Integrating Excel with Word & PowerPoint and TaxCycle

VIEW THE WEBINAR
QUESTIONS & ANSWERS
TEACHING MATERIALS
Excel is the accountants' tool of choice for analyzing data, but their analyses often find their way into formal reports and presentations. Most accountants and business professionals use simple cut-and-paste processes or rekey their analyses to integrate them into Word and PowerPoint; however, these Microsoft Office products offer a full range of options for integrating data among and between them.

This session contains all of the tips, tricks, and techniques necessary to ease the process of integrating Excel with Word and PowerPoint.

Major Topics

  • Embedding Objects in Office Applications
  • Pasting Excel into Word
  • Linking Cells into Word
  • Pasting Excel Charts into Word or PowerPoint


Excel Import into TaxCycle

Picture
Put your mastery of Excel to work with TaxCycle. Speed up your tax return preparation with Excel import into TaxCycle files.

Learning Objectives

Upon completing this session, you should be able to:
  • Generate from TaxCycle a custom Excel template for any form
  • Import a T2125 business statement from Excel into TaxCycle T1
  • Import T4 slips from Excel into TaxCycle T4

Speaker: Elizabeth Kohl
Director of Communications and User Experience
Trilogy Software

 
Veteran presenter of tricky topics for TaxCycle webinars and author of the TaxCycle online documentation, Elizabeth delights in helping preparers make the most of TaxCycle.

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
What happens to the links when you email a linked Word doc? 
The link information will remain in the file, however the Word file will not update when the Excel file updates. If you need the data to update then provide a link to the file in the email instead of the file itself.
TaxCycle Questions
Answers
Can TaxCycle import from accounting software or only Excel?
TaxCycle does not directly integrate with accounting software for the purposes of importing data, but if the software can produce CSV or Excel files that you can modify to get into the Export worksheet for a form in TaxCycle, you can import the information.
 
TaxCycle can also import GIFI (General Index of Financial Information) files from Accounting for Practitioners (AFP), CaseWare®, QuickBooks® Desktop (using the CSV of a report, see below), QuickBooks® Online Accountant, CCH Engagement,  Sage® and
CSV files you create yourself in Excel. See this help topic for details: https://www.taxcycle.com/Documentation/Preparing-returns/Import-data/Import-GIFI

Training & Education

Webinars
Upcoming Events
Road to Excellence Online Seminar
Seminars
Conferences
Instructors

Tech News

K2E Canada's Tech Update Newsletter

More

Privacy Policy
About
Contact

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