Optimizing Excel Charts

Website http://www.onlinecompliancepanel.com/webinar/OptimizingExcelCharts-501069/OCT-2015-ES | Edit Freely

Category HMDA, Home Mortgage Disclosure Act, Mortgage Reporting, Mortgage Regulation, Mortgage Compliance, Red Lining

Deadline: October 15, 2015 | Date: October 16, 2015

Venue/Country: online Webinar, U.S.A

Updated: 2015-09-30 20:23:28 (GMT+9)

Call For Papers - CFP

Instructor: David H. Ringstrom

Product ID: 501069

Level: Intermediate

Description

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