Optimizing Excel Charts

Optimizing Excel Charts

Instructor: David H. Ringstrom
Product ID: 501069
Level: Intermediate

Description
This online training will cover areas like Excel’s Table feature, self-updating chart titles, formatting chart elements, Excel’s Pivot Chart feature
Charts have evolved over the years so David will teach from Excel 2010 and Excel 2016. Chart functionality in Excel 2007 is almost identical to Excel 2010, while chart functionality in Excel 2013 and 2016 are very similar. David will provide handouts that provide the exact steps to follow in the respective Excel versions, so he has you covered no matter what version of Excel you're presently using.

Objectives of the Presentation
Use Excel's Table feature to create charts that expand or contract automatically as your source data changes
Determine how to create self-updating chart titles
Convert a chart into a picture and understand why this is particularly important for Excel charts used in PowerPoint
Use lookup functions to chart subsets from a larger table of data
Create rolling charts that automatically shift to cover a new range of time periods
Standardize chart formats by creating and using chart templates
Enliven charts by inserting clip art
Implement the Sparklines feature in Excel 2010 and later, and see how to replicate the functionality in Excel 2007
See which charting features are disabled when you create charts in obsolete. XLS workbooks instead of the modern. XLSX format

Why Should you Attend
Excel users often encounter a great deal of frustration when creating charts. This presentation describes how to streamline creating and managing charts, and explores nuances that often slow Excel users down.

Areas Covered
Using Excel's Table feature
Self-updating chart titles
Formatting chart elements
Getting started with Excel's Pivot Chart feature
Inserting clip art
Charting subsets with Excel's lookup functions
Utilizing Excel's Sparklines feature

Who can Benefit
Accountants
CPAs
CFOs
Financial consultants
Controllers

For Registration -
http://www.onlinecompliancepanel.com/webinar/OptimizingExcelCharts-501069/OCT-2015-ES

Note : Use coupon code 1371 and get 10% off on Registration