Skip to main content
Go
Featured Event
Advanced QuickBooks Tips And Techniques Webcast | 4193600K
December 13, 2019
Webcast
Add to Cart
Learn More
Remember Me?
Magazine
Browse Articles
Current Edition
Archives
Events
Search
Facebook
Twitter
LinkedIn
Log In
Cart
Chapter Events
Find CPE
Donate
Join
Help
Login
Redirecting to cart, please wait...
has been added to the cart.
You have
items(s) in your cart.
Menu
My Account
Overview
My Profile
My Activities (NEW)
My CPE Tracker
My Certificate of Completion
My Communication Preferences
My Transactions / Discounts
My Membership / Open Invoices
My Committees
Members
Overview
My Account
Who We Are
Renew
Benefits
Chapters
CPA Career Center
Leadership
Member Directory
Exclusive Members Savings
Committees & Sections
Technical Resources
Listserves
Products and Services
Firms
Education Foundation
Overview
2017-18 Catalog
New! Find CPE
New! CPE Wizard
Conferences
CPE Weeks
Series
Self Study
Staff Training
Onsite Learning
Ethics Exam
Policies
Pricing
Government Relations
Overview
Grassroots Advocacy
Tracked Legislation
CPA-PAC Q&A
Grassroots Program
Contact Your Legislators
Advocating for CPAs
News
Overview
Hot Topics
California CPA Magazine
Financial Leadership Forum
Newsroom
Peer Review
Overview
Peer Review: Firm Resources
Peer Review Reports
Peer Review: Reviewer Resources
CPA Job Board
Overview
Search for Ads
Place an Ad or Résumé
Classified FAQs
Manage Ads
Ad Rates
Resources
Overview
Find a CPA
Ask a CPA
Media Kit
Financial Literacy
Good4Business
Disaster Recovery
CPA License Lookup
Licensure
Governmental Accounting White Papers
Events Search
Home
Events and Programs
Product Details
Print
Email
Share
Excel Power User Module 10: Getting, Preparing, and Summarizing Data | EPU10OD16
Add To Cart
Product Code :
EPU10OD16
Format :
On-demand
Level :
Intermediate
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 :
None
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
Powered by Azure Servers