Content Provider
Accountingtoolsinclogo

Self-Study CPE
BILL DEMO: STREAMLINE CASH FLOW WITH INSIGHTS & FORECASTING
View Details/Register
UNLOCKING FINANCIAL EFFICIENCY WITH RAMP
View Details/Register
BILL SPEND & EXPENSE: THE POWER OF CLIENT ADVISORY SUCCESS AT PARABLE ACCOUNTING
View Details/Register
Self study cpe
Excel Charts and Visualizations

EXCEL CHARTS AND VISUALIZATIONS

There is no video for this course. The learning materials for this course are in the downloadable document.
CPE Processing Fee$60.00
Webinar TranscriptionN/A
Presentation Length Hour(s)2.0 hours
CPE Credits 2.0 hours
CE Credits 0.0 hours
Course LevelBasic
Instructional MethodQAS Self-Study
PrerequisitesNone
Advance PreparationNone
Recorded DateMay 6, 2024
Date OfferedMay 6, 2024
Expiration DateMay 6, 2025
Course Description

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.



Not logged
Additional Materials
HANDOUT AND GLOSSARY
Review Questions
Review Questions
Frequently Asked Questions
  • 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.

Loading ...

Loading ...
Linkedin
Accountingtoolsinclogo

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
Logo qas

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

Accountingtoolsinclogo
AccountingTools, Inc. is focused on providing information on all possible accounting topics to the practicing accountant. We have developed more than three hundred online training classes, 50 softcover books, and issued over 4,000 articles on accounting topics, as well as hundreds of podcast episodes. We also have a strong focus on minimizing our environmental impact.