Content deleted Content added
No edit summary |
|||
Line 247:
*''Page Layout'' view, to author spreadsheets in a way that mirrors the formatting that will be applied when printed.
*''PivotTables'', which are used to create analysis reports out of sets of data, can now support hierarchical data by displaying a row in the table with a "+" icon, which, when clicked, shows more rows regarding it, which can also be hierarchical. PivotTables can also be sorted and filtered independently, and conditional formatting used to highlight trends in the data.
*''Filters'', Quick filter option allows selecting multiple items in a drop down to filter on. The option to filter based on color has been added to the choices available.
*Excel features a new charting engine, which supports advanced formatting, including 3D rendering, transparencies and shadows. Chart layouts can also be customized to highlight various trends in the data.
| |||