When you need a report that isn’t provided by your accounting system, you probably turn to Excel. Many accountants export data, such as a trial balance, to Excel and then manually create the desired report, such as a balance sheet. Manual steps typically include translating labels, such as translating the account name Cash to the report label Cash and Cash Equivalents, as well as summing several accounts into a single report line.
This session discusses a powerful technique called mapping tables that helps to automate the flow of data from the export to the report, even when labels are different and when many data rows need to be aggregated into a single report row.
Join us as the author brings his popular April 2014 Journal of Accountancy article “The Power of Mapping” to life by presenting the relevant Excel features and functions. You don’t want to miss this special event.
Excel University
Author of Excel University
jeff@excelu.com
(949) 200-7688
CPAacademy.org (Sponsor Id#: 111889) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222