A pivot table allows you to quickly
create a summary table from a mass of data. You can find all the totals, the
number, mean and other mathematical operations on these data. In addition, the dynamic aspect of the
table lets you change its look and see the result immediately. An exercise is available to experiment with this
option is not used often enough.
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 how
to insert these elements into your documents.
Picture
You can insert
your own pictures or photos in your documents. 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 where 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 of the other elements 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 charting. All Office 2010 applications are now using the graphics module
of Excel. Ce module offre
tellement d'options qu'elles sont regroupé sous trois onglets complémentaires
: This module offers so many options that are grouped under three tabs
complementary
Column
Line
Pie
Bar
Area
Scatter
Other charts
Options for charts
Links
Since Office 95, all
subsequent versions offer the ability to create hyperlinks to web pages, email
addresses or other Internet services or links to, within documents.
Hyperlink
Text
Text Box
Header & Footer
An Excel document allows you to
add information in an area reserved for the header and footer when
printing.
WordArt
You can give a title or text
a style from the WordArt gallery.
Signature Line
This option
adds a digital signature to your document. This is important
for official documents such as purchase orders, contracts or invoices.
Object
Allows you to insert
objects from other applications.
Symbol
You like what you read?
Share it with your friends.
This option
adds a digital signature to your document. This is important
for official documents such as purchase orders, contracts or invoices.
Allows you to insert
objects from other applications. 
