Skip to main content

Excel Power User Module 6: Time-Saving Techniques

Available Until

Self-study

2.00 Credits

Member Price $69.00

Non-Member Price $89.00

Overview

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. This is part 6 of a 10-part series Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Highlights

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

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.

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.

Non-Member Price $89.00

Member Price $69.00