Excel Formulas

New icon sets First introduced in ExcelFormulas - Office Excel 2007, icon sets let you display icons for different categories of data, based on whatever threshold you determine. For example, you can use a green up arrow to represent higher values, a yellow sideways arrow to represent middle values, and a red down arrow to Excel Formulas represent lower values. In Excel Formulas 2010, you have access to more icon sets, including triangles, stars, and boxes. You can also mix and match icons from Excel Formulas different sets and more easily hide icons from view—for example, you might choose to show icons only for high profit values and omit them for middle and lower values.

Whether at work or home, you need to be able to manipulate and analyze your data in a way that gives you new insight or helps you make better Excel Formulas decisions—and the faster you can finish your task the better. Excel Formulas 2010 provides new and improved analysis tools that enable you to do just that.