0

Microsoft Office Excel 2007 12

Excel enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. Support up to 1,048,576 rows and 16,384 columns (XFD) in a single worksheet, with 32,767 characters in a single cell (17,179,869,184 cells in a worksheet, 562,932,773,552,128 characters in a worksheet) Conditional Formatting introduces support for three new features — Color Scales, Icon Sets and Data Bars Color Scales, which automatically color the background of a group of cells with different colors according to the values. Icon sets, which precede the text in a cell with an icon that represent some aspect of the value of the cell with respect to other values in a group of cells, can also be applied. Icons can be conditionally applied to show up only when certain criteria are met, such as a cross showing up on an invalid value, where the condition for invalidity can be specified by the user. Data Bars show as a gradient bar in the background of a cell the contribution of the cell value in the group. Column titles can optionally show options to control the layout of the column. Multithreaded calculation of formulae, to speed up large calculations, especially on multi-core/multi-processor systems. User Defined Functions (UDF), which are custom functions written to supplement Excel’s set of built-in functions, supports the increased number of cells and columns. UDFs now can also be multithreaded. Server side UDFs are based on the .NET Managed code. Importing data from external sources, such as a database, has been upgraded. Data can also be imported from formatted tables and reports, which do not have a regular grid structure. Formula Autocomplete, automatically suggests function names, arguments and named ranges, and automatically completing them if desired, based on the characters entered. Formulae can refer to a table as well. CUBE functions which allow importing data, including set aggregated data, from data analysis services, such as SQL Server Analysis Services. 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, now includes a Quick filter option allowing the selection of multiple items from a drop down list of items in the column. 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.

Leave a Reply