Click Here For More Information
- There were no results found.
- There were no results found.
Microsoft® Excel Charts will demonstrate to the Excel user how to create effective charts off of spreadsheet data. A discussion of chart basics will be featured along with the creation of column charts, pie charts, three-dimensional charts, and a variety of chart formatting techniques. The user will also be exposed to more advanced charting such as secondary axis charts, combination charts, the Pie of Pie chart, and adding a trendline.
IMPORTANT INFORMATION ABOUT PARTICIPATION: As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes). These may come in the form of open-ended questions, hand-raising, polling, and other techniques. You MUST answer or respond to all three opportunities to engage in order to receive credit for that CPE hour. Knowledge Source Inc. retains these responses after all CPE classes for audit purposes.
Objective: Upon completion of this course the user will be able to use charts and charting techniques to visually display their data graphically.
- Chart basics
- Common do’s and don’ts
- Exploring the data source
- Switching row and column data
- Column charts
- Two-dimensional charts
- Three-dimensional charts
- Chart Formatting
- Color fills and lines
- Axis editing
- Data points and labeling
- Pie charts
- Adding data labels
- Rotating 3D charts
- Exploding slices
- Advanced Charts
- Secondary Axis
- Combination charts
- Pie of Pie charts
- Adding a Trendline
Knowledge Source Inc. 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.
