|
|
| Accelerate Excel: Maximizing Charts(151106_N) |
Course CPE: 2 hours
Field(s) of Study: Computer Software & Applications–2 hrs
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught. Such persons are often at a mid-level within the organization, with operational and/or supervisory responsibilities.
Advanced Preparation: None
Delivery Method: Self-Study |
Item
Number: 15PPM1106
Shipping Weight: 0lbs. 0oz. |
| Price:
$147.00 |
|
|
|
|
Recording Date: November 6, 2015
Presenter: David H. Ringstrom
Program Description:
In this webinar Excel expert David H. Ringstrom, CPA shares numerous techniques that your team can use to tweak and automate charts. David will focus primarily on Excel 2007 and 2010, but will answer questions specific to other versions, such as Excel 2003 and Excel 2013. Alternate instructions for Excel 2003 and earlier are included in the handout where applicable.
After completing this webinar, attendees will be able to:
- Use Excel charts more effectively
- Identify Excel’s Table feature to create charts that expand or contract automatically as your source data changes
- Recognize how to have chart titles update automatically
- Select multiple charts on a single chart sheet (as opposed to a worksheet)
- Determine how to convert a chart into a picture (and learn why this is particularly important for Excel charts you use in PowerPoint)
- Determine how to maximize Excel’s Pivot Chart feature
- Identify how to use look-up functions to chart subsets from a larger table of data
- Identify the new Sparklines feature in Excel 2010, and how to replicate it in Excel 2007
- Determine how to enable workarounds for features in Excel 2003 and earlier that are no longer available in Excel 2007 and 2010
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) 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. |
|
|
