Excel Power User Module 6: Time-Saving Techniques

Overview

Financial models play a critical role in supporting business decisions. Learning to model the right way using a proven framework will help you become a more effective financial analyst. Join us as we build out several fundamental schedules, which will serve as a solid foundation for more complex analysis throughout the FMVA and your career.

Highlights

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

Prerequisites

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

Designed For

Accounting professionals that use Excel for Windows.

Objectives

• Identify which function can 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.

Preparation

None.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.