Skip to main content

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

-

Add to Calendar

Online/Webcast

3.50 Credits

Member Price $125.00

Non-Member Price $155.00

Overview

You’ll examine diverse application of Excel capabilities, functions, and techniques to create a cohesive workbook.

Highlights

  • Dynamic headers
  • Horizontal reports
  • Mapping Tables
  • Data Validation
  • Improve error checking
  • Concepts applied

    Prerequisites

    Working knowledge of Excel

    Designed For

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

    Objectives

    • Apply dynamic headers and horizontal orientation for reports.
    • Use mapping tables to automate formula-based reports.
    • Use data validation to provide dynamic reports.
    • Apply error checking for worksheets.
    • Determine appropriate use of features, functions, and techniques in single user Excel workbook.
  • Non-Member Price $155.00

    Member Price $125.00