Jeff Lenning, CPA, CITP


    Credit Info
  • NASBA Field of Study

    Specialized Knowledge

  • Format

    On demand

  • Level


  • CPE Credit


  • Course acronym

  • Prerequisites

  • Course duration

    2 Hours

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

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. The webcast is designed with time for you to work along. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows.
Hurry up, special offer for a limited time only.
Topics discussed

Learning 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.

Who will it benefit?

Accounting and finance professionals who’d like to improve their mastery of Microsoft Excel