{"id":11087,"date":"2021-01-03T00:28:28","date_gmt":"2021-01-02T22:28:28","guid":{"rendered":"https:\/\/www.xlerateur.com\/?p=11087"},"modified":"2021-01-04T03:36:31","modified_gmt":"2021-01-04T01:36:31","slug":"les-nouveaux-types-de-donnees-dans-excel-insider","status":"publish","type":"post","link":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/","title":{"rendered":"Les nouveaux types de donn\u00e9es dans Excel (Insider)"},"content":{"rendered":"\n<p>Voici une petite introduction aux nouveaux types de donn\u00e9es dans Excel.<\/p>\n\n\n\n<p>Vous avez d\u00e9j\u00e0 acc\u00e8s aux :<\/p>\n\n\n\n<ul><li>Donn\u00e9es boursi\u00e8res<\/li><li>Donn\u00e9es g\u00e9ographique<\/li><\/ul>\n\n\n\n<p>Pour le moment, il faut la la version insider (b\u00e9ta). Mais prochainement, vous pourrez acc\u00e9der \u00e0 de nombreux autres types de donn\u00e9es : <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"398\" height=\"319\" src=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1.png\" alt=\"\" class=\"wp-image-11089\" srcset=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1.png 398w, https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1-300x240.png 300w, https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1-187x150.png 187w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/figure>\n\n\n\n<p>Voici une petite vid\u00e9o qui montre comment s'y prendre<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/TypeDeDonnees.mp4\"><\/video><\/figure>\n\n\n\n<p>Et en bonus, comment calculer le nombre d'ann\u00e9es depuis la date du film?<\/p>\n\n\n\n<p> 1\/ On peut simplement \u00e9crire =A2. (ne pas oublier le .) et on acc\u00e8de \u00e0 toutes les donn\u00e9es ! <\/p>\n\n\n\n<p>2\/ Ce qui nous donne la formule suivante : <br \/>=DATEDIF(A2.[release date];AUJOURDHUI();\"Y\")<\/p>\n\n\n\n<p>Formidable \ud83d\ude42 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"871\" height=\"488\" src=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-2.png\" alt=\"\" class=\"wp-image-11093\" srcset=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-2.png 871w, https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-2-300x168.png 300w, https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-2-768x430.png 768w, https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-2-250x140.png 250w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/a><\/figure>\n<div class=\"tnp tnp-subscription\">\n<form method=\"post\" action=\"https:\/\/www.xlerateur.com\/?na=s\" style=\"display: inline;\">\n\n<input type=\"hidden\" name=\"nlang\" value=\"\">\n<div class=\"tnp-field tnp-field-email\"><label for=\"tnp-3\">Abonnement \u00e0 la newsletter gratuite d&#039;XLerateur<\/label><input class=\"tnp-email\" type=\"email\" name=\"ne\" id=\"tnp-3\" value=\"Votre_email\" required=\"\" style=\"background-color: #BCC7C3; width: 400px\"><\/div><div class=\"tnp-field tnp-field-button\"><input class=\"tnp-submit\" type=\"submit\" style=\"background-color: #6EBF60;\" value=\"S&#039;abonner\"><\/div>\n<\/form>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Voici une petite introduction aux nouveaux types de donn\u00e9es dans Excel. Vous avez d\u00e9j\u00e0 acc\u00e8s aux : Donn\u00e9es boursi\u00e8res Donn\u00e9es g\u00e9ographique Pour le moment, il faut la la version insider (b\u00e9ta). Mais prochainement, vous pourrez acc\u00e9der \u00e0 de nombreux autres types de donn\u00e9es : Voici une petite vid\u00e9o qui montre \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":117,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Les nouveaux types de donn\u00e9es dans Excel (Insider) - XL\u00e9rateur<\/title>\n<meta name=\"description\" content=\"Excel VBA cours formation\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les nouveaux types de donn\u00e9es dans Excel (Insider) - XL\u00e9rateur\" \/>\n<meta property=\"og:description\" content=\"Excel VBA cours formation\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\" \/>\n<meta property=\"og:site_name\" content=\"XL\u00e9rateur\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-02T22:28:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-04T01:36:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1.png\" \/>\n<meta name=\"author\" content=\"Gaetan Mourmant\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gaetan Mourmant\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\"},\"author\":{\"name\":\"Gaetan Mourmant\",\"@id\":\"https:\/\/www.xlerateur.com\/#\/schema\/person\/4110698f3e24a2203fbe8fe31e797f12\"},\"headline\":\"Les nouveaux types de donn\u00e9es dans Excel (Insider)\",\"datePublished\":\"2021-01-02T22:28:28+00:00\",\"dateModified\":\"2021-01-04T01:36:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\"},\"wordCount\":116,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.xlerateur.com\/#organization\"},\"articleSection\":[\"Divers\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\",\"url\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\",\"name\":\"Les nouveaux types de donn\u00e9es dans Excel (Insider) - XL\u00e9rateur\",\"isPartOf\":{\"@id\":\"https:\/\/www.xlerateur.com\/#website\"},\"datePublished\":\"2021-01-02T22:28:28+00:00\",\"dateModified\":\"2021-01-04T01:36:31+00:00\",\"description\":\"Excel VBA cours formation\",\"breadcrumb\":{\"@id\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.xlerateur.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les nouveaux types de donn\u00e9es dans Excel (Insider)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.xlerateur.com\/#website\",\"url\":\"https:\/\/www.xlerateur.com\/\",\"name\":\"XL\u00e9rateur\",\"description\":\"Acc\u00e9l\u00e9rez Excel ! Cours, Formation sur Excel et VBA\",\"publisher\":{\"@id\":\"https:\/\/www.xlerateur.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.xlerateur.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.xlerateur.com\/#organization\",\"name\":\"XLerateur\",\"url\":\"https:\/\/www.xlerateur.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.xlerateur.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2019\/02\/logo-1.png\",\"contentUrl\":\"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2019\/02\/logo-1.png\",\"width\":332,\"height\":101,\"caption\":\"XLerateur\"},\"image\":{\"@id\":\"https:\/\/www.xlerateur.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.xlerateur.com\/#\/schema\/person\/4110698f3e24a2203fbe8fe31e797f12\",\"name\":\"Gaetan Mourmant\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.xlerateur.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e08256edd8e641fc5ca94f43df3b355c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e08256edd8e641fc5ca94f43df3b355c?s=96&d=mm&r=g\",\"caption\":\"Gaetan Mourmant\"},\"url\":\"https:\/\/www.xlerateur.com\/author\/gaetan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les nouveaux types de donn\u00e9es dans Excel (Insider) - XL\u00e9rateur","description":"Excel VBA cours formation","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:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/","og_locale":"fr_FR","og_type":"article","og_title":"Les nouveaux types de donn\u00e9es dans Excel (Insider) - XL\u00e9rateur","og_description":"Excel VBA cours formation","og_url":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/","og_site_name":"XL\u00e9rateur","article_published_time":"2021-01-02T22:28:28+00:00","article_modified_time":"2021-01-04T01:36:31+00:00","og_image":[{"url":"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2021\/01\/image-1.png"}],"author":"Gaetan Mourmant","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Gaetan Mourmant","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#article","isPartOf":{"@id":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/"},"author":{"name":"Gaetan Mourmant","@id":"https:\/\/www.xlerateur.com\/#\/schema\/person\/4110698f3e24a2203fbe8fe31e797f12"},"headline":"Les nouveaux types de donn\u00e9es dans Excel (Insider)","datePublished":"2021-01-02T22:28:28+00:00","dateModified":"2021-01-04T01:36:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/"},"wordCount":116,"commentCount":0,"publisher":{"@id":"https:\/\/www.xlerateur.com\/#organization"},"articleSection":["Divers"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/","url":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/","name":"Les nouveaux types de donn\u00e9es dans Excel (Insider) - XL\u00e9rateur","isPartOf":{"@id":"https:\/\/www.xlerateur.com\/#website"},"datePublished":"2021-01-02T22:28:28+00:00","dateModified":"2021-01-04T01:36:31+00:00","description":"Excel VBA cours formation","breadcrumb":{"@id":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.xlerateur.com\/divers\/2021\/01\/03\/les-nouveaux-types-de-donnees-dans-excel-insider-11087\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.xlerateur.com\/"},{"@type":"ListItem","position":2,"name":"Les nouveaux types de donn\u00e9es dans Excel (Insider)"}]},{"@type":"WebSite","@id":"https:\/\/www.xlerateur.com\/#website","url":"https:\/\/www.xlerateur.com\/","name":"XL\u00e9rateur","description":"Acc\u00e9l\u00e9rez Excel ! Cours, Formation sur Excel et VBA","publisher":{"@id":"https:\/\/www.xlerateur.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.xlerateur.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.xlerateur.com\/#organization","name":"XLerateur","url":"https:\/\/www.xlerateur.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.xlerateur.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2019\/02\/logo-1.png","contentUrl":"https:\/\/www.xlerateur.com\/wp-content\/uploads\/2019\/02\/logo-1.png","width":332,"height":101,"caption":"XLerateur"},"image":{"@id":"https:\/\/www.xlerateur.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.xlerateur.com\/#\/schema\/person\/4110698f3e24a2203fbe8fe31e797f12","name":"Gaetan Mourmant","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.xlerateur.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e08256edd8e641fc5ca94f43df3b355c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e08256edd8e641fc5ca94f43df3b355c?s=96&d=mm&r=g","caption":"Gaetan Mourmant"},"url":"https:\/\/www.xlerateur.com\/author\/gaetan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/posts\/11087"}],"collection":[{"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/comments?post=11087"}],"version-history":[{"count":5,"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/posts\/11087\/revisions"}],"predecessor-version":[{"id":11099,"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/posts\/11087\/revisions\/11099"}],"wp:attachment":[{"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/media?parent=11087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/categories?post=11087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xlerateur.com\/wp-json\/wp\/v2\/tags?post=11087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}