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 1: Fundamental Features | EPU1OD19
Add To Cart
Product Code :
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In the first session, we'll cover the fundamental features that help build a solid foundation.
We'll continue to integrate these features as we proceed throughout the series.
This is part 1 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
Recall at least three shortcuts to improve your speed.
Recognize which feature allows you to control what a user can type into a cell.
Identify the feature that enables you to name cells and ranges.
Major Topics :
Named references tables
Conditional formatting basics
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