Vidéos - Calc
TDF LibreOffice Document Liberation Project Blogs communautaires Weblate Nextcloud Redmine Ask LibreOffice Donner
Vidéos d'aide pour l'utilisation de Calc
Général
Nouvelles fonctionnalités Calc 5.1
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Trucs & Astuces sur l'AutoSaisie
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Édition
Comment défiler au clavier ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment raccourcir les déplacements ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment gérer les sauts de page ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment rechercher dans les bonnes feuilles ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment ajouter des lignes de façon express ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment déplacer une colonne (ligne) entre deux autres en une seule étape ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment supprimer des lignes vides dans une plage ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment supprimer rapidement tous les commentaires ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment récupérer le nom de feuille dans une cellule ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment garder visibles des totaux de colonne ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment convertir vos valeurs ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Nouvel emplacement du menu : ▸ ▸
Comment paramétrer l'interprétation du texte dans les calculs ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Ordre de priorité des calculs
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment protéger les formules ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Format
Comment saisir des fractions ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment convertir en numérique des nombres considérés comme des textes ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment alterner la couleur des lignes d'une plage ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Bordures
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment bien utiliser le dialogue Bordures ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment créer/modifier les styles par défaut hors modèle ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Formatage conditionnel Barre de Données
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Formatage Conditionnel pour les Dates
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Formatage Conditionnel Jeu d'icônes
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Fonctions
Comment rechercher une valeur en fonction d'une autre ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment récupérer des informations sur le web ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment concaténer une plage de cellules ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment vérifier les formules (Audit) ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment vérifier les formules (Calculs intermédiaires) ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Références
Références relatives/absolues
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Références absolues via un nom utilisateur
{{Youtube|id=wMVdi52f6no}
Comment préserver les références relatives lors de la copie ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Les Références 3D
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Temps
Comment gérer les heures ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment réaliser un horodatage ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment gérer les jours ouvrés ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Données
Comment sélectionner les données affichées ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment calculer la fréquence d'apparition de valeurs ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment gérer les doublons ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment trouver les valeurs les plus élevées ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment supprimer les valeurs supérieures à un seuil ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
La recherche multi-critères par un filtre spécial
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment faciliter la saisie par une liste déroulante (Validité) ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Liste de Validité, réponses à des questions courantes
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Spécificités des Plages de bases de Données
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment regrouper les entrées d'une table de pilote ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Les Opérations Multiples
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Les Scénarios
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment remplir les cellules vides par les catégories ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Format
Comment réaliser un chevalet lisible des deux côtés ?
ou comment retourner un texte :
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Chart (diagramme)
Comment ajouter des données à un graphique ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment afficher le total des colonnes dans un graphique empilé ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Création de diagrammes Pivots
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Autres
Comment limiter l'impression à une page en largeur sans limite en hauteur ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Comment copier des contrôles en rompant la liaison avec la feuille d'origine ?
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.