Excel Power User Module 10: Getting, Preparing, and Summarizing Data | EPU10OD16

Product Code :
Format :
Level :
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
Prerequisite :
Excel Power User Modules 1-9 or knowledge of the topics covered.
Credits :
2.00 CPE
Description :
The Excel Power User series helps improve your Excel proficiency and enables you to get your Excel tasks done more quickly. This session continues the discussion about external data and digs into the details for retrieving data from other sources. You'll 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. Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac. The webcast was originally broadcast on May 31, 2016. Note: There is a minimum passing rate of 70% for this course.
Objectives :
  • 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 :
  • External data
  • Text files
  • Data preparation
  • Accounting system data
  • Getting graphic
Advanced Prep :
About the Author :
Lenning Jeff S - Jeff Lenning of Click Consulting, Inc., is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. His firm specializes in providing computer consulting services to CPA firms and their clients. Web site: http://www.clickconsulting.com