Learn about Excel 2007



Excel cell styles:

This video shows the possibility in Excel 2007 to assign optical styles to single or groups of cells. Various presets are given but it is also possible to design them by your own.
Click here to watch video

Excel charting:

The new charting tool in Excel 2007 allows a lot of visualizations of your data by just some clicks. The presets of styles are available in 2D- or 3D-designs. The comfortable preview-function makes it very easy to experiment or play around with the many options for the user in this new tool of Excel 2007.
Click here to watch video

Excel conditional formatting:

The conditional formatting feature in Excel 2007 allows the user to highlight or mark cells depending on their value. It is possible to work with colors, symbols or even with bars showing the value as a kind of peak. The user simply has to define a rule for the marked cells and choose a predefined style out of a menu and the rest will be done by Excel 2007.
Click here to watch video

Excel headers footers:

This video shortly shows the new designed user interface to work with headers and footers in Excel 2007.
Click here to watch video
 

Excel new file format:

The new file format of Office 2007 increases file security and decreases filesize up to 50%. The data files are not longer binaries but archives containing mostly xml-data. So it is much easier for developers to work with data contained in this new file-type called “xmlx”.
Click here to watch video

Excel new interface:

Take a look at the new Excel 2007 User Interface. This includes the Quick Access Toolbar which is completely customizable. The new Ribbon is shown which contains different tabs like “Home”, “Insert”, “Page Layout” and so on. These tabs contain the groups of commands which are available by a mouse click.
Click here to watch video

Excel pivot tables:

In this video the new user interface to work with pivot tables is shown. See how to work with fields or how the Pivot Chart Tools are used. The drag and drop feature is shown as well as the contextual user interface placed in the Ribbon.
Click here to watch video

Excel shapes wordart:

In Excel 2007 shapes can be inserted in a very simple way. You can choose shapes by just one click on the command “Shapes” after selecting the Ribbon´s tab “Insert”. If you click on the command “Wordart” you can choose for example 3-dimensional pre-designed fonts and customize them by your needs. Real time previews function for all these features is provided as well.
Click here to watch video

Excel templates:

This video shows the template functions of Excel 2007 such as the possibilities for the user to design his own template documents. Further there are different “ready to use” templates from Microsoft which are installed with the application and the option to access the online archive of Microsoft Office.
Click here to watch video

Excel themes:

Microsoft Excel 2007 delivers predefined themes for the user to use in his own documents. These themes contain colors fonts and effects. There is also the possibility for the user to design own themes and save them to the computer and use them for later documents.
Click here to watch video