{"id":450,"date":"2020-08-30T22:35:00","date_gmt":"2020-08-30T20:35:00","guid":{"rendered":"https:\/\/www.ep2b.fr\/?p=450"},"modified":"2024-07-19T02:31:07","modified_gmt":"2024-07-19T00:31:07","slug":"excel","status":"publish","type":"post","link":"https:\/\/www.ep2b.fr\/index.php\/2020\/08\/30\/excel\/","title":{"rendered":"Excel"},"content":{"rendered":"\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<div class=\"video-container\"><iframe loading=\"lazy\" title=\"Excel Pr\u00e9sentation Programme 2019 2020\" width=\"740\" height=\"416\" src=\"https:\/\/www.youtube.com\/embed\/i7AUYzjneWk?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><\/div>\n<\/div><\/figure>\n\n\n<p>Toutes les comp\u00e9tences pour la ma\u00eetrise du tableur universel<\/p>\n<h1>Ouvrir et sauvegarder un classeur<\/h1>\n<ul>\n<li>Gagner du temps en utilisant des mod\u00e8les (&#8220;templates&#8221;)<\/li>\n<li>R\u00e9cup\u00e9rer un fichier perdu<\/li>\n<li>Utiliser un fichier sur le cloud (onedrive)<\/li>\n<\/ul>\n<h1>Organiser les donn\u00e9es<\/h1>\n<ul>\n<li>cr\u00e9er des tableaux<\/li>\n<li>d\u00e9placer les donn\u00e9es<\/li>\n<li>appliquer des ent\u00eates<\/li>\n<\/ul>\n<h1>Calculer<\/h1>\n<ul>\n<li>cr\u00e9er des formules simples de calcul\n<ul>\n<li>arithm\u00e9tique<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1>Automatiser les calculs<\/h1>\n<ul>\n<li>cr\u00e9er des formules de calculs qui s&#8217;appliquent \u00e0 plusieurs cellules<\/li>\n<li>g\u00e9rer les r\u00e9f\u00e9rences relatives et absolues<\/li>\n<\/ul>\n<h1>Compter les informations<\/h1>\n<ul>\n<li>appliquer des crit\u00e8res\n<ul>\n<li>num\u00e9rique<\/li>\n<li>textuels<\/li>\n<li>calendaires<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1>Synth\u00e9tiser les donn\u00e9es<\/h1>\n<ul>\n<li>avec de simples totaux<\/li>\n<li>avec des tableaux crois\u00e9s dynamiques<\/li>\n<\/ul>\n<h1>Visualiser les donn\u00e9es<\/h1>\n<ul>\n<li>ins\u00e9rer et mettre en forme des graphiques<\/li>\n<li>ajouter et connecter une chronologie<\/li>\n<li>ajouter et connecter un segment<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/www.ep2b.fr\/index.php\/category\/excel-cours-complet\/\">D\u00e9couvrez le cours complet Excel<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Budgets, plannings, pr\u00e9visionnels&#8230; on ne peut pas se passer du tableur. D\u00e9couvrez les astuces des pros pour all\u00e9ger vos tableaux<\/p>\n","protected":false},"author":1,"featured_media":1165,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,35,37],"tags":[85,84],"_links":{"self":[{"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/posts\/450"}],"collection":[{"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/comments?post=450"}],"version-history":[{"count":10,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/posts\/450\/revisions"}],"predecessor-version":[{"id":1175,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/posts\/450\/revisions\/1175"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/media\/1165"}],"wp:attachment":[{"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/media?parent=450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/categories?post=450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ep2b.fr\/index.php\/wp-json\/wp\/v2\/tags?post=450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}