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

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.