Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 30.067.003 Times

Excel 2011 : Perfectionnement - Tutorom 1.1

Company: Logivaro eLearning
Date Added: March 16, 2012  |  Visits: 152

Excel 2011 : Perfectionnement - Tutorom
Full screenshot

Report Broken Link
Printer Friendly Version

Product Homepage
Download (7 downloads)

FORMATION VIDEO sur Excel 2011 : Perfectionnement. Optimisez votre utilisation d'Excel 2011 pour MAC en suivant les conseils d'Alice Cherbonnel, formatrice depuis plus de 20 ans en bureautique. Vous etudierez bien sur les fonctions, les calculs avances, la gestion des feuilles de classeur et leur liaison, les bases de donnees, les graphiques, les tableaux croises dynamiques ainsi que les formats. Decouvrez aussi des astuces pour effectuer vos calculs plus facilement et les mettre en forme plus rapidement : vous serez ainsi plus ? laise dans la manipulation des feuilles de calcul et aurez la certitude que les resultats de vos formules soient corrects. Pour finir, vous recevrez les conseils necessaires pour realiser de bonnes impressions de vos documents.

Auteur : Alice Cherbonnel - Nombre de lecons : 73 - Duree : 5h36
Langue : Francais - Interface : Mac - Taille des videos : 1024x768

Sommaire du cours :

A propos d'Excel
- L'interet d'un tableur
- Les performances d'Excel

Gagner en aisance
- Verification des pre-requis
- Redecouvrir la poignee de recopie
- Mieux utiliser la somme automatique
- Astuces de saisie et raccourcis
- Copies speciales
- Masquer - Afficher
- Options avancees d'Excel
- Ruban et barre d'outils rapides

Calculs avances
- Calculer avec des dates
- Calculs avec des heures
- References absolues
- Nommer une cellule
- Utilisation avancee des noms

Gestion des feuilles du classeur
- Calculs impliquant plusieurs feuilles
- Feuille recapitulative
- Gestion des feuilles

Utilisation des graphiques
- Graphique - Pertinence
- Disposition du graphique
- Mettre en forme un graphique
- Manipulation des objets du graphique
- Integrer des objets externes : Image - Texte
- Creer un indicateur d'etat
- Diagramme de Gantt
- Creer un graphique Sparkline
- Utiliser les SmartArts
- Creer un histogramme

Formats personnalises et conditionnels
- Formats existants
- Formats personnalises
- Formater avec les styles
- Formats conditionnels
- Formats conditionnels avances

Fonctions et statistiques
- Les statistiques courantes
- Fonctions sur textes
- Fonctions sur dates
- Fonctions financieres
- Fonction recherche
- Les conditions simples
- Les conditions multiples
- Les conditions avec Si et Ou
- L'outil valeur cible
- Scenarios
- Outils d'analyse et d'audit
- Calculs matriciels

Extraction et ventilation des donnees
- Notions de base
- Trier des donnees
- Filtrer des donnees
- Donnees : Validation
- Donnees : Sous-totaux
- Tableau croise dynamique automatique
- Creer un tableau croise dynamique manuel
- Options des tableaux croises dynamiques
- Graphique de tableau croise dynamique
- Gestion des doublons et limites d'Excel
- Fonctions dans les bases de donnees

Les macro-commandes
- Qu'est ce qu'une macro-commande ?
- Creation d'une macro-commande
- Executer et retrouver une macro-commande
- Modifier et supprimer une macro-commande
- Creer un bouton de macro dans le menu
- Les erreurs dans les macro-commandes

Travailler en equipe
- Proteger un classeur
- Proteger des elements du classeur
- Dossier partage - Revisions
- Terminer le partage
- Travail collaboratif sur internet
- Partager Excel sur Google Doc

Imprimer avec precision
- Pourquoi ca ne marche pas toujours ?
- Une procedure d'impression sure

Excel et les autres logiciels
- Excel et Word
- Les formats d'enregistrements
- Importer des donnees ou tableaux
Requirements: iOS 5.0 or later. Compatible with iPad.

Requirements: No special requirements
Release Date: March 16, 2012
Platforms: iOS
Users rating: 0/10

