Skip to main content

The WSCPA office is closed except for special events and prearranged visits. You can reach staff during business hours via phone, email or live chat (scroll to bottom of page for contact info).

Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check WEBCAST

Thursday, December 15 11:00am - 1:00pm PST

Add to Calendar

Your Desk

2.0 Credits

Member Price $109.00

Non-Member Price $131.00

Overview

We start by discussing dynamic headers, and how important they are when automating reporting workbooks. Next, we review how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports. We review the idea of mapping tables and show how they are the key to unlocking major efficiency gains. Lastly, we use data validation in our digital reports and review a critical worksheet that belongs in just about every recurring-use workbook: ErrorCk.

Highlights

Dynamic headers, mapping tables and error check.

Prerequisites

Working knowledge of Excel.

Designed For

Anyone who wants to increase their knowledge of Excel.

Objectives

Create dynamic headers. Create horizontal reports. Use mapping tables. Use data validation to provide dynamic reports. Improve error checking. Apply 10-plus features, functions, and techniques in a single user workbook.

Preparation

None.

Notice

None.

Leader(s):

Leader Bios

Jeff Lenning

Jeff Lenning, CPA, CITP Click Consulting / Seal Beach, CA Jeff Lenning, author of Excel University, is an award-winning Excel instructor who has provided continuing education to thousands of CPAs nationwide over the past 10 years. He is a Microsoft Certified Excel Expert, and his Excel articles have been featured in trade publications such as the Journal of Accountancy and California CPA. He is a former chair of the California CPA State Technology Committee, and has held a variety of other leadership positions within his local CalCPA chapter. He worked at Arthur Andersen, Gateway computers, and Interpore Cross International. In 2000, he started Click Consulting, a technology consulting firm.

Return to Top

Non-Member Price $131.00

Member Price $109.00