O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

31. Using Data Visualizations and Conditional Formatting

Many people feel their eyes glaze over when they encounter a screen full of numbers. Fortunately, Microsoft has added terrific new data visualization features to Excel that make those screens full of numbers a little easier on the eyes.

Excel has had a weak conditional formatting feature since Excel 97. It was limited and tricky to use. Excel tipsters often showed the incredibly hard way to make conditional formatting just a bit more powerful.

Beginning with Excel 2007, Microsoft made data visualization easy to use. You are just a few clicks away from features that would have required a Ph.D. in legacy versions of Excel. The following are some of the possibilities in data visualization: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required