{"id":143,"date":"2026-06-27T17:11:19","date_gmt":"2026-06-27T17:11:19","guid":{"rendered":"https:\/\/boussoleinfo.fr\/?page_id=143"},"modified":"2026-06-28T12:18:14","modified_gmt":"2026-06-28T12:18:14","slug":"le-guide-des-50-fonctions-essentielles-de-libreoffice-calc","status":"publish","type":"page","link":"https:\/\/boussoleinfo.fr\/index.php\/le-guide-des-50-fonctions-essentielles-de-libreoffice-calc\/","title":{"rendered":"Le guide des 50 fonctions essentielles de LibreOffice Calc"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-7387b849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-text-color has-link-color has-medium-font-size wp-elements-6ad69fb4b7bcbc752e9434c49fadaa00 wp-block-paragraph\" style=\"color:#003e7c\"><strong>D\u00e9couvrez un guide pas \u00e0 pas con\u00e7u pour les d\u00e9butants<\/strong> qui veulent une alternative \u00e0 Microsoft Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aujourd&rsquo;hui, un abonnement \u00e0 Microsoft Office c&rsquo;est : <strong>99 \u20ac \/ An<\/strong>. Un sacr\u00e9 budget !<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pourtant, la plupart des gens n&rsquo;ont pas besoin de toutes les fonctionnalit\u00e9s. Il existe aujourd&rsquo;hui de nombreuses alternatives. Toutes ne se valent pas, mais il est possible d&rsquo;avoir une suite bureautique <strong>compl\u00e8te <\/strong>\u00e0 disposition et <strong>gratuitement<\/strong>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">LibreOffice fait partie de ces alternatives aujourd&rsquo;hui !<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"1024\" src=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/Couverture_guide_libreoffice-calc-723x1024.png\" alt=\"\" class=\"wp-image-145\" style=\"aspect-ratio:0.7064363981593638;width:264px;height:auto\" srcset=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/Couverture_guide_libreoffice-calc-723x1024.png 723w, https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/Couverture_guide_libreoffice-calc-212x300.png 212w, https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/Couverture_guide_libreoffice-calc-768x1087.png 768w, https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/Couverture_guide_libreoffice-calc.png 1054w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-3e41869c wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-luminous-vivid-orange-background-color has-background has-text-align-center wp-element-button\" href=\"https:\/\/payhip.com\/b\/81qcN\" target=\"_blank\" rel=\"noreferrer noopener\">\ud83d\udcd8 <strong>Acheter le guide<\/strong><\/a><\/div>\n<\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>\u00c9conomisez en choisissant une alternative gratuite qui couvrira largement vos besoins du quotidien<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La suite <strong>Microsoft Office<\/strong> contient un grand nombre de logiciels populaires : <strong>Word<\/strong>, <strong>Excel<\/strong>, <strong>PowerPoint<\/strong>, etc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ces outils sont excellents, on ne va pas se mentir. Mais malheureusement, j&rsquo;ai connu une \u00e9poque o\u00f9 l&rsquo;on pouvait encore acheter le pack Office complet \u00e0 moindre co\u00fbt. Depuis, la politique a chang\u00e9. Microsoft vous pousse \u00e0 prendre un abonnement, et le prix de celui-ci, qui repr\u00e9sente un sacr\u00e9 budget, est \u00e0 renouveler chaque ann\u00e9e. Pour un utilisateur lambda qui a des besoins classiques, ou encore un \u00e9tudiant, ce n&rsquo;est plus une solution adapt\u00e9e.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Les alternatives<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Je travaille dans l&rsquo;informatique depuis des ann\u00e9es. Les suites bureautiques, je les connais sur le bout des doigts. Je connais les besoins personnels et aussi professionnels de beaucoup d&rsquo;utilisateurs, parce que ceux sont aussi mes propres besoins. J&rsquo;ai eu l&rsquo;occasion de tester des alternatives gratuites, et le r\u00e9sultat m&rsquo;a bluff\u00e9.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Voici les alternatives que je recommande aujourd&rsquo;hui pour remplacer <strong>gratuitement <\/strong> la suite de Microsoft :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>LibreOffice<\/strong> : cette suite bureautique offre tous les outils dont un utilisateur peut avoir besoin (traitement de texte, tableur, outil de pr\u00e9sentation, etc.) ;<\/li>\n\n\n\n<li><strong>OnlyOffice<\/strong> : l&rsquo;une de mes pr\u00e9f\u00e9r\u00e9es car, son interface est tr\u00e8s proche de Microsoft Office ;<\/li>\n\n\n\n<li><strong>Collabora<\/strong> : Moins connue mais tout aussi efficace.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>La bonne nouvelle : tout ce que vous allez apprendre dans ce guide peut \u00eatre appliqu\u00e9 \u00e0 presque tous les logiciels de type tableur et pas seulement \u00e0 LibreOffice.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Les fonctions dans Excel, LibreOffice, OnlyOffice et Collabora sont pratiquement les m\u00eames.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour effectuer la transition sans douleur, il faut prendre le temps d&rsquo;apprivoiser un nouvel outil. Depuis quelques ann\u00e9es, je contribue \u00e0 d\u00e9mocratiser ces alternatives en alimentant ma cha\u00eene YouTube : <strong> <a href=\"https:\/\/www.youtube.com\/@laboussoleinfo\" target=\"_blank\" rel=\"noreferrer noopener\">Boussole Informatique<\/a><\/strong>, et en r\u00e9digeant des guides comme celui-ci.<\/p>\n\n\n\n<div class=\"wp-block-group has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#bae5ffd4\">\n<h2 class=\"wp-block-heading has-ast-global-color-3-color has-text-color has-link-color wp-elements-62cab5a2bfd5e9b923d4845ba3126ec4\">Dans ce guide, j&rsquo;ai regroup\u00e9 et d\u00e9taill\u00e9 les 50 fonctions essentielles de LibreOffice Calc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Vous y d\u00e9couvrirez :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2713 La syntaxe claire et d\u00e9taill\u00e9e de chaque fonction ;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2713 \u00c0 quoi chacune va vous servir ;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2713 Des exemples concrets d&rsquo;utilisation.<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">D\u00e9couvrez quelques extraits du guide<\/h2>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"636\" height=\"875\" data-id=\"146\" src=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/01_calc.png\" alt=\"\" class=\"wp-image-146\" srcset=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/01_calc.png 636w, https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/01_calc-218x300.png 218w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"641\" height=\"806\" data-id=\"147\" src=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/02_calc.png\" alt=\"\" class=\"wp-image-147\" srcset=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/02_calc.png 641w, https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/02_calc-239x300.png 239w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"638\" height=\"895\" data-id=\"148\" src=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/03_calc.png\" alt=\"\" class=\"wp-image-148\" srcset=\"https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/03_calc.png 638w, https:\/\/boussoleinfo.fr\/wp-content\/uploads\/2026\/06\/03_calc-214x300.png 214w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Au sommaire du guide<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"border-bottom-color:var(--wp--preset--color--vivid-green-cyan);border-bottom-width:2px\"><strong>MODULE 1 :<\/strong> Calculs de base<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"border-bottom-color:var(--wp--preset--color--vivid-green-cyan);border-bottom-width:2px\"><strong>MODULE 2 :<\/strong> Conditions et logiques<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"border-bottom-color:var(--wp--preset--color--vivid-green-cyan);border-bottom-width:2px\"><strong>MODULE 3 :<\/strong> Fonctions de recherche d&rsquo;informations<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"border-bottom-color:var(--wp--preset--color--vivid-green-cyan);border-bottom-width:2px\"><strong>MODULE 4 :<\/strong> Fonctions de texte<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"border-bottom-color:var(--wp--preset--color--vivid-green-cyan);border-bottom-width:2px\"><strong>MODULE 5 :<\/strong> Dates et heures<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"border-bottom-color:var(--wp--preset--color--vivid-green-cyan);border-bottom-width:2px\"><strong>MODULE 5 :<\/strong> Autres fonctions utiles pour vos projets<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\ud83e\udded A qui s&rsquo;adresse ce guide ?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ce guide a \u00e9t\u00e9 con\u00e7u pour les personnes qui veulent comprendre le fonctionnement des <strong>fonctions <\/strong>sur LibreOffice Calc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Il est fait pour vous si :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 Vous connaissez un peu les bases d&rsquo;un tableur ;<\/li>\n\n\n\n<li>\u2705 Vous voulez un guide \u00e0 garder sous la main lors de la cr\u00e9ation de vos classeur Calc ;<\/li>\n\n\n\n<li>\u2705 Vous d\u00e9butez sur les fonctions et vous voulez des explications claires et accessibles ;<\/li>\n\n\n\n<li>\u2705 Vous voulez vous tourner vers une alternative gratuite \u00e0 Microsoft Office ;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Et enfin : <strong>aucune connaissance <\/strong>sur les fonctions n&rsquo;est requise, juste avoir les bases d&rsquo;un tableur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">J&rsquo;ai vraiment pens\u00e9 ce guide pour que ce soit clair et accessible pour les <strong>d\u00e9butants<\/strong>. J&rsquo;ai con\u00e7u ce guide comme celui que j&rsquo;aurais aim\u00e9 avoir lorsque j&rsquo;ai commenc\u00e9.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pr\u00eat \u00e0 prendre le large ?<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-3e41869c wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-luminous-vivid-orange-background-color has-background has-medium-font-size has-custom-font-size wp-element-button\" href=\"https:\/\/payhip.com\/b\/81qcN\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Pour vous procurer le guide des 50 fonctions essentielles de Calc, c&rsquo;est par ici !<\/strong><\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Je vous recommande \u00e9galement de visionner ma formation d&rsquo;une heure et gratuite sur la cha\u00eene Boussole Informatique. La vid\u00e9o et le guide se compl\u00e8tent :<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Remplacez Excel gratuitement : apprenez LibreOffice Calc en 1 heure\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/rc5Ti52kxX4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>D\u00e9couvrez un guide pas \u00e0 pas con\u00e7u pour les d\u00e9butants qui veulent une alternative \u00e0 Microsoft Excel. Aujourd&rsquo;hui, un abonnement [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-143","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/pages\/143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/comments?post=143"}],"version-history":[{"count":6,"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/pages\/143\/revisions"}],"predecessor-version":[{"id":157,"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/pages\/143\/revisions\/157"}],"wp:attachment":[{"href":"https:\/\/boussoleinfo.fr\/index.php\/wp-json\/wp\/v2\/media?parent=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}