Curriculums:   Computers and Technology,Young and Emerging Professionals,Business and Industry

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

Description

The Excel Power User series helps you improve your Excel proficiency and quickly complete tasks.

In this session, apply numerous features and functions examined in previous sessions in a variety of time-savings techniques. Continue to integrate these features as we proceed throughout the series.

Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac.

Major Subjects

• Dynamic Headers.
• Horizontal Reports.
• Mapping Tables.
• Data Validation and Reporting.
• Improving Error Check with Boolean Values and the Logical AND Function.

Objectives

• Identify which function help build dynamic report headers.
• Recall a technique that helps Excel translate a data label to a report label.
• Recognize which feature can be used to provide a filter for dynamic digital reports.

Level:  Overview

Designed For

Accounting professionals that use Excel for Windows.

Advanced Prep:

None.

Prerequisite

Excel Power User Modules 1-5 or knowledge of the topics covered.