Data Visualization

LOOKING FOR RATES AND SCHEDULES TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

Data Visualization: Charting Like a Pro

This training aims to use MS Excel to create basic to advanced and interactive charts. The module focuses on navigating the interface of Excel to perform tasks that are not as straightforward as just creating a regular chart.

I. Introduction to Charting in Excel
• Creating Basic Charts
• Modifying Chart Formats
• Editing Chart Elements and When to Use Them
• Labels: Axis and Data Labels
• Data Points and Data Series
• Gridlines and Tick Marks
• Legends and Data Tables

II. Creating Special Charts
• Showing Relationships with Scatter Charts
• Sparklines
• Showing Flow of Numbers using Waterfall Charts and Bridge Charts
• Maximizing Area Charts
• Histograms
• Bubble Charts
• Showing Geographical Data with Map Charts
• Showing Hierarchy with Tree Maps and Sunburst Charts

III. Executing Complex Chart Concepts
• Charts with Triple Axis
• Creating Thermometer Charts
• Creating Gauge Charts

IV. Creating Interactive Charts
• Dynamic Charts using INDIRECT
• Dynamic Charts using OFFSET
• Dynamic Charts using Pivot Charts

V. Linking Charts to PowerPoint
• Linking Charts from Excel to PowerPoint
• Embedding Charts
• Using Paste Special to Link Charts