Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization WEBCAST

Overview

Are you familiar with the five workbook design principles that help us build reliable recurring-use workbooks? This session covers them, as well as workbook and worksheet organization ideas. We also discuss how, why and when to hide administrative worksheets. The importance of highlighting input cells, using selection groups and building formulas with nested functions are also explored.

Highlights

Excel workbook design principles and organization.

Prerequisites

Working knowledge of Excel.

Designed For

Anyone who wants to increase their knowledge of Excel.

Objectives

Hide worksheets and keep extraneous information out of sight. Highlight input cells, so the user sees which cells require manual entry. Organize workbooks and worksheets. Use nested functions.

Preparation

None.

Notice

None.