Skip to main content
SQ Taxation Committee Discussion Forum | M2030820
August 5, 2020
San Joaquin Valley
Add to Cart
Redirecting to cart, please wait...
has been added to the cart.
items(s) in your cart.
My Activities (NEW)
My CPE Tracker
My Certificate of Completion
My Communication Preferences
My Transactions / Discounts
My Membership / Open Invoices
Who We Are
CPA Career Center
Exclusive Members Savings
Committees & Sections
New! Find CPE
Core Staff Training
Contact Your Legislators
Advocating for CPAs
California CPA Magazine
Peer Review: Firm Resources
Peer Review Reports
Peer Review: Reviewer Resources
CPA Job Board
Search for Ads
Place an Ad or Résumé
Find a CPA
Ask a CPA
CPA License Lookup
Governmental Accounting White Papers
Events and Programs
Excel Power User Module 6: Time-Saving Techniques | EPU6OD19
Add To Cart
Product Code :
Designed For :
Accounting professionals that use Excel for Windows.
Field of Interest :
Computer Software And Applications
Excel Power User Modules 5
or knowledge of the topics covered.
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
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 :
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.
Powered by Azure Servers