{"id":10586,"date":"2022-11-26T22:52:45","date_gmt":"2022-11-26T21:52:45","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10586"},"modified":"2022-11-26T22:57:35","modified_gmt":"2022-11-26T21:57:35","slug":"le-mode-tableau-dexcel","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10586","title":{"rendered":"Le mode tableau d&#8217;Excel"},"content":{"rendered":"<p style=\"text-align: justify;\">Le mode tableau est une version plus moderne des <a href=\"https:\/\/www.auditsi.eu\/?p=10478\">filtres<\/a>. Il permet tout \u00e0 la fois d&#8217;obtenir des <strong>filtres de donn\u00e9es<\/strong> et de <strong>s\u00e9curiser les formules de calcul<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10588\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Presentations-disponibles.png\" alt=\"Mode tableau - Pr\u00e9sentations disponibles\" width=\"523\" height=\"770\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Presentations-disponibles.png 523w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Presentations-disponibles-204x300.png 204w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/p>\n<p style=\"text-align: justify;\">Pour transformer des donn\u00e9es en un tableau :<\/p>\n<ul>\n<li style=\"text-align: justify;\">S\u00e9lectionner la plage de cellules. Toutes les colonnes de la plage doivent <strong>comporter des ent\u00eates<\/strong>, sinon Excel cr\u00e9e une ligne d\u2019ent\u00eates (Colonne1, Colonne2\u2026).<\/li>\n<li style=\"text-align: justify;\">Dans le menu Accueil, cliquer sur le <strong>bouton Mettre sous forme de tableau<\/strong><\/li>\n<li style=\"text-align: justify;\">Cliquer sur la pr\u00e9sentation voulue. La pr\u00e9sentation s\u00e9lectionn\u00e9e est appliqu\u00e9e \u00e0 la plage de cellules et des filtres sont appliqu\u00e9s<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Un nouveau menu appara\u00eet : Cr\u00e9ation de tableau. Ce menu offre la possibilit\u00e9 de nommer le tableau, le redimensionner\u2026 et de personnaliser sa pr\u00e9sentation :<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10589\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Options-style.png\" alt=\"Mode tableau - Options style\" width=\"564\" height=\"162\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Options-style.png 564w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Options-style-300x86.png 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10590\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Nom-tableau.png\" alt=\"Mode tableau - Nom tableau\" width=\"291\" height=\"154\"><\/p>\n<p style=\"text-align: justify;\">Les filtres du mode tableau fonctionnent de la m\u00eame mani\u00e8re que les <a href=\"https:\/\/www.auditsi.eu\/?p=10478\">filtres classiques<\/a>.<\/p>\n<p style=\"text-align: justify;\">Pour cr\u00e9er un <strong>tableau crois\u00e9 dynamique<\/strong> (TCD), se rendre dans le menu Cr\u00e9er tableau puis cliquer sur Tableau crois\u00e9 dynamique :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10591\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Creer-TCD.png\" alt=\"Mode tableau - Cr\u00e9er TCD\" width=\"279\" height=\"42\">Le nom du tableau est reconnu automatiquement (en lieu et place de la plage de cellules) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10592\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Creer-TCD-a-partir-tableau.png\" alt=\"Mode tableau - Cr\u00e9er TCD \u00e0 partir tableau\" width=\"465\" height=\"273\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Creer-TCD-a-partir-tableau.png 465w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Creer-TCD-a-partir-tableau-300x176.png 300w\" sizes=\"auto, (max-width: 465px) 100vw, 465px\" \/><\/p>\n<p style=\"text-align: justify;\">Il est possible d&#8217;ajouter des <strong>sous-totaux<\/strong> (<a href=\"https:\/\/www.auditsi.eu\/?p=10478\">fonction SOUS.TOTAL<\/a>).<\/p>\n<p style=\"text-align: justify;\">Le mode tableau pr\u00e9sente quelques avantages par rapport aux <a href=\"https:\/\/www.auditsi.eu\/?p=10478\">filtres<\/a> plus classiques : <strong>formules de calcul plus lisibles<\/strong> (puisque compos\u00e9es du nom des ent\u00eates de colonnes et non pas du nom des cellules) et <strong>autor\u00e9pliqu\u00e9es dans toute la colonne<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Exemple : pour calculer le solde (=d\u00e9bit-cr\u00e9dit), au lieu de saisir =L5-M5, la formule est r\u00e9dig\u00e9e ainsi :<\/p>\n<p style=\"text-align: center;\">=[@D\u00e9bit]-[@Cr\u00e9dit]<\/p>\n<p style=\"text-align: justify;\">Soit @ suivi du nom de l&#8217;ent\u00eate de colonne.<\/p>\n<p style=\"text-align: justify;\">Lors de la validation de la formule, elle se duplique toute seule jusqu\u2019en bas du tableau. Ainsi, <strong>plus d\u2019oubli de duplication ou de formule diff\u00e9rente d\u2019une ligne \u00e0 l\u2019autre<\/strong>\u2026<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10593\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Formules.png\" alt=\"Mode tableau - Formules\" width=\"463\" height=\"128\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Formules.png 463w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Formules-300x83.png 300w\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" \/><br \/>\nOption int\u00e9ressante du mode tableau, le <strong>segment permet de filtrer les donn\u00e9es du tableau<\/strong>. Pour ajouter un segment, cliquer sur le bouton Ins\u00e9rer un segment :<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10594\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Inserer-segment.png\" alt=\"Mode tableau - Ins\u00e9rer segment\" width=\"106\" height=\"142\"><br \/>\nS\u00e9lectionner le ou les champs \u00e0 utiliser comme segment :<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10595\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Inserer-segment-Liste-champs.png\" alt=\"Mode tableau - Ins\u00e9rer segment Liste champs\" width=\"216\" height=\"405\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Inserer-segment-Liste-champs.png 216w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Inserer-segment-Liste-champs-160x300.png 160w\" sizes=\"auto, (max-width: 216px) 100vw, 216px\" \/><\/p>\n<p style=\"text-align: justify;\">Un segment se pr\u00e9sente ainsi :<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10596\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Segment.png\" alt=\"Mode tableau - Segment\" width=\"193\" height=\"283\"><\/p>\n<p style=\"text-align: justify;\">Disposer les segments dans la feuille de travail (glisser\/d\u00e9poser) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10597\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Tableau.png\" alt=\"Mode tableau - Tableau\" width=\"581\" height=\"444\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Tableau.png 581w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Tableau-300x229.png 300w\" sizes=\"auto, (max-width: 581px) 100vw, 581px\" \/><\/p>\n<p style=\"text-align: justify;\">Utilisation des segments pour filtrer les donn\u00e9es :<\/p>\n<p style=\"text-align: justify;\">Cliquer sur les donn\u00e9es \u00e0 filtrer\/d\u00e9filtrer\u2026 : les donn\u00e9es se mettent \u00e0 jour dans le tableau\u2026<\/p>\n<p style=\"text-align: justify;\">Par d\u00e9faut les segments ne permettent de s\u00e9lectionner qu\u2019un seul item. Pour s\u00e9lectionner plusieurs items, cliquer sur le bouton S\u00e9lection multiple (en jaune ci-dessous) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10600\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Segment-selection-multiple.png\" alt=\"Mode tableau - Segment selection multiple\" width=\"221\" height=\"333\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Segment-selection-multiple.png 221w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Segment-selection-multiple-199x300.png 199w\" sizes=\"auto, (max-width: 221px) 100vw, 221px\" \/><\/p>\n<p style=\"text-align: justify;\">Les donn\u00e9es se mettent \u00e0 jour au fur et \u00e0 mesure des s\u00e9lections :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10601\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Donnees-selectionnees-par-segment.png\" alt=\"Mode tableau - Donn\u00e9es s\u00e9lectionn\u00e9es par segment\" width=\"551\" height=\"221\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Donnees-selectionnees-par-segment.png 551w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Donnees-selectionnees-par-segment-300x120.png 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/p>\n<p style=\"text-align: justify;\">Les filtres en t\u00eate de colonnes sont utilisables simultan\u00e9ment aux segments.<\/p>\n<p style=\"text-align: justify;\">Pour effacer les filtres, cliquer sur la croix rouge du segment concern\u00e9 : <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10602\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/Mode-tableau-Effacer-segment.png\" alt=\"Mode tableau - Effacer segment\" width=\"27\" height=\"23\"><\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Formation Analyse de donn\u00e9es et automatisation avec Excel et Access<\/a>&nbsp;\/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Le%20mode%20tableau%20d%27Excel\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Le mode tableau est une version plus moderne des filtres. Il permet tout \u00e0 la fois d&#8217;obtenir des filtres de donn\u00e9es et de s\u00e9curiser les formules de calcul. Pour transformer des donn\u00e9es en un tableau : S\u00e9lectionner la plage de cellules. Toutes les colonnes de la plage doivent comporter des ent\u00eates, sinon Excel cr\u00e9e une &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10586\" class=\"more-link\">Continue reading &lsquo;Le mode tableau d&#8217;Excel&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Le%20mode%20tableau%20d%27Excel\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48],"tags":[294,2803,2274,291,182],"class_list":["post-10586","post","type-post","status-publish","format-standard","hentry","category-excel","tag-filtres","tag-mode-tableau","tag-segment","tag-sous-total","tag-tcd"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10586"}],"version-history":[{"count":8,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10586\/revisions"}],"predecessor-version":[{"id":10606,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10586\/revisions\/10606"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}