Although this was available in earlier versions, it was significantly upgraded with 2007. Spreadsheet Formatting Themes and Styles - These are pre-set schemes that encompass colours, fonts and special effects which can quickly be selected with a single click from a gallery to further enhance the visual appeal of your spreadsheet, and the objects you have inserted into it.Д¬onditional Formatting - This allows the user to specify a set of cells and then a set of rules which then formats the colours and appearance of cells depending on their value. Both of these developments provide a significant boost to speed of operation.Д¬olours - Excel 2007 now supports up to 16 million colours. Performance - Excel 2007 supports up to 2GB of memory (up from 1GB in 2003) and the application also supports multi-threaded processors. Rows and Columns - Excel 2007 supports up to 1 million rows and 16 thousand columns in each of its worksheets. Under the hood, the ability of Excel has been improved on in different areas. For example, If you were to select a Chart within your spreadsheet, an extra set of tabs appear called Chart Tools, each of which contain commands which allow further formatting of the selected Chart. By clicking on a tab, the commands in the Ribbon change in accordance to the tab you have selected.ДЇinally, as well as the above mentioned tabs, Contextual Tabs appear when a particular object is selected. It is broken up into category Tabs: Home, Insert, Page Layout, Formulas, Data, Review and View. The Ribbon is located at the top of the Excel Screen, and is designed to help you to quickly find commands.

Microsoft excel 2007 training