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