License: Shareware Cost: $18.99 USD Size: 348 MB
Spreadsheets  -  Solver for Excel 1.0
Frontline Systems developed the original Solver for Excel on both Macintosh and Windows. For many years, we've offered Solver upgrades for Windows users, that have gotten more and more powerful over time -- but we haven't been active on the Mac....
Accounting Tools  -  Invoice Template for Excel 3.0
The invoice template for Excel is a simple to use and complete customer invoicing and inventory management system. The Excel invoice template stores invoices, products and customers and performs advanced invoice sales reporting and inventory...
199 KB  
Project Management  -  Project Planning and Management 3.0
The Excel Project Planning and Management template is designed as a generic and affordable Excel based solution to plan and manage any project. The ability to build the project's budget as tasks are identified facilitates the processes of business...
184 KB  
Spreadsheets  -  Portfolio Optimization 5.0
The Portfolio Optimization template identifies the optimal capital weightings for a portfolio of financial investments that gives the desired risk and return profile based on the correlation between individual investments. The design of the...
544 KB  
Spreadsheets  -  Investment and Business Valuation 3.0
The Excel Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business plan scenarios. Business valuation is based on the traditional discounted cash flow method but also evaluates...
167 KB  
Spreadsheets  -  Regression Analysis and Forecasting 3.0
The Multiple Regression Analysis and Forecasting template enables the confident identification of value drivers and forecasting business plan or scientific data. The multiple regression process utilizes commonly employed statistical measures to...
167 KB  
Utilities  -  Microsoft Error Reporting 2.2.6
This update to Microsoft Error Reporting for Mac is part of Microsoft's continued effort to improve software reliability by collecting information when an application experiences a serious error. Applies to: Office 2011, Office 2011...
1.45 MB  
Accounting Tools  -  Real Options Valuation 3.0
The Real Option Valuation template combines a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Traditional discounted cash flow investment analysis will only accept an...
138 KB  
Database Tools  -  EMS Data Import 2011 for SQL Server
EMS Data Import 2011 for SQL Server is an useful application taht will help you import data to SQL Server tables from MS Excel 97-2007, MS Access, DBF, XML, RTF, TXT, CSV, MS Word 2007, ODF and HTML files. It provides adjustable import...
Password Recovery  -  Accent EXCEL Password Recovery 7.8
Lost a password to an MS Excel workbook? Lost passwords for modifying sheets in an MS Excel workbook? Accent EXCEL Password Recovery will break the passwords and allow you to access your documents again! Supports MS Excel...
7.32 MB  
Mobile Software  -  iRealty Property Ads Platform 7.5.0
Do you hold a real estate business? If so, then you are familiar with its difficulties, especially when it is time to demonstrate the house to the potential buyers. It takes so much time to organize open door events, talking to every single...
48.78 MB  
Mobile Software  -  Secure Hunter Anti theft 1.001
Secure Hunter Anti-Theft Very useful for app for everyone who are using Android smartphone that it will increase your device security using its features like to remove for charging, shake/move position of the device it'll ring and it'll not stop...
4 KB  
Mobile Software  -  APUS Launcher 1.9.11
APUS Launcher, a light-weight and intelligent Android Launcher, is the flagship product of the APUS User System. It will help users to make your Android phone easier, faster and more convenient to use. It can boost RAM and speed up phone,...
4.03 MB  
Mobile Software  -  iOS 9 Jailbreak 1.0.2
Download our iOS 9 Jailbreak freeware for your Windows computer to get complete Cydia installation process. This is simple downloader developed for all iOS users willing to jailbreak their devices. This tool will check your device status and also...
902.5 KB  
Mobile Software  -  Android EWCAD Component 3.0.0
Android EWCAD is a collection of 3D modeling , simulation and many other powerful features as one of 3D CAD components. It is convenient to apply to mobile phone or tablet can be used to CAD,CAM,CAE program development.Android EWCAD 3D control in...
17.55 MB  
Business  -  VeryPDF PDF Scanner SDK for iOS 2.0
Turn your smartphone into a fast multi-page document scanner with VeryPDF PDF Scanner SDK. PDF Scanner SDK for iOS automatically produces small, clear, and legible standard PDF documents from any photos at a very high speed. VeryPDF PDF...
1.57 MB  
Business  -  iLister Classified Platform 7.5.0
Have you ever heard about the legendary iLister classified advertising business scripts? If yes, you will be extremely happy to get a chance to obtain its free demo here. If not, then get ready to meet a bunch of surprises this free advertising...
48.78 MB  
Business  -  RadBuilder for Android 2.1
Create your own app without programming. You don't have to be a programmer. Create your own apps for your presentations, documents, product introduction, advertisements and database management with RadBuilder, a platform to develop, install and...
23 B  
Business  -  Webpage to PDF Converter 1.0
Webpage to PDF Converter is an easy-to-use app to easily convert webpage to PDF document on Android device. First, you input the URL of a webpage (for example: "", then tap the "Convert Now" button to send URL to cloud...
1.39 MB  
Business  -  Word to PDF Converter 1.0
Word to PDF Converter is an easy-to-use app to easily convert Word to PDF or convert PDF to Word on Android device. First, you choose a Word DOCX, DOC or RTF file on your Android phone, choose either Linux server or Windows server to convert...
1.39 MB