Improved conditional formatting in Excel For Better Data Visualization
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. In each newer version of Excel, it 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 now 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.
If you would like to learn more about these new features of Microsoft Excel for data analysis and data visualization or would like to attend the Microsoft Excel Training, do contact us at Intellisoft Systems.
The Best Trainer for Advanced Data Analytics With Excel in Singapore
He has trained over 15,000 students in over 18 countries, and regularly conducts Excel Workshops in Singapore, Malaysia, Indonesia, Australia, India, Dubai, Egypt, Zimbabwe, South Africa etc.