Introduction
Microsoft a complètement restructuré the menu with the version Office 2007. Theintention of concepteurs to Office is of regroup the commands selon the étapes of conception to un document. Cela implique also the end of menu under shape of bars tools incluant the menu Fichier. The commands under this menu, by more of options of the application and a few other commands are maintenant under the Office button  that you retrouvez au coin supérieur left of the screen.
 |
You will find most of the commands that were under the File menu. You will also find the Options from the application under this menu and a few other surprises. |
New
You can create a new document by entrant your values and by utilisant the styles déjà available. Microsoft Office you offers also another option. You can go use of models available with Office 2007 or go by chercher to other to partir of Microsoft Office Online. C'est souvent one manière very useful have this that you want very quickly.
 Press the Office .
Select the option New .
You can choose a document vièrge and start to entrer the values to your model. You can also use the a of models offerts per Microsoft Office Online. Une multitude of models are available in many categories. Cela could be very avantageux to use a model instead of passer the time to create the your.
Note: You must be connecté to the Internet to pouvoir use cette option.
Select the a of models available the one of categories under Microsoft Office Online.
You can regarder among the categories the models that are available and télécharger ceux that répondent to your besoins.
Select the model of your choice.
Press the Télécharger.
Microsoft Office will you aviser that cette option is only available to ceux that have one copie légitime of logiciels. Une vérification of the licence will be accomplit avant the téléchargement the model that you will choisi.
Après a few instants to attentes, the model will be téléchargé in Excel 2007.
Open
You want continuer your travail for a folder or continuer of work for the folder to un collègue? It faut first the open.
Press the Office .
If you avez ouvert the document écemment, you will of bonne chances from the find in the section Documents récents to the droite of the window.
Otherwise, select the option Open.
Select the lecteur and the dossier in lequel se retrouve your document.
Select your document and press the button Open.
Open and repair
À of rares occasions, il is possible that your document soit corrompu. It can be a cause to un problem technique or you avez déconnecteur the lecteur USB avant the end of the enregistrement, éteint the ordinateur sans close the applications or per one panne of courrant. Microsoft offers depuis a few time the option Open and repair.
Au moment to open the document, cliquez for the button with one arrow to the droite the button Open.
Select the option Open and repair.
Text to Columns
It s'agit in this cas of convertir of folders from versions précédentes to Microsoft Excel 2007 in the new format.
When you open a workbook in Excel 2007 that was create with a previous version of Excel, the software automatically converts to "compatibility mode". It means that you can work on the workbook and it will be saved in the older format. The option Text to Columns enregistre the folder by format Excel 2007 and offers all the possibilities of this format of fichier.
Press the Office button.
Select the option Text to Columns  .
The application you inform qu'il is prêt to convertir the folder by format Excel 2007.
Press the OK to start the conversion.
The conversion takes generally just a few moments. You must close and reopen the workbook to be able to use it with all the options of Excel 2010.
Save
You must save your documents on a hard disk, a flash drive at the end. If this is not the first time that you work on this workbook, you can use the  button on the quick access toolbar.
Save as
Excel allows you to save a workbook under many file formats.
Press the Office .
Select the option Save as.
 |
Micrsoft Excel offers many formats of fichiers to save the folder.
Excel workbook: The document will be saved in a file format that Excel will be able to reuse.
Excel macro-enabled workbook:An Excel workbook can contain macros. It's a chain of commands that is always executed in the same order. It can be very useful when you must continually execute repetitive tasks.
Unfortunately, some "hackers" have found a way to create dansgerous virus with these strings of commands. That is why that there are now security levels in integrated into every Office applications. Microsoft Excel will first you ask if you want open a workbook that contains macros. It's up to you to decide if you want the open or not that file.
|
Save as :
Excel 97-2003 workbook... : These last versions of Excel all used the same file format. You should still consider this format if you work with another person that uses one of these older versions of Excel.
Microsoft offers a file converter for Office 97-2003 to convert and read to more recent file formats. But, you can save your documents in the older version if you wish.
Adobe PDF: Theordinateur that j'uses to rédiger this text contains also Adobe Acrobat to convertir of documents by format PDF very populaire for Internet. Ce n'est pas one option standard to Excel 2007.
|
 |
