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 10: Getting, Preparing and Summarizing Data | EPU10OD19
Add To Cart
Product Code :
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
Excel Power User Modules 9
or knowledge of the topics covered.
This session continues the discussion about external data and digs into the details for retrieving data from other sources. Pull data from an Access database using Microsoft Query; learn how to retrieve data from simple text files; and prepare data for use with Excel. This session concludes by examining several data visualization tools in Excel, including PivotCharts.
This is part 10 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
State the process for creating a PivotChart.
Recognize the option that imports external data directly into a PivotTable.
Recall which Excel feature creates a chart within a single worksheet cell.
Major Topics :
Accounting system data
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