{"id":50,"date":"2016-11-03T00:56:59","date_gmt":"2016-11-02T23:56:59","guid":{"rendered":"http:\/\/conrado.fr\/?p=50"},"modified":"2026-02-04T22:44:07","modified_gmt":"2026-02-04T21:44:07","slug":"excel","status":"publish","type":"post","link":"https:\/\/conrado.fr\/index.php\/2016\/11\/03\/excel\/","title":{"rendered":"Excel"},"content":{"rendered":"

RESSOURCES EXCEL<\/h2>\n

S\u00e9ance num\u00e9ro 1 :<\/span><\/p>\n

Enonce-budget-de-tresorerie.doc<\/a><\/p>\n

Exercice – Budget de tr\u00e9sorerie<\/a><\/p>\n

tutoriel-les-series<\/a><\/p>\n

tutoriel-deplacements-et-selections-sous-excel<\/a><\/p>\n

mise-en-forme-de-tableaux<\/a><\/p>\n

S\u00e9ance num\u00e9ro 2 :<\/span><\/p>\n

\n\n\n\n<\/p>\n

Exo-Calculs-simples<\/p>\n\n\n\n

<\/a><\/p>\n

exo-chiffre-daffaire-trimestre-1<\/a><\/p>\n

exo-test-de-physique<\/a><\/p>\n

chiffre-daffaire-trimestriel<\/a><\/p>\n

modifications-de-tableaux<\/a><\/p>\n

S\u00e9ance num\u00e9ro 3 :<\/span><\/p>\n

R\u00e9f\u00e9rences-absolues<\/a><\/p>\n

graphiques<\/a><\/p>\n

graphiques-boursiers<\/a><\/p>\n

atelier-de-montage<\/a><\/p>\n

images-graphiques<\/a><\/p>\n

S\u00e9ance num\u00e9ro 4 :<\/span><\/p>\n

concatener-et-calculs-dheures<\/a><\/p>\n

fonctions-de-texte<\/a><\/p>\n

somme-si-et-nb-si<\/a><\/p>\n

Somme.si.ens<\/a><\/p>\n

Exercice – Fonction si<\/a><\/p>\n

Correction – Exercice – Fonction si<\/a><\/p>\n

S\u00e9ance num\u00e9ro 5 :<\/span><\/p>\n

base-de-donnees<\/a><\/p>\n

bdd_tcd<\/a><\/p>\n

mise-en-forme-conditionnelle<\/a><\/p>\n

plan-excel<\/a><\/p>\n

recherchev<\/a><\/p>\n

Recherchev 2<\/a><\/p>\n

Recherchev pour remplir une colonne<\/a><\/p>\n

R\u00e9visions et tutoriels :<\/span><\/p>\n

revisions-excel<\/a><\/p>\n

revision-excel<\/a><\/p>\n

les-formules-sous-excel<\/a><\/p>\n

Divers :<\/span><\/p>\n

balance<\/a><\/p>\n

Fichier .zip<\/span><\/p>\n

excel<\/a><\/p>\n

Logos ESAS<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Fonction SI<\/a><\/div>\n\n\n\n
BD-Fournisseurs<\/a><\/div>\n\n\n\n
Vierge – TCD ou SOMME.SI.ENS<\/a><\/div>\n\n\n\n

https:\/\/drive.google.com\/drive\/folders\/1ck686os78QWu4Cm_vKYLkHguPkciZw_v?usp=sharing<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n

Exemples de formats personnalis\u00e9s<\/a><\/div>\n\n\n\n
Calculs-divers-RH<\/a><\/div>\n\n\n\n
Exo-Calculs-simples<\/a><\/div>\n\n\n\n
BDD-Medical<\/a><\/div>\n\n\n\n

https:\/\/drive.google.com\/drive\/folders\/1Ft3xVlsdDpKTr0g-x5DlMztl6V7W-y5v?usp=drive_link<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

RESSOURCES EXCEL S\u00e9ance num\u00e9ro 1 : Enonce-budget-de-tresorerie.doc Exercice – Budget de tr\u00e9sorerie tutoriel-les-series tutoriel-deplacements-et-selections-sous-excel mise-en-forme-de-tableaux S\u00e9ance num\u00e9ro 2 : Exo-Calculs-simples exo-chiffre-daffaire-trimestre-1 exo-test-de-physique chiffre-daffaire-trimestriel modifications-de-tableaux S\u00e9ance num\u00e9ro 3 : R\u00e9f\u00e9rences-absolues graphiques graphiques-boursiers atelier-de-montage images-graphiques S\u00e9ance num\u00e9ro 4 : concatener-et-calculs-dheures fonctions-de-texte somme-si-et-nb-si Somme.si.ens Exercice – Fonction si Correction – Exercice – Fonction si S\u00e9ance num\u00e9ro 5 : […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"_links":{"self":[{"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/posts\/50"}],"collection":[{"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/comments?post=50"}],"version-history":[{"count":40,"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":1479,"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/posts\/50\/revisions\/1479"}],"wp:attachment":[{"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/media?parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/categories?post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/conrado.fr\/index.php\/wp-json\/wp\/v2\/tags?post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}