Excel Power User Module 6: Time-Saving Techniques | EPU6OD19

Product Code :
Format :
Level :
Designed For :
Accounting professionals that use Excel for Windows.
Field of Interest :
Computer Software And Applications
Prerequisite :
Excel Power User Modules 5 or knowledge of the topics covered.
Credits :
2.00 CPE
Description :
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
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.
Major Topics :
  • Dynamic Headers
  • Horizontal Reports
  • Mapping Tables
  • Data Validation and Reporting
  • Improving Error Check with Boolean Values and the Logical AND Function
Advanced Prep :
About the Author :
Lenning Jeff S - Jeff S Lenning is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. He specializes in providing computer consulting services to CPA firms and their clients.