Chercher of compléments to other formats of fichiers:
If you trouvez pas the format of your choice, il is always possible to add a convertisseur and the initégrer to Office 2007. Theaide to office explique comment add of convertisseurs to the format PDF and the format XPS with of liens to suivre to go chercher the content.
Other formats:To terminer, voici the list of formats déjà available to partir to Excel 2007.
|
Print
You go always need to print your documents to the remettre. However, you must always make a aperçu avant impression to s'assurer that the result is this that you escomptez. Otherwise, you can always change the mise by page by utilisant the options under the tab Page Setup.
Print
Press the Office .
Select the options Print and Print.
OR
Press on the keys Ctrl and P.
Impression rapide
This command sends immediately to the imprimante the worksheet for laquelle se trouve the cursor sans ask aucune autre option.
Aperçu avant impression
Tel that mentionné précédemment, il is nettement préférable to use the option Aperçu avant impression avant of commentre your travail for papier. Cela will you éviter one perte of time and of papier s'There are one erreur that doit be corrigé tel qu'un mauvais format of papier or a insert a saut of page au bon location.
Press the Office .
Select the option Print.
Select the option Aperçu avant impression.
The options under the tab Aperçu avant impression allows you to viewvotre folder comme s'il serait for papier. There is l,option to the zoom for one partie of your document and also to go directement aux options of the Page Setup to change one option if required.
Prepare
Microsoft Office you offers the possibilité of "prepair" your document avant from the remettre to your supérieur or to a client. You can add one description that rendra the document more facile to find, to vérifier if the folder is compatible with the versions précédentes to Excel, add a mot of passe, one signature électronique or confirm qu'il s'agit of the version finale the document.
Properties
There is also of properties avancés that donne the oportunité to the usager to entrer more to informations concernant the folder. It suffit of click for chacun of tabs to view the options available.
Inspecter the document
An inspection of the document is required before sending it to a client or to a superior. The inspection could find items that they may not appreciate.
Excel will first you ask to save the document if you avez apporté of modifications.
 |
Excel will vérifier some elements dont the comments, the informations personnelles and other elements listés for the picture to the left.
Press the Inspecter to start the processus. |
 |
