In Microsoft Excel, new features are sparklines and slicers, and improvements to PivotTables and other existing features, can help us to discover patterns or trends in the data. In the previous post we had a look at the Sparklines and slicers features of Excel 2010 and Pivot table features of excel 2010, so now we will look at the improved pivot table feature of excel 2010.
Improved conditional formatting
Conditional formatting makes it easy to emphasize important cells or ranges of cells, highlight unusual values, and visualize data by using data bars, color scales, and icon sets. Excel 2010 includes further more formatting flexibility.
New icon sets: In Excel, we can access to more icon sets, including triangles, stars, and boxes. We can also mix and match icons from different sets and more easily hide icons.
For example, we might choose to display icons only for high profit values and remove them for middle and lower values.
More options for data bars: Excel 2010 comes with new formatting options for data bars. You can apply solid fills or borders to the data bar, or set the bar direction from right-to-left instead of left-to-right.
Not only that, data bars for negative values appear on the opposite side of an axis from positive values.
Trainer: Vinai teaches Advanced Excel Techniques, Dashboard Techniques using Excel, Data Interpretation and Analysis Training courses at Intellisoft. He has trained over 5000 students in over 18 countries, and regularly conducts Excel Workshops in Singapore, Malaysia, Indonesia, Australia, India, Dubai, Egypt, Zimbabwe, South Africa etc.