Entering text, values and formulas into cells is only part of creating a working model. The Insert tab allows you to add other elements such as charts, cliparts and images, among others, to your workbook. Some of these items will be explained in detail on other web pages.

Excel 2007 :Insertion-intro

Tables

PivotTable

A pivot table allows you to quickly create a summary table from a mass of data. You can find all the totals, the number and other mathematical operations on these data. In addition, the dynamic aspect of the PivotTable lets you change its look and see the result immediately. An exercise is available to experiment with. This option isn't used often enough.

Follow this link to view the exercise for this command

Table

A table is what was previously known as a data list. It's a way to create a simple database in Excel. The first line contains field names. The following lines contain the data you want to save and analyze later. You determine its size, the name of each field.

Illustrations

In addition to tables described above, Excel 2010 lets you insert graphic elements such as images, forms, charts and graphs. The next section will demonstrate comment to insert these elements into your documents.

Picture

You can insert your own pictures or photos in a document. There is also an additional tab which offers a multitude of possibilities for presentation.

Clipart

Microsoft Office offers a good library of images you can search. In addition, you can download "art" from the Microsoft Office Online site Office Online .

Shapes

You can create your own image, logo or design by combining simple shapes into something more elaborate.

SmartArt

Microsoft Office also offers several types of diagrams to suit your needs. This is one other element that has been greatly improved over previous versions. There are more diagrams which offers more options with a much improved presentation.

Charts

Another element that has been completely redesigned is charting. All Office 2010 applications are now using the graphics module of Excel. Ce module offre tellement to options qu'elles sont regroupé sous three tabs complémentaires : This module offers so many options that are grouped under three tabs complementary