Theinspection prends that a few instants avant of générer a rapport. You can ensuite determine s'il a element of the list doit rester with the folder.
Une fois terminé, press the button Fermer. |
Chiffrer the document
Certains documents doivent rester confidentiels. You can add a mot of passe to you assurer qu'aucune autre personne can easily access au content.
Assurez-vous of bien you souvenir the mot of passe. Otherwise, you ne will more open the document. Excel fait one distinction between of caractères by majuscules and ceux by minuscules. Donc, the mots of passe "SesameOuvreToi" and "sesameouvretoi" ne are pas pareil to Excel.
Bien that Microsoft essai of protéger your documents, il existe of "cracks" to determine the mots of passe and open of documents. Soyez certain to use these "tools" only if you avez the autorisation the créateur the document.
Add one signature numérique
To some documents, such as of bons of commands or of factures, il should be requis have one signature "électronique" that confirme the authenticité the document and of son approbation. Microsoft Office 2007 n'offers pas a service of signature électronique. However, you can intégrer the a of services shown for the site Web to Office 2007.
To viewthe list of fournisseurs of service of signature électronique, press the button Services of signature to Office Marketplace.
Une page Web will apparaître with one description of compagnies that offers the service of signature électronique. You can click for the liens by dessous of the description of the compagnie to go chercher more to informations. Ces services ne are pas free. You must you attendre to payer of frais to the usage of signatures électroniques.
Marquer comme final
Depuis a few versions of Microsoft Office, il is possible of "partager" a document to that many personnes travaillent for a same document and y apporte of modifications. You can have more to informations for cette option under the tab Review. The "gestionnaire" of modifications doit regroup all the elements of versions and create a document final. This étape consists to determine qu'il s'agit of the version finale the document and of conserver only the parties requises to create the document final. Assurez-vous that all the personnes that avaient quelque chose a apporter to this document the have fait avant of you rendre to cette étape.
Press the Office .
Select the options Prepare and Marquer comme final.
Une window will you informer that the processus will start.
Press the OK button.
This last window confirme that all the marques of modifications have été retirés.
To close cette window, press the OK button
Activate the vérificateur of compatibilité
The format of fichier the folder Excel 2007 is very différent of versions précédentes (97 to 2003). There is more to options arrangées of manière différente. It is encore possible to save a folder in the anciennes versions. Maisl il is préférable of vérifier the compapatibilité before.
Press the Office .
Select the options Prepare and Activate the vérificateur of compatibilité.
The vérificateur will you aviser s'There are one possibilité of perte of data and of quel type. You will ensuite decide if you want always save in a format of fichier précédent Excel 2007.
Press the Continuer.
Envoyer
You can envoyer your folder per courrier électronique or per télécopie directement to partir of your ordinateur. It faut cependant that celui-ci soit correctement configuré or qu'il ait accès to a service of télécopie per Internet pwith.
Courrier électronique
Press the Office .
Select the options Envoyer and Courrier électronique.
Télécopie Internet
Press the Office .
Select the options Envoyer and Télécopie Internet.
Microsoft Office 2007 you informe that you must you inscrire to a service of télécopie per Internet avant of pouvoir use cette option.
Press the OK button.
You will be taken to a screen listing a few compagnies that offers fax service through the Internet. There is a link at the bottom of the screen to view the other compagnies and other services available. You can click for the a of liens suivant the description of the compagnie to go chercher more to informations and you inscrire to these services. There is probablement of frais reliés to the usage or of mensualités to payer.
Publish
You can place your documents to a location où to other personnes can the use. It can be a serveur of the entreprise or a autre service.
Serveur of gestion of documents
Créer a space of travail of document
Gestionnaire of contacts professionnels
This option is available if you with the version of Microsoft Office 2007 Professionnel or supérieure.
Fermer
This option consists to close the document.
Press the Office .
Select the option Fermer.
OR
Press on the keys Ctrl and W.
Options Excel
Comme all the applications of Microsoft Office 2007, There are many options that the utilisateur peut change to répondre to ses besoins.
Standard
Press the Office .
Press the Options .
From the list of categories to options, select Standard.
Mini-bar of selection: It s'agit to une petite bar tools that offers the commands the more souvent used in the context that the utilisateur se retrouve to this moment (work for the text, of pictures, of charts or other objects). Cela is beaucoup more useful that have to retourner au ribbon to apply one command.
Aperçu instantané: C'est probablement the nouvelle option the more useful to Office 2007. Elle allows you to have one aperçu the result to une option avant same of the have choisi ! Essayez-le by selectionnant the text and by changing the font size. You voyez the result possible by déroulant the list of size. This option s'applique to presque all the commands to Office 2007. 
Onglet Développeur: Très peu to usagers have accumulés assez to expérience to create of macrocommands or programmer by Visual Basic to Application (VBA). It's for that reason that the développeurs to Office have décidé of masquer these options. You can the activer by cochant the box Unhide the tab développeur in the ribbon.
ClearType: This option rends the caractère to the screen more lisible to the usager.
Info-bulle: This option allows you to have one courte description of the command for lequelle se retrouve the cursor to this moment.
List personalisée:To accélérer the entré of data, Excel offers of lists prédéterminées. You can add your own list to partir of your informations. Cela you facilitera the entré of data that reviennent fréquemments.
Formulas
Press the Office .
Press the Options .
From the list of categories to options, select Formulas.
This section allows you to adjust comment the formulas and the vérificateur of erreurs réagissent in Excel 2007.
Proofing
Press the Office .
Press the Options .
From the list of categories to options, select Proofing.
Enregistrement
Press the Office .
Press the Options .
From the list of categories to options, select Enregistrement.
Options avancées
Press the Office .
Press the Options .
From the list of categories to options, select Advancedes.
Personnaliser
It s'agit of commands that you can add to the la quick access toolbar. You can also détermer the order of commands for the bar.
Press the Office .
Press the Options .
From the list of categories to options, select Personnaliser.
Compléments
Certaines personnes and entreprises have create of "compléments" to Excel to the rendre encore more useful. You can manage these "mini-applications" to partir of cette window.
Press the Office .
Press the Options .
From the list of categories to options, select Compléments.
Centre of gestion of the confidentialité
Press the Office .
Press the Options .
From the list of categories to options, select Centre of gestion of the confidentialité.
Ressources
Press the Office .
Press the Options .
From the list of categories to options, select Resosurces.
Quitter Excel
Comme all the applications Office, There areplusieurs façons of quitter and close the application.
Du Office button, select the option Quitter.
OR
Faites a double-clic for the Office button.
OR
Press the  or selon your version of Windows.
OR
Press on the keys Alt and F4. |
