{"id":1045,"date":"2022-02-15T06:25:00","date_gmt":"2022-02-15T05:25:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1045"},"modified":"2023-03-20T11:49:56","modified_gmt":"2023-03-20T10:49:56","slug":"raccourcis-excel-tableaux-croises-dynamiques","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/","title":{"rendered":"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>S\u00e9lection des meilleurs raccourcis Excel pour mieux g\u00e9rer les tableaux crois\u00e9s dynamiques. <\/em><\/strong><\/h4>\n\n\n\n<p>Voici une s\u00e9lection des meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques. Les tableaux crois\u00e9s dynamiques Excel, Excel Pivot table en Anglais, ou encore TCD pour l&rsquo;abr\u00e9viation, permettent de croiser les donn\u00e9es dans un fichier tr\u00e8s efficacement. Que la source soit un fichier plat de type CSV, un autre onglet Excel, une source SQL comme une table SQL Server ou encore un cube SSAS.<\/p>\n\n\n\n<p>Tout d&rsquo;abord, comment manipuler les tableaux crois\u00e9s dynamiques efficacement dans Excel et gagner du temps et de la productivit\u00e9 sur vos projets ? Voici sept raccourcis Excel sp\u00e9cifiques aux tableaux crois\u00e9s dynamiques cr\u00e9\u00e9s sous Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-selection-de-8-raccourcis-clavier-pour-manipuler-les-tableaux-croises-dynamiques-excel\">S\u00e9lection de 8 raccourcis clavier pour manipuler les tableaux crois\u00e9s dynamiques Excel<\/h2>\n\n\n\n<p>Pour commencer, les personnes travaillant dans la finance ma\u00eetrisent de nombreuses facettes et fonctionnalit\u00e9s d&rsquo;Excel. Cependant de nombreux utilisateurs d&rsquo;Excel ne connaissent pas les tableaux crois\u00e9s, mais seulement les tableaux classiques.<\/p>\n\n\n\n<p>Voici par exemple, une s\u00e9lection des meilleurs raccourcis Excel de s\u00e9lection ou d&rsquo;\u00e9dition de <a href=\"https:\/\/support.microsoft.com\/fr-fr\/office\/cr%C3%A9er-un-tableau-crois%C3%A9-dynamique-pour-analyser-des-donn%C3%A9es-de-feuille-de-calcul-a9a84538-bfe9-40a9-a8e9-f99134456576\" target=\"_blank\" rel=\"noreferrer noopener\">tableaux crois\u00e9s dynamiques<\/a> pour r\u00e9pondre par exemple aux questions suivantes avec des raccourcis simples mais efficaces !<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><b>Comment s\u00e9lectionner tout le tableau crois\u00e9 dynamique ?<\/b><\/li>\n\n\n\n<li><b>Ou encore regrouper ou s\u00e9parer les \u00e9l\u00e9ments de mon tableau crois\u00e9 dynamique Excel ?<\/b><\/li>\n\n\n\n<li><b>Comment masquer des \u00e9l\u00e9ments du tableau crois\u00e9 dynamique ?<\/b><\/li>\n\n\n\n<li><b>Quel raccourci pour cr\u00e9er un graphique \u00e0 partir des donn\u00e9es d&rsquo;un tableau existant ?<\/b><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>Action<\/th><th>Raccourci clavier<\/th><\/tr><\/thead><tbody><tr><td>Cocher ou d\u00e9cocher une case pour un champs<\/td><td>ESPACE<\/td><\/tr><tr><td>Grouper les \u00e9l\u00e9ments d&rsquo;un tableau crois\u00e9 Excel<\/td><td>ALT + SHIFT + FLECHE DROITE<\/td><\/tr><tr><td>S\u00e9parer les \u00e9l\u00e9ments d&rsquo;un tableau crois\u00e9 Excel<\/td><td>ALT + SHIFT + FLECHE GAUCHE<\/td><\/tr><tr><td>Cacher un \u00e9l\u00e9ment d&rsquo;un tableau crois\u00e9 Excel<\/td><td>FLECHE GAUCHE<\/td><\/tr><tr><td>Cacher un \u00e9l\u00e9ment d&rsquo;un tableau crois\u00e9 Excel<\/td><td>CTRL + &#8211; (Signe moins)<\/td><\/tr><tr><td>Cr\u00e9er un graphique \u00e0 partir des donn\u00e9es du tableau dans le m\u00eame onglet Excel<\/td><td>ALT + F1<\/td><\/tr><tr><td>Cr\u00e9er un graphique \u00e0 partir des donn\u00e9es du tableau dans un nouvel onglet Excel<\/td><td>F11<\/td><\/tr><tr><td>Ouvrir l&rsquo;assistant de cr\u00e9ation de tableaux crois\u00e9s dynamiques dans Excel<\/td><td>ALT + D + P<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\"><strong><em>Raccourcis Excel pour manipuler les tableaux crois\u00e9s dynamiques<\/em><\/strong><\/figcaption><\/figure>\n\n\n\n<p>Dans le m\u00eame sens, l&rsquo;utilisation des <em>pivot table<\/em> est tr\u00e8s r\u00e9pandue chez les professionnels de la finance, de la comptabilit\u00e9 et de la donn\u00e9e. En effet, ils permettent litt\u00e9ralement en quelques clics d&rsquo;analyser une quantit\u00e9 de donn\u00e9es importante. En conclusion, les raccourcis sont utiles une fois ma\u00eetris\u00e9s. Pour aller plus loin, voici un article pour <a href=\"https:\/\/expert-only.com\/fr\/excel\/supprimer-les-erreurs-excel\/\">supprimer les erreurs Excel de type #VALUE #NA<\/a>.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1600793941155\"><strong class=\"schema-faq-question\">Qu&rsquo;est-ce qu&rsquo;un tableau crois\u00e9 dynamique Excel ?<\/strong> <p class=\"schema-faq-answer\">Un tableau crois\u00e9 dynamique Excel est un tableau qui a des lignes et des colonnes, il permet d&rsquo;analyser les donn\u00e9es en les agr\u00e9geant \u00e0 travers chaque colonne. Il est construit \u00e0 partir d&rsquo;un tableau Excel ou d&rsquo;un Cube multi-dimensionnel par exemple.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>S\u00e9lection des meilleurs raccourcis Excel pour mieux g\u00e9rer les tableaux crois\u00e9s dynamiques. Voici une s\u00e9lection des meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques. Les tableaux crois\u00e9s dynamiques Excel, Excel Pivot table en Anglais, ou encore TCD pour l&rsquo;abr\u00e9viation, permettent <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\" title=\"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10907,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":{"0":"post-1045","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques<\/title>\n<meta name=\"description\" content=\"S\u00e9lection des meilleurs raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques et grouper, cacher ou s\u00e9parer des \u00e9l\u00e9ments par exemple.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques\" \/>\n<meta property=\"og:description\" content=\"S\u00e9lection des meilleurs raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques et grouper, cacher ou s\u00e9parer des \u00e9l\u00e9ments par exemple.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-15T05:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-20T10:49:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques\",\"datePublished\":\"2022-02-15T05:25:00+00:00\",\"dateModified\":\"2023-03-20T10:49:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\"},\"wordCount\":512,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg\",\"articleSection\":[\"Astuces Excel\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\",\"url\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\",\"name\":\"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg\",\"datePublished\":\"2022-02-15T05:25:00+00:00\",\"dateModified\":\"2023-03-20T10:49:56+00:00\",\"description\":\"S\u00e9lection des meilleurs raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques et grouper, cacher ou s\u00e9parer des \u00e9l\u00e9ments par exemple.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#faq-question-1600793941155\"}],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#faq-question-1600793941155\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#faq-question-1600793941155\",\"name\":\"Qu'est-ce qu'un tableau crois\u00e9 dynamique Excel ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Un tableau crois\u00e9 dynamique Excel est un tableau qui a des lignes et des colonnes, il permet d'analyser les donn\u00e9es en les agr\u00e9geant \u00e0 travers chaque colonne. Il est construit \u00e0 partir d'un tableau Excel ou d'un Cube multi-dimensionnel par exemple.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques","description":"S\u00e9lection des meilleurs raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques et grouper, cacher ou s\u00e9parer des \u00e9l\u00e9ments par exemple.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/","og_locale":"fr_FR","og_type":"article","og_title":"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques","og_description":"S\u00e9lection des meilleurs raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques et grouper, cacher ou s\u00e9parer des \u00e9l\u00e9ments par exemple.","og_url":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-02-15T05:25:00+00:00","article_modified_time":"2023-03-20T10:49:56+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques","datePublished":"2022-02-15T05:25:00+00:00","dateModified":"2023-03-20T10:49:56+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/"},"wordCount":512,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg","articleSection":["Astuces Excel"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/","url":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/","name":"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg","datePublished":"2022-02-15T05:25:00+00:00","dateModified":"2023-03-20T10:49:56+00:00","description":"S\u00e9lection des meilleurs raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques et grouper, cacher ou s\u00e9parer des \u00e9l\u00e9ments par exemple.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#faq-question-1600793941155"}],"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/triangle-3F6C656056D_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Les meilleurs raccourcis Excel pour tableaux crois\u00e9s dynamiques"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#faq-question-1600793941155","position":1,"url":"https:\/\/expert-only.com\/fr\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/#faq-question-1600793941155","name":"Qu'est-ce qu'un tableau crois\u00e9 dynamique Excel ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Un tableau crois\u00e9 dynamique Excel est un tableau qui a des lignes et des colonnes, il permet d'analyser les donn\u00e9es en les agr\u00e9geant \u00e0 travers chaque colonne. Il est construit \u00e0 partir d'un tableau Excel ou d'un Cube multi-dimensionnel par exemple.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1045"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10907"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}