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 2: Fundamental Functions, Concepts, Techniquies | EPU2OD19
Add To Cart
Product Code :
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
Excel Power User Module 1
or knowledge of the topics covered.
Cover fundamental functions, concepts and techniques that provide a firm foundation for our workbooks.
Continue to integrate these items as we proceed throughout the series.
This is part 2 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
Determine why the SUBTOTAL function is preferred to the SUM function in many situations.
Identify a technique that helps ensure that a new row inserted between the last data row and the formula row is included in the total row formula.
Recognize at least three workbook design principles.
Major Topics :
Highlight input cells
Workbook design principles
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