It can be difficult to convey the meaning derived from a spreadsheet, especially when there are large amounts of data involved. An excellent solution is to use the charts and other data visualization tools contained within Excel. In the Excel Charts and Visualizations course, we discuss how to create and modify charts, the many types of charts and when they are most applicable, advanced charting practices, sparkline graphics, custom formatting codes, shapes, icons, and dashboard concepts – everything you need to achieve the best possible presentations.
Learning Objectives:
- Evaluate the nature of the ribbon system and how it is used
- Describe the purposes for which the different types of charts can be put
- Identify the characteristics of a chart sheet
- Recognize the commands used to adjust charts
- List the characteristics of each type of chart
- Determine how a data series used in a chart is manipulated
- Summarize the formatting options for sparkline graphics
- Outline the formatting codes needed for different types of numeric presentations
|
Self-Study Course Instructions: FOR DOCUMENT-BASED COURSES Download the course document(s) (below) and follow prompts contained in the document. |
- CPAacademy self-study courses are online.
- The self-study format allows you to a) access the material online 24/7 and b) study at your own pace.
- Per NASBA guidelines, you have one year from date of purchase to complete each program.
- Complete your final exam at any time and get graded instantly. You can retake the exam at no additional charge (unlimited attempts).
- Print your own certificate of completion on the spot upon passing the exam.
- Grading policies: a) courses have a minimum passing score 70% b) test takers will not be provided feedback on failed exams.
- Upon achieving a passing score, test takers will be notified of the correct answers to the questions missed.
Steven Bragg, CPA, is the founder of AccountingTools, Inc. He is the author of more than 300 business books and courses, including the best sellers Cost Accounting Fundamentals, The CFO Guidebook, Closing the Books, Payroll Management, and The GAAP Guidebook. He has been the CFO or controller of both public and private companies and has been a consulting manager with Ernst & Young and an auditor with Deloitte. He holds an MBA from Babson College, a Master of Finance degree from Bentley College, and a BA from the University of Maine. He also manages the Accounting Best Practices podcast.
Away from work, Steve has been a two-time president of the Colorado Mountain Club and has climbed five of the seven continental high points, the 100 highest peaks in Colorado, the 100 highest peaks in New England, and all 50 of the state high points of the United States. He has also solo mountain biked the 483-mile Colorado Trail - both ways. He is an expert alpine skier, trail running author of Run the Rockies, and a PADI-certified Master Diver.
NASBA Approved
CPAacademy.org (Sponsor Id#: 111889) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222
About Our Presenter
- CPE Credits
- Support and FAQs
- Terms and Conditions
- Privacy Policy
- CPAwebengage, Inc.