Microsoft Office Excel 2007 Charting and Advanced Visualizations

This session is geared around business intelligence.

• What’s New in Excel 2007 Data Visualization

Top/Bottom Conditional Formatting

Conditional Coloring of Proportional Data Bars

Heatmaps

Sparklines

Chart Reference Points and Lines

Histograms

Labeling X-Y Scatter Charts

Floor Plan Conditional Formatting

• Charting

New UI: Ribbon, Modeless dialogs, Context Menus

Consistent experience across Excel, Word, and PowerPoint

Enhanced graphical effects

Publishing of charts to Excel Services

• Conditional Formatting

New UI for managing rules

Predefined cell highlighting rules

Data bars

Icon sets

Color Scales

• Example Excel file:

BIN303_Demo File (finished state).xlsx can send it to you if interested.  Have it on my desktop.

• It looks to me that charting is fairly easy provided that you do the research to learn the details.  Of course the instructor was moving so fast that I will never remember.  But, it is really cool the new easier features that have been added to allow us to create charts.  This stuff would be really useful for Jody and Deb for the monthly reporting that they do.  It would really spruce up our Excel reporting.