Optimizing Excel Charts 2016

Key Topics

• Creating self-updating chart titles that are linked to formulas within a worksheet cell
• Learning about new chart types in Excel 2016
• Exploring the Recommended Charts feature in Excel 2013 and later
• Enlivening your charts with clip art in any version of Excel
• Learning why certain features, including slicers, sparklines, and charts, are disabled in some workbooks
• Learning to avoid repetitive formatting by using chart templates and determining where this feature was relocated in Excel 2013 and later
• Using the SUMIF function to summarize data based on a single criterion
• Summarizing complex data sets quickly with Excel`s PivotChart feature
• Using the Table feature to create charts that expand or contract automatically as your source data changes

Who should Attend

• CFOs
• Accountants and CPAs
• Controllers
• Financial Consultants
• Human Resources Personnel
• Accounting Personnel