{"id":2128,"date":"2021-04-28T18:02:48","date_gmt":"2021-04-28T16:02:48","guid":{"rendered":"http:\/\/thjjwyy.cluster030.hosting.ovh.net\/?post_type=lp_course&p=2128"},"modified":"2025-12-05T16:47:09","modified_gmt":"2025-12-05T15:47:09","slug":"excel-base-de-donnees-et-tableaux-croises-dynamiques","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/","title":{"rendered":"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Programme<\/h3>

Le vocabulaire<\/h5>

Construire une base de donn\u00e9es
M\u00e9thodes de conception
D\u00e9finition des champs
Saisie d\u2019enregistrements
Utilisation de listes de saisie
Ajouter\/ modifier des enregistrements
Gestion des listes<\/p>

G\u00e9rer les enregistrements<\/h5>

Les tris automatiques, les tris multicrit\u00e8res
Extraction d\u2019enregistrements
Filtre automatique
Personnalisation de filtres
Filtres \u00e9labor\u00e9s<\/p>

R\u00e9aliser des sous totaux<\/h5>

Utilisation du plan<\/p>

Les tableaux crois\u00e9s dynamiques<\/h5>

Cr\u00e9ation d\u2019un tableau
Personnalisation et actualisation d\u2019un tableau
D\u00e9finition
Objectif d\u2019utilisation
Mise en place \u00e0 partir d\u2019une liste existante
Assistant Tableau Crois\u00e9 dynamique
Champs dynamiques :
– colonne, ligne
– donn\u00e9es, page<\/p>

Les fonctions Base de Donn\u00e9es<\/h5>

BDSOMME, BDMOYENNE, SOUSTOTAL…<\/p>

Les fonctions statistiques<\/h5>

SOMME.SI, NB.SI…<\/p>

Moyens techniques mis \u00e0 disposition<\/h5>

Supports d\u2019animation p\u00e9dagogique utilis\u00e9s en vid\u00e9oprojection.
1 PC\/stagiaire, connexion Wifi, imprimante multifonctions.
Installation dans notre centre de formation : salles de formation \u00e9quip\u00e9es de tables, chaises, mur clair pour la projection, paperboard et\/ou tableau blanc ou num\u00e9rique interactif.
En cas de formation intra-entreprise, des installations \u00e9quivalentes doivent \u00eatre mises \u00e0 disposition par l\u2019employeur des stagiaires.<\/p>

\u00a0<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLa fiche formation<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tNos tarifs<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLe planning<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Programme Le vocabulaire Construire une base de donn\u00e9esM\u00e9thodes de conceptionD\u00e9finition des champsSaisie d\u2019enregistrementsUtilisation de listes de saisieAjouter\/ modifier des enregistrementsGestion des listes G\u00e9rer les enregistrements Les tris automatiques, les tris multicrit\u00e8resExtraction d\u2019enregistrementsFiltre automatiquePersonnalisation de filtresFiltres \u00e9labor\u00e9s R\u00e9aliser des sous totaux Utilisation du plan Les tableaux crois\u00e9s dynamiques Cr\u00e9ation d\u2019un tableauPersonnalisation…<\/p>\n","protected":false},"author":6,"featured_media":6001,"comment_status":"closed","ping_status":"closed","template":"","course_category":[10,36],"course_tag":[],"class_list":["post-2128","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-bureautique","course_category-tableur-excel-et-calc","course"],"yoast_head":"\nEXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES -<\/title>\n<meta name=\"description\" content=\"Programme de formation Control C Melun d'un jour sur le logiciel Excel . Perfectionnement sur les bases de donn\u00e9es et TCD\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES -\" \/>\n<meta property=\"og:description\" content=\"Programme de formation Control C Melun d'un jour sur le logiciel Excel . Perfectionnement sur les bases de donn\u00e9es et TCD\" \/>\n<meta property=\"og:url\" content=\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-05T15:47:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@controlcmelun\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/\",\"name\":\"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"datePublished\":\"2021-04-28T16:02:48+00:00\",\"dateModified\":\"2025-12-05T15:47:09+00:00\",\"description\":\"Programme de formation Control C Melun d'un jour sur le logiciel Excel . Perfectionnement sur les bases de donn\u00e9es et TCD\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#primaryimage\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"width\":200,\"height\":200,\"caption\":\"Microsoft Excel 2019 ic\u00f4ne par Icons8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/controlc.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\/\/controlc.fr\/index.php\/cours-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/controlc.fr\/#website\",\"url\":\"https:\/\/controlc.fr\/\",\"name\":\"Controlc.fr\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/controlc.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/controlc.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/controlc.fr\/#organization\",\"name\":\"Control^C\",\"url\":\"https:\/\/controlc.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"width\":427,\"height\":100,\"caption\":\"Control^C\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/controlcmelun\",\"https:\/\/www.linkedin.com\/company\/8009384\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES -","description":"Programme de formation Control C Melun d'un jour sur le logiciel Excel . Perfectionnement sur les bases de donn\u00e9es et TCD","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:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/","og_locale":"fr_FR","og_type":"article","og_title":"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES -","og_description":"Programme de formation Control C Melun d'un jour sur le logiciel Excel . Perfectionnement sur les bases de donn\u00e9es et TCD","og_url":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/","article_modified_time":"2025-12-05T15:47:09+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@controlcmelun","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/","url":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/","name":"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","datePublished":"2021-04-28T16:02:48+00:00","dateModified":"2025-12-05T15:47:09+00:00","description":"Programme de formation Control C Melun d'un jour sur le logiciel Excel . Perfectionnement sur les bases de donn\u00e9es et TCD","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#primaryimage","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","width":200,"height":200,"caption":"Microsoft Excel 2019 ic\u00f4ne par Icons8"},{"@type":"BreadcrumbList","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-base-de-donnees-et-tableaux-croises-dynamiques\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/controlc.fr\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/controlc.fr\/index.php\/cours-2\/"},{"@type":"ListItem","position":3,"name":"EXCEL BASE DE DONNEES ET TABLEAUX CROISES DYNAMIQUES"}]},{"@type":"WebSite","@id":"https:\/\/controlc.fr\/#website","url":"https:\/\/controlc.fr\/","name":"Controlc.fr","description":"","publisher":{"@id":"https:\/\/controlc.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/controlc.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/controlc.fr\/#organization","name":"Control^C","url":"https:\/\/controlc.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","width":427,"height":100,"caption":"Control^C"},"image":{"@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/controlcmelun","https:\/\/www.linkedin.com\/company\/8009384"]}]}},"_links":{"self":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/2128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2128"}],"version-history":[{"count":70,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/2128\/revisions"}],"predecessor-version":[{"id":6488,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/2128\/revisions\/6488"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media\/6001"}],"wp:attachment":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2128"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=2128"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=2128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}