CCH Trust Accounts: Transaction Reporter and MS Excel Reporting Training

Overview

This course is an introduction to Transaction Reporter and demonstrate its ability to mine data held in CCH Trust Accounts and produce reports in Microsoft Excel.
This course provides training in the creation of reports using CCH Transaction Reporter by the extraction of data from CCH Trust Accounts to produce reports In MS Excel and MS Word presentations.

Course Duration: This course consists of two onsite or online sessions. Each session will last up to 3 hours.

Key Objectives

Produce reports from the data held in CCH Trust Accounts
Produce a client list including data held in the user defined database
Format reports to change the appearance of fields within the report
Provide an analysis of cross client investments
Produce graphs showing the largest clients by market value as a proportion of total funds under management
Produce a pie chart showing the breakdown of a client’s portfolio by region
Format data in the MS Excel worksheets to produce an MS Excel report, chart and tables of figures

Course Contents

Session 1	Session 2
Accessing Transaction Reporter About Report Levels The Report View Modes Working in Preview Mode Working in Design Mode Working with Formulae More Advanced Formulae Working With Additional Fields	Working with User Defined Database Fields The Report Design Area MS Excel reporting to produce graphs, pie charts and tables of figures Formatting, and set up of automatic embedded reports in a MS Word document Running reports for a single client or across all clients Running reports for multiple clients in a single operation, producing one spreadsheet or document for each

Pre-requisites

Attendees should adhere to the Training session Guidelines.

All attendees should have a good understanding of CCH Trust Accounts and MS Excel.

Who is this course designed for?

CCH Users

CCH Champions

Administrators

Useful Resources

eLearning courses - online courses that provide you with an overview and insight into our software
Bitesize videos - Compliance and Non-Compliance - showing you how to use features (and also some specific focused areas) of our software
Webinars - sessions for you to attend and learn from