Accueil
Communication / web
TOUT SAVOIR SUR LE RGPD
Création de sites internet
Création de sites e-commerce
Communication globale
Création d'Intranet / Extranet
Création d'application mobile
Développement
Formations
LA FORMATION :
La formation FORMASOFT PRO
Formation spécifique
Compte personnel de formation CPF
Financement de votre formation
Le plan de formation Entreprise PFE
Thématiques
BUREAUTIQUE
PAO INFOGRAPHIE
PROGRAMMATION & BASES DE DONNEES
INTERNET & ANIMATION WEB
[
0
=> stdClass Object (
id_formation
=>
43
code
=>
"BUR"
titre
=>
"ACCESS Initiation"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
3
heure
=>
7
prerequis
=>
"Connaissance de l'environnement Windows nécessaire. La connaissance de Microsoft Excel est un plus."
public
=>
"TOUT PUBLIC"
moyentec
=>
""
objectif
=>
"Maîtriser les fonctionnalités de base de Microsoft Access afin de concevoir et organiser une base de données;"
programme
=>
"<p><strong><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">S’adapter à l’environnement Microsoft Access</span></strong></p> <ul> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Les notions fondamentales : notions de tables, formulaires, </span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">requêtes, états et macros</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Créer une nouvelle base de données </span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Ouvrir ou enregistrer une base de données existante</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Importer et/ou exporter des données </span></li> </ul> <div>&nbsp;</div> <div><strong><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Créer et gérer une table de données</span></strong></div> <ul> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Créer différentes tables et définir les champs de données</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Déterminer une clé primaire</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Définir les relations entre tables (notion d’intégrité référentielle) </span></li> </ul> <div><strong><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Saisir des données à l’aide de formulaires</span></strong></div> <ul> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Créer un formulaire à l’aide de l’assistant</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Définir la présentation et le style du formulaire</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Insérer des listes déroulantes</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Utiliser des sous-formulaires </span></li> </ul> <div>&nbsp;</div> <div><strong><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Utiliser les requêtes pour filtrer et/ou trier ses données</span></strong></div> <ul> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Définir un filtre (choix des champs et critères de sélection)</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Trier ses données : tris simples ou multiples</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Concevoir une requête multi-critères </span></li> </ul> <div>&nbsp;</div> <div><strong><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Concevoir des états pour analyser les résultats d’une base de données</span></strong></div> <ul> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Créer un état à partir des enregistrements effectués</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Créer un état via une requête</span></li> <li><span style="font-family: Arial, Verdana; color: #545342; font-size: 12px;">Imprimer un état</span></li> </ul><script src="https://cdn.flmngr.com/widgets.js?apiKey=3wCDP2Uh" data-ts="1781870594922"></script>"
tp
=>
""
plan
=>
"CPF (TOSA DIGITAL)"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-28"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img43.jpg"
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
1
=> stdClass Object (
id_formation
=>
44
code
=>
"BUR"
titre
=>
"ACCESS Perfectionnement"
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
3
heure
=>
7
prerequis
=>
"Connaissance de l'environnement Windows nécessaire. La connaissance de Microsoft Access niveau initiation est indispensable."
public
=>
""
moyentec
=>
""
objectif
=>
""
programme
=>
"<p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Rappel des notions de base<o:p></o:p></span></b></p> <ul> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Méthodologie de création d’une base de données</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\">Relations, intégrité référentielles et jointures</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\">Objets, Table, Requête, Formulaire, Etat<o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p> </o:p></span></li> </ul> <p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Utiliser Excel pour préparer les Tables</span></b></p> <ul> <li><b><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p></o:p></span></b><span style=\"font-family: Arial; color: black; font-size: 9pt\">Création de Tables. Filtrer et extraire les données<o:p></o:p></span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Préparation des données pour l’importation <o:p></o:p></span></li> </ul> <p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Tables</span></b><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p></o:p></span></p> <ul> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Structure d’une Table. Propriétés avancées</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Créer des listes de choix</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Eclatement d’une table en plusieurs tables<o:p></o:p></span></li> </ul> <p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Utiliser les requêtes pour filtrer et/ou trier ses données</span></b></p> <ul> <li><b><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p></o:p></span></b>Définir un filtre (choix des champs et critères de sélection)</li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Trier ses données. Concevoir une requête multi-critères <o:p></o:p></span></li> </ul> <p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Requêtes</span></b></p> <ul> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Paramètres d’une requête. Propriétés des champs et des requêtes</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\">Requêtes «Ajout», «Suppression», «Mise à jour», «Analyse croisée»</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Requête de jointure externe. Test conditionnel et fonctions avancées<o:p></o:p></span></li> </ul> <p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Formulaire (mode création, sans assistant)</span></b></p> <ul> <li><b><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p></o:p></span></b>Création, modification et changement de type de formulaire</li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Filtrage des données. Insertion d’objets complexes, OLE<o:p></o:p></span></li> </ul> <p style=\"line-height: 12.05pt; margin: 0cm 0cm 0pt; mso-layout-grid-align: none\" class=\"MsoNormal\"><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Etat (mode création, sans assistant)</span></b></p> <ul> <li><b><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p></o:p></span></b>Sections, Regroupements, Tris</li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Modification d’un état en mode création</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\">Totaux, sous-totaux et autres champs calculés</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\">Présentation et mise en page Etat</span></li> <li><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\">Générateur d’expressions</span></li> </ul> <p><span style=\"font-family: Arial; color: black; font-size: 9pt\"><o:p></o:p></span><b><span style=\"font-family: Arial; color: black; font-size: 10pt\">Macros<o:p></o:p></span></b><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p> </o:p></span></p> <ul> <li><span style=\"font-family: Arial; color: black; font-size: 10pt\"><o:p></o:p></span><span style=\"font-family: Arial; color: black; font-size: 9pt\">Macros simples et macros auto-exécutables<o:p></o:p></span></li> </ul>"
tp
=>
""
plan
=>
"CPF"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-30"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
2
=> stdClass Object (
id_formation
=>
212
code
=>
"EXVBA"
titre
=>
"Devenir expert excel et mcro vba"
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
5
heure
=>
8
prerequis
=>
"Excel avancé"
public
=>
"Tous"
moyentec
=>
"Ordinateur + excel"
objectif
=>
"Acquérir les fonctions avancées d'Excel. Acquérir les bases du langage VBA et de la programmation orientée objets sous EXCEL. "
programme
=>
"<p class=\"MsoNormal\" style=\"line-height: 12.05pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; vertical-align: baseline;\"><b><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\">Créer une base de données</span></b><span style=\"box-sizing: border-box; outline: 0px\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l2 level1 lfo7;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Saisir et trier une base de données</span></span><span style=\"font-size:10.5pt;font-family: Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <p><span style=\"box-sizing: border-box;outline: 0px\"> </span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l2 level1 lfo7;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Définir un ou plusieurs filtres</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <p><span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l2 level1 lfo7;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Utiliser les fonctions bases de données (BDSOMME, BDMOYENNE...)</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l2 level1 lfo7;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Calculer des sous-totaux<b style=\"box-sizing: border-box;outline: 0px\"> </b></span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"MsoNormal\" style=\"line-height: 12.05pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; vertical-align: baseline; box-sizing: border-box; outline: 0px;\"><b style=\"box-sizing: border-box;outline: 0px\"><span style=\"box-sizing: border-box; outline: 0px\"><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\">Utiliser les tableaux croisés dynamiques</span></span></b><span style=\"box-sizing: border-box;outline: 0px\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l6 level1 lfo8;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Créer et modifier un tableau croisé dynamique</span></span><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l6 level1 lfo8;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Représenter graphiquement un tableau croisé dynamique et l’analyser</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l6 level1 lfo8;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Générer et modifier la consolidation d’un tableau<b style=\"box-sizing: border-box; outline: 0px\"> </b></span></span><span style=\"font-size:10.5pt;font-family: Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"MsoNormal\" style=\"line-height: 12.05pt; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; vertical-align: baseline; box-sizing: border-box; outline: 0px;\"><b style=\"box-sizing: border-box;outline: 0px\"><span style=\"box-sizing: border-box; outline: 0px\"><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\">Approfondir l’utilisation des formules de calcul</span></span></b><span style=\"box-sizing: border-box;outline: 0px\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l0 level1 lfo9;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Les notions de référence relative, absolue et mixte</span></span><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l0 level1 lfo9;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Les fonctions logiques (statistiques, conditions, etc.)</span></span><span style=\"font-size: 10.5pt;font-family:Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l0 level1 lfo9;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Les fonctions date, heure, et texte</span></span><span style=\"font-size:10.5pt;font-family: Roboto;color:#8C8C8C\"><u1:p style=\"margin: 0px; padding: 0px; box-sizing: border-box;\"></u1:p></span><o:p></o:p></p> <span style=\"box-sizing: border-box;outline: 0px\"> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l0 level1 lfo9;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size: 9pt; font-family: Arial, sans-serif; border: 1pt none windowtext; padding: 0cm;\"><span style=\"box-sizing: border-box;outline: 0px\">Les fonctions de recherche RECHERCHEH() et RECHERCHE V()</span></span><span style=\"font-size: 10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"vertical-align:baseline\"><strong><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C;border:none windowtext 1.0pt; mso-border-alt:none windowtext 0cm;padding:0cm\">MACROS</span></strong><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Enregistrer des macros à partir d’Excel.<o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Création, visualisation et modifi cation du code.<o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Références relatives et absolues.<o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Le classeur de macros personnelles.<o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Utilisation d’objets Excel.<o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Classeurs, feuilles, cellules.<o:p></o:p></span></p> <p class=\"type-3\" style=\"margin-top:0cm;margin-right:0cm;margin-bottom:3.0pt; margin-left:0cm;text-indent:-18.0pt;mso-list:l7 level1 lfo1;tab-stops:list 36.0pt; vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt; mso-bidi-font-size:10.5pt;font-family:Symbol;mso-fareast-font-family:Symbol; mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\">Objets graphiques (bouton de commande, liste déroulante,etc.).<o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"vertical-align:baseline\"><strong style=\"box-sizing: border-box; outline: 0px\"><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C; border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm;padding:0cm\">DECOUVRIR VISUAL BASIC APPLICATION</span></strong><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Présenter l’interface de programmation.</span></span><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Défi nir les concepts : objets, méthode, propriétés.</span></span><span style=\"font-size: 10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Comment utiliser les outils d’aide à la programmation ?</span></span><span style=\"font-size: 10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Macro en enregistrement.</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Création, visualisation et modifi cation du code.</span></span><span style=\"font-size: 10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Utilisation d’objets Excel.</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Classeurs, feuilles, cellules.</span></span><span style=\"font-size:10.5pt;font-family: Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l8 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Objets graphiques (bouton de commande, liste déroulante,etc.).</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"vertical-align:baseline\"><strong style=\"box-sizing: border-box; outline: 0px\"><span style=\"box-sizing: border-box;outline: 0px\"><span style=\"font-size:10.5pt;font-family:"Arial",sans-serif;color:#545342; border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm;padding:0cm\">MANIPULATION D’OBJETS, DE LEURS PROPRIETES ET METHODES</span></span></strong><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l3 level1 lfo3;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Création de boîtes de dialogue.</span></span><span style=\"font-size:10.5pt;font-family: Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l3 level1 lfo3;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Formulaire, intitulé, zone de texte, liste, onglets.</span></span><span style=\"font-size: 10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l3 level1 lfo3;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Manipulation de chaînes de caractères, valeurs numériques et dates.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l3 level1 lfo3;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">onctions chaînes, numériques, dates.</span></span><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l3 level1 lfo3;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Fonctions de conversions.</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"vertical-align:baseline\"><strong style=\"box-sizing: border-box; outline: 0px\"><span style=\"box-sizing: border-box;outline: 0px\"><span style=\"font-size:10.5pt;font-family:"Arial",sans-serif;color:#545342; border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm;padding:0cm\">SUIVRE LE DEROULEMENT DE LA MACRO</span></span></strong><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Les structures de décision.</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Les variables.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Déclaration et types.</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Tableau.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Boucles.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Compteur.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Conditionnelles.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Conditions.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Instructions conditionnelles.</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l1 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Instructions conditionnelles structurées.</span></span><span style=\"font-size:10.5pt; font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"vertical-align:baseline\"><strong style=\"box-sizing: border-box; outline: 0px\"><span style=\"box-sizing: border-box;outline: 0px\"><span style=\"font-size:10.5pt;font-family:"Arial",sans-serif;color:#545342; border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm;padding:0cm\">DEBOGUER SES MACROS</span></span></strong><span style=\"font-size:10.5pt;font-family: Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l5 level1 lfo5;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Utiliser le déroulement pas à pas pour trouver un problème dans son programme.</span></span><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"vertical-align:baseline\"><strong style=\"box-sizing: border-box; outline: 0px\"><span style=\"box-sizing: border-box;outline: 0px\"><span style=\"font-size:10.5pt;font-family:"Arial",sans-serif;color:#545342; border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm;padding:0cm\">MANIPULATION DE DIVERSES FONCTIONS ET INSTRUCTIONS</span></span></strong><span style=\"font-size:10.5pt;font-family:Roboto;color:#8C8C8C\"><o:p></o:p></span></p> <p class=\"type-3\" style=\"margin:0cm;margin-bottom:.0001pt;text-indent:-18.0pt; mso-list:l4 level1 lfo6;tab-stops:list 36.0pt;vertical-align:baseline\"><!--[if !supportLists]--><span style=\"font-size:10.0pt;mso-bidi-font-size:10.5pt;font-family:Symbol; mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;color:#8C8C8C\">·<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";\"> </span></span><!--[endif]--><span style=\"font-size:9.0pt;font-family:"Arial",sans-serif; color:#545342;border:none windowtext 1.0pt;mso-border-alt:none windowtext 0cm; padding:0cm\"><span style=\"box-sizing: border-box;outline: 0px\">Mise en forme, mise en page</span></span><span style=\"font-size:10.5pt;font-family:Roboto; color:#8C8C8C\"><o:p></o:p></span></p> </span></span></span></span></span></span></span></span></span></p> <p> </p>"
tp
=>
""
plan
=>
""
cout
=>
400
cout2
=>
0
datec
=>
"2018-11-13"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
3
=> stdClass Object (
id_formation
=>
41
code
=>
"BUR"
titre
=>
"EXCEL Initiation"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
1
heure
=>
7
prerequis
=>
"Connaître l'environnement Windows."
public
=>
"TOUT PUBLIC"
moyentec
=>
""
objectif
=>
"Maîtriser les fonctions de base afin de créer des tableaux avec des formules de calcul."
programme
=>
"<p class="pa0" style="margin: 0cm; margin-bottom: .0001pt; background: white;"><span class="a6"><strong><span style="font-size: 9.0pt;">Se rep&eacute;rer dans Excel</span></strong></span></p> <ul> <li><span class="a6"><span style="font-size: 9.0pt;">Les classeurs, feuilles de calculs et cellules</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Utiliser les barres d&rsquo;outils</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Utiliser l&rsquo;aide</span></span><strong><span style="font-size: 9.0pt;">&nbsp;</span></strong></li> </ul> <p class="pa0" style="margin: 0cm; margin-bottom: .0001pt; background: white;"><span class="a6"><strong><span style="font-size: 9.0pt;">Concevoir des tableaux</span></strong></span></p> <ul> <li><span class="a6"><span style="font-size: 9.0pt;">Analyser les concepts de base d&rsquo;un tableur</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Mettre en place des formules et les automatiser</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">G&eacute;rer les cellules : saisie, &eacute;criture et recopie de formules,</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">modification</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Distinguer les modes d&rsquo;adressages : absolu, relatif</span></span><strong><span style="font-size: 9.0pt;">&nbsp;</span></strong></li> </ul> <p class="pa0" style="margin: 0cm; margin-bottom: .0001pt; background: white;"><span class="a6"><strong><span style="font-size: 9.0pt;">Pr&eacute;senter les tableaux et les imprimer</span></strong></span></p> <ul> <li><span class="a6"><span style="font-size: 9.0pt;">Formater les cellules : pr&eacute;senter les chiffres, le texte, les titres</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Appliquer une mise en forme automatique</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Ins&eacute;rer, supprimer des lignes ou colonnes, d&eacute;placer des champs</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Ins&eacute;rer des commentaires</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Effectuer la mise en page</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">D&eacute;finir une zone d&rsquo;impression</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Imprimer tout ou partie avec titre et pagination</span></span><strong><span style="font-size: 9.0pt;">&nbsp;</span></strong></li> </ul> <p class="pa0" style="margin: 0cm; margin-bottom: .0001pt; background: white;"><span class="a6"><strong><span style="font-size: 9.0pt;">G&eacute;rer ses classeurs</span></strong></span></p> <ul> <li><span class="a6"><span style="font-size: 9.0pt;">Enregistrer et ouvrir un fichier</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Organiser ses tableaux dans les classeurs</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Ins&eacute;rer, supprimer, d&eacute;placer une feuille &agrave; l&rsquo;int&eacute;rieur d&rsquo;un classeur</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Modifier plusieurs feuilles simultan&eacute;ment : groupe de travail</span></span><strong><span style="font-size: 9.0pt;">&nbsp;</span></strong></li> </ul> <p class="pa0" style="margin: 0cm; margin-bottom: .0001pt; background: white;"><span class="a6"><strong><span style="font-size: 9.0pt;">Automatiser les calculs en utilisant les fonctions d&rsquo;Excel</span></strong></span></p> <ul> <li><span class="a6"><span style="font-size: 9.0pt;">Calculer des pourcentages, &eacute;tablir des ratios</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Effectuer des statistiques : SOMME() et MOYENNE()</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Appliquer des conditions : SI()</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Utiliser les fonctions date : MAINTENANT() et AUJOURDHUI()</span></span></li> <li><span class="a6"><span style="font-size: 9.0pt;">Consolider plusieurs feuilles d&rsquo;un classeur avec la fonction SOMME()</span></span>&nbsp;</li> </ul> <p class="Pa0" style="margin: 0cm 0cm 0pt;"><strong> </strong></p> <p class="pa0" style="margin: 0cm; margin-bottom: .0001pt; background: white;">&nbsp;</p> <div> <p class="MsoNormal">&nbsp;</p> </div> <p><strong> </strong></p> <p>&nbsp;</p><script src="//cdn.flmngr.com/widgets.js?apiKey=3wCDP2Uh" data-ts="1737561391290"></script>"
tp
=>
""
plan
=>
"CPF (TOSA DIGITAL)"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-28"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img41.jpg"
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
4
=> stdClass Object (
id_formation
=>
42
code
=>
"BUR"
titre
=>
"EXCEL Perfectionnement"
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
1
heure
=>
7
prerequis
=>
"Avoir suivi la formation Excel Initiation."
public
=>
""
moyentec
=>
""
objectif
=>
"Maîtriser les fonctions avancées d'Excel."
programme
=>
"<p class=\"MsoNormal\" style=\"margin-bottom:0cm;margin-bottom:.0001pt;line-height: 12.05pt;background:white\"><b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer une base de données</span></b><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Saisir et trier une base de données</span><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Définir un ou plusieurs filtres</span><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Utiliser les fonctions bases de données (BDSOMME, BDMOYENNE...)</span><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Calculer des sous-totaux<b> </b></span><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> </ul> <p class=\"MsoNormal\" style=\"margin-bottom:0cm;margin-bottom:.0001pt;line-height: 12.05pt;background:white\"><b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Utiliser les tableaux croisés dynamiques</span></b><span style=\"font-size: 12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer et modifier un tableau croisé dynamique</span><span style=\"font-size: 12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Représenter graphiquement un tableau croisé dynamique et l’analyser</span><span style=\"font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family: "Times New Roman";color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Générer et modifier la consolidation d’un tableau<b> </b></span><span style=\"font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family: "Times New Roman";color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> </ul> <p class=\"MsoNormal\" style=\"margin-bottom:0cm;margin-bottom:.0001pt;line-height: 12.05pt;background:white\"><b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Approfondir l’utilisation des formules de calcul</span></b><span style=\"font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family: "Times New Roman";color:black;mso-fareast-language:FR\"><o:p></o:p></span></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Les notions de référence relative, absolue et mixte</span><span style=\"font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family: "Times New Roman";color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Les fonctions logiques (statistiques, conditions, etc.)</span><span style=\"font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family: "Times New Roman";color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Les fonctions date, heure, et texte</span><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Les fonctions de recherche RECHERCHEH() et RECHERCHE V()</span><span style=\"font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-font-family: "Times New Roman";color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">La fonction «valeur cible»<b> </b></span><span style=\"font-size:12.0pt; font-family:"Times New Roman","serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></li> </ul> <p class=\"MsoNormal\" style=\"margin-bottom:0cm;margin-bottom:.0001pt;line-height: 12.05pt;background:white\"><b style=\"line-height: 12.05pt; \"><span style=\"font-size: 9pt; font-family: Arial, sans-serif; \">Protéger ses classeurs et feuilles de calcul</span></b></p>"
tp
=>
""
plan
=>
"CPF"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-28"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img42.jpg"
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
5
=> stdClass Object (
id_formation
=>
183
code
=>
"MJ1"
titre
=>
""
type
=>
16
nb_places
=>
8
niveau
=>
10
duree
=>
1
heure
=>
7
prerequis
=>
"Aucun pre-requis"
public
=>
""
moyentec
=>
""
objectif
=>
"texte important pour la recherche"
programme
=>
"<h3 style="margin: 0px 0px 5px; padding: 10px 0px 0px; border: 0px; font-family: source_sans_prosemibold, arial, Verdana, sans-serif; font-weight: normal; outline: 0px; vertical-align: baseline; clear: both; font-size: 2.3em; line-height: 1.2em; color: rgb(86, 86, 86);"><strong><span style="font-family: Arial, Verdana; font-size: 14px; color: rgb(84, 83, 66);">Présentation de la plateforme</span></strong></h3> <ul> <li>Création des comptes pour les stagiaires</li> <li>Présentation des options</li> </ul> <h3><span style="font-family: Arial, Verdana; font-size: 14px; color: rgb(84, 83, 66);">Création de liste de contact</span></h3> <ul> <li>Principe des listes</li> <li>Création d’une liste</li> <li>Importation de fichiers de contacts</li> </ul> <h3><span style="font-family: Arial, Verdana; font-size: 14px; color: rgb(84, 83, 66);">Création d’une campagne</span></h3> <ul> <li>Mis en place d’une campagne</li> <li>Création d’une lettre d’information à partir de l’outil Mailjet</li> <li>Création d’un modèle de lettre</li> <li>Utilisation d’un modèle existant</li> <li>Création d’une lettre à partir du code HTML</li> <li>Reprendre une lettre à partir d’une campagne précédente</li> </ul> <h3><span style="font-family: Arial, Verdana; font-size: 14px; color: rgb(84, 83, 66);">Suivi des statistiques d’une campagne</span></h3> <ul> <li>Les statistiques générale</li> <li>Les statistiques d’une campagne</li> <li>Les statistiques sur un contact</li> </ul> <h3><span style="font-family: Arial, Verdana; font-size: 14px; color: rgb(84, 83, 66);">Quelques options</span></h3> <ul> <li>Créer et insérer un widget d’abonnement sur son site web</li> <li>Les extensions pour les plateformes de sites les plus connues (WordPress, Spip…)</li> </ul>"
tp
=>
""
plan
=>
""
cout
=>
500
cout2
=>
0
datec
=>
"2014-12-08"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
10
libelle
=>
"Cycle 1"
couleur
=>
"#000000"
niveau_libelle
=>
"Cycle 1"
)
6
=> stdClass Object (
id_formation
=>
220
code
=>
"INI_inf"
titre
=>
""
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
3
heure
=>
21
prerequis
=>
"Aucun pré requis"
public
=>
""
moyentec
=>
"Ateliers, démonstrations, pratique"
objectif
=>
""
programme
=>
"<div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Introduction au système informatique </span></div> <ul> <li>Comprendre les composants d\'un ordinateur, La carte mère, Le processeur, Le disque dur, La mémoire vive, La carte réseau, La carte graphique, </li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Effectuer ses premiers pas sur Windows</span></div> <ul> <li>Les versions de Windows, Comment se présente Windows, Le bureau, Le menu Démarrer, Le répertoire utilisateur, Le poste de travail, Le menu contextuel (clic droit)</li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\"> Comprendre l\'organisation du système</span></div> <ul> <li><span style=\"font-family: Arial, Verdana; font-size: 12px; color: rgb(84, 83, 66);\">Qu\'est que l\'explorateur Windows ?, Qu\'est-ce qu\'un fichier ?, Qu\'est-ce qu\'une extension ?, Qu\'est-ce qu\'un dossier? Qu\'est-ce qu\'un logiciel ?, L\'arborescence de fichiers</span></li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Se servir de l\'explorateur Windows</span></div> <ul> <li>Ouvrir une fenêtre, Réduire/Aggrandir la fenêtre, Déplacer la fenêtre, Mettre deux fenêtre côte à côte</li> </ul> <div> <span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Exploiter les fichiers et dossiers</span></div> <ul> <li>Créer des fichiers de texte simple, Les organiser avec des dossiers, Renommer un fichier/dossier, Déplacer ou dupliquer un fichier existant, Supprimer un fichier,</li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\"> Utiliser les logiciels courants sur Windows</span></div> <ul> <li>Anti-virus, WordPad, Paint, Calculatrice, Lecteur Windows Media, Messagerie et navigateur Internet, Logiciels payants</li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\"> Connaître les fonctions utiles sous Windows</span></div> <ul> <li>Effectuer une recherche (fichier, logiciel...), Créer des raccourcis, Utiliser une clé USB, Utiliser le gestionnaire des tâches ,Compresser un fichier</li> </ul> <div> <span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Configurer Windows</span></div> <ul> <li>Accéder au panneau de configuration, Changer l\'apparence (arrière-plan, écran de veille), Gérer les utilisateurs de l\'ordinateur, Activer un contrôle parental, Désintaller un logiciel, Installer une imprimante, Paramétrer les mises à jour de Windows</li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Effectuer ses premiers pas avec le Web</span></div> <ul> <li>Qu\'est-ce que le Web ?, Qu\'est-ce qu\'un navigateur Web ?, Qu\'est-ce qu\'une adresse Web (URL) ?, Qu\'est-ce qu\'un lien hypertexte ?, Présentation d\'un petit site Web</li> </ul> <div> <span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\">Connaître son navigateur Web</span></div> <ul> <li>La barre d\'adresse , Le champ de recherche , Les boutons standards (accueil, actualiser) , Les favoris , L\'historique</li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\"> Utiliser les outils de recherche</span></div> <ul> <li>Présentation d\'un moteur de recherche, Faire une recherche sur internet, Les résultats de recherche, Recherche avancée</li> </ul> <div><span style=\"font-family: Arial, Verdana; font-size: 19px; color: rgb(84, 83, 66);\"> Utiliser la messagerie</span></div> <ul> <li>Qu\'est-ce qu\'une adresse électronique ?, Présentation d\'une messagerie, Ecrire un mail, Lire un message, Répondre à un mail, Supprimer un mail, Classer ses mails, Gestion des spams</li> </ul> <div> <p><font color=\"#545342\" face=\"Arial, Verdana\"><span style=\"font-size: 19px;\">Découverte de WORD et EXCEL</span></font></p> <ul> <li>Création de courrier, mise en pages, </li> <li>Création de tableaux, de calculs simples, de mises en pages de tableaux.</li> </ul> <p><span style=\"color: rgb(84, 83, 66); font-family: Arial, Verdana; font-size: 19px;\">Découvrir Internet par soi même</span></p> </div> <ul> <li>Faire une recherche pour trouver la météo, Faire une recherche d\'actualité, Les portails d\'informations, Encyclopédie en ligne, Présentation des forums de discussions, Les compte clients (commander en ligne, gérer ses comptes, etc...)</li> </ul>"
tp
=>
""
plan
=>
""
cout
=>
690
cout2
=>
0
datec
=>
"2022-01-25"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
7
=> stdClass Object (
id_formation
=>
179
code
=>
"IA4515"
titre
=>
"L'IA au service des equipes administratives et commerciales"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
4
heure
=>
7
prerequis
=>
"Pas de pré-requis"
public
=>
"Assistants administratifs Assistants commerciaux Secrétaires Chargés de clientèle ADV (Administration des ventes) Responsables commerciaux Managers d'équipes administratives et commerciales"
moyentec
=>
"Apports théoriques, démonstrations, études de cas, ateliers pratiques et travaux appliqués aux processus de l'entreprise."
objectif
=>
"À l'issue de la formation, les participants seront capables de : Comprendre les opportunités offertes par l'IA dans leur métier. Identifier les tâches à faible valeur ajoutée pouvant être assistées ou automatisées. Structurer des processus de travail intégrant l'IA. Concevoir des modèles et procédures réutilisables. Utiliser l'IA pour améliorer la qualité, la rapidité et la cohérence des productions administratives et commerciales. Définir des règles d'utilisation adaptées à leur organisation."
programme
=>
"<h3 data-section-id="1fgqilt">1. Comprendre l'IA et ses usages professionnels</h3> <ul> <li data-section-id="1rrxqr8">Principes de fonctionnement des outils d'IA générative</li> <li data-section-id="axbepn">Opportunités, limites et bonnes pratiques</li> <li data-section-id="k0jssz">Confidentialité et sécurité des données</li> </ul> <h3 data-section-id="1xlwvv4">2. Identifier les gains de productivité</h3> <ul> <li data-section-id="3pcaiw">Analyse des tâches administratives et commerciales</li> <li data-section-id="13z80zr">Repérage des activités répétitives et chronophages</li> <li data-section-id="141cznf">Sélection des cas d'usage à forte valeur ajoutée</li> </ul> <h3 data-section-id="18ksd2q">3. Intégrer l'IA dans les processus métiers</h3> <ul> <li data-section-id="1skesed">Rédaction et gestion documentaire</li> <li data-section-id="3sme6k">Traitement des demandes clients</li> <li data-section-id="rdmibk">Préparation et suivi commercial</li> <li data-section-id="96itd5">Production de synthèses, comptes-rendus et reporting</li> </ul> <h3 data-section-id="sczca2">4. Structurer et standardiser les pratiques</h3> <ul> <li data-section-id="1lqovt0">Création de modèles réutilisables</li> <li data-section-id="7362fa">Construction d'une bibliothèque de prompts métier</li> <li data-section-id="c5hsso">Harmonisation des réponses et documents</li> </ul> <h3 data-section-id="fb37i4">5. Concevoir des workflows assistés par l'IA</h3> <ul> <li data-section-id="uwjept">Optimisation des flux de travail</li> <li data-section-id="30xndx">Automatisation des tâches récurrentes</li> <li data-section-id="19dyap1">Contrôle qualité et validation humaine</li> </ul> <h3 data-section-id="t38zm7">6. Élaborer une feuille de route de déploiement</h3> <ul> <li data-section-id="188hbgm">Priorisation des actions</li> <li data-section-id="rb7met">Organisation interne</li> <li data-section-id="t1fshl">Plan d'amélioration continue</li> </ul><script src="https://cdn.flmngr.com/widgets.js?apiKey=3wCDP2Uh" data-ts="1781865480976"></script>"
tp
=>
"Exercices pratiques, mises en situation et validation des acquis en fin de formation. "
plan
=>
""
cout
=>
980
cout2
=>
9
datec
=>
"2026-06-16"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
8
=> stdClass Object (
id_formation
=>
210
code
=>
"inf1"
titre
=>
"Maintenance Informatique"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
3
heure
=>
7
prerequis
=>
"Connaitre un minimum l\'informatique"
public
=>
"tout public"
moyentec
=>
""
objectif
=>
"Apprendre le fonctionnement et la structure du micro-ordinateur. Savoir diagnostiquer les principales pannes et dépanner les ordinateurs PC."
programme
=>
"<ul> <li>STRUCTURE ET COMPOSANTS DE L\'ORDINATEUR<br /> </li> <li>SAVOIR ASSEMBLER UN PC<br /> </li> <li>SYSTEME D\' EXPLOITATION<br /> </li> <li>LES PANNES DE MATERIELS (PC ET PORTABLES)<br /> </li> <li>LES PANNES DE LOGICIELS<br /> </li> <li>LES PERIPHERIQUES<br /> </li> <li>VIRUS ET ANTIVIRUS<br /> </li> <li>DEPANNER A DISTANCE<br /> </li> <li>RESEAUX INFORMATIQUES<br /> </li> <li>RESEAU ET SYSTEME D\'EXPLOITATION<br /> </li> <li>INSTALLATION D\'UN RESEAU INFORMATIQUE<br /> </li> <li>RELATION CLIENTS/SERVEUR, MISE EN PLACE DU SERVEUR ET POSTES CLIENTS<br /> </li> <li>SECURITE RESEAU<br /> </li> <li>SAUVEGARDES DE DONNEES (LOCALES OU CENTRALISEES, AUTOMATIQUES, LES SUPPORTS ET LES LOGICIELS)<br /> </li> <li>PARTAGER DES RESSOURCES</li> </ul> <p> </p>"
tp
=>
""
plan
=>
""
cout
=>
350
cout2
=>
0
datec
=>
"2018-08-27"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
9
=> stdClass Object (
id_formation
=>
166
code
=>
"EX_2010"
titre
=>
""
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
1
heure
=>
7
prerequis
=>
"Utilisation d\'excel 2003"
public
=>
"Tous"
moyentec
=>
"Théorie et pratique"
objectif
=>
""
programme
=>
"<h3 class=\" formation b_r___t_q____t_p__\" style=\"margin: 0px 0px 10px; padding: 0px 0px 3px 3px; border-width: 0px 0px 1px; outline: 0px; font-size: 13px; background-color: transparent; font-weight: normal; line-height: 15px; \"><strong style=\"margin: 0px; padding: 0px; border-width: 0px; outline: 0px; background-color: transparent; \">Mise à jour d\'Excel 2010</strong></h3> <ul> <li>Mise à jour pour les tableaux croisée dynamique</li> <li>Découvrir le ruban</li> <li>Faciliter l\'analyse des données grâce à la mise en forme conditionnelle</li> <li>Mettre en page un tableau plus rapidement grâce à l\'onglet "Mise en page"</li> <li>Appliquer un filtre personnalisé avec des possibilités de rechercher sur des critères</li> <li>Découvrir les nouveaux paramètres de mise en forme des éléments graphiques</li> <li>Création de mini graphiques (les graphiques Sparkline)</li> </ul>"
tp
=>
""
plan
=>
"CPF"
cout
=>
250
cout2
=>
0
datec
=>
"2012-06-07"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
10
=> stdClass Object (
id_formation
=>
128
code
=>
"off2010"
titre
=>
"Office 2013 / 2016 perfectionnement"
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
2
heure
=>
7
prerequis
=>
"Cette formation ne nécessite pas de pré-requis"
public
=>
"Tout utilisateur d'Office 2003 ou 2007"
moyentec
=>
""
objectif
=>
""
programme
=>
"<p> <strong style="background-color: transparent; font-size: 13px; margin: 0px; padding: 0px; border-width: 0px; border-style: initial; border-color: initial; outline: 0px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Word </strong></p> <ul> <li>Personnaliser la barre d'état</li> <li>Modifier rapidement le taux d'affichage du document</li> <li>Accéder à un nouvel affichage : volet de navigation</li> <li>Gagner du temps dans la mise en forme en appliquant un style prédéfini</li> <li>Utiliser le QuickPart (saisie de texte répétitif ou l'insertion d'éléments)</li> <li>Convertir un fichier au format PDF</li> </ul> <h3 class=" formation b_r___t_q____t_p__" style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 3px; padding-left: 3px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 13px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: normal; line-height: 15px; color: rgb(0, 0, 0); border-bottom-style: solid; border-bottom-color: rgb(106, 153, 9); background-position: initial initial; background-repeat: initial initial; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 13px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; background-position: initial initial; background-repeat: initial initial; ">Excel</strong></h3> <ul> <li>Faciliter la saisie des formules en modifiant la hauteur ou la largeur de la barre de formule</li> <li>Nommer une plage de cellules et l'insérer dans une formule à partir d'une liste déroulante</li> <li>Gagner du temps dans la mise en forme des cellules en appliquant un style de cellule</li> <li>Faciliter l'analyse des données grâce à la mise en forme conditionnelle</li> <li>Mettre en page un tableau plus rapidement grâce à l'onglet "Mise en page"</li> <li>Trier selon plusieurs critères</li> <li>Trier par ordre alphabétique, par couleur de police ou par couleur de remplissage</li> <li>Appliquer un filtre automatique avec des possibilités de rechercher sur des critères</li> <li>Découvrir les nouveaux paramètres de mise en forme des éléments graphiques</li> <li>Création de mini graphiques (les graphiques Sparkline)</li> </ul> <h3 class=" formation b_r___t_q____t_p__" style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 3px; padding-left: 3px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 13px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: normal; line-height: 15px; color: rgb(0, 0, 0); border-bottom-style: solid; border-bottom-color: rgb(106, 153, 9); background-position: initial initial; background-repeat: initial initial; "><strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 13px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; background-position: initial initial; background-repeat: initial initial; ">PowerPoint</strong></h3> <ul> <li>Utiliser un nouveau mode d'affichage (affichage/lecture)</li> <li>Créer un mode de classement par thèmes avec des sections</li> <li>Appliquer un masque pour mettre en forme toutes les diapositives</li> <li>Utiliser des effets d'animation (transition, animation sur les objets, option d'effets)</li> <li>Poser des effets artistiques sur des images</li> <li>Créer des graphiques dans PowerPoint</li> <li>Faire des schémas grâce à SmartArt</li> <li>Incorporer une vidéo</li> </ul> <h3 class=" formation b_r___t_q____t_p__" style="margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 3px; padding-left: 3px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 13px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: normal; line-height: 15px; color: rgb(0, 0, 0); border-bottom-style: solid; border-bottom-color: rgb(106, 153, 9); background-position: initial initial; background-repeat: initial initial; "> </h3>"
tp
=>
""
plan
=>
""
cout
=>
350
cout2
=>
0
datec
=>
"2011-01-24"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img128.jpg"
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
11
=> stdClass Object (
id_formation
=>
48
code
=>
"BUR"
titre
=>
"OPEN OFFICE"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
3
heure
=>
7
prerequis
=>
"Connaitre l'environnement Windows"
public
=>
""
moyentec
=>
""
objectif
=>
""
programme
=>
"<p class=\"MsoNormal\"><strong>Prendre ses repères dans OpenOffice</strong><o:p></o:p></p> <ul> <li>S’approprier l’environnement de travail<o:p></o:p></li> <li>Configurer barres d’outils et raccourcis clavier</li> </ul> <p class=\"MsoNormal\"><strong>Maîtriser le traitement de texte Writer</strong><o:p></o:p></p> <ul> <li>Saisir, sélectionner et mettre en forme du texte<o:p></o:p></li> <li>Appliquer et modifier un style<o:p></o:p></li> <li>Créer et utiliser des modèles. Hiérarchiser les titres d’un document<o:p></o:p></li> <li>Numéroter automatiquement le plan<o:p></o:p></li> <li>Insérer un sommaire, un index<o:p></o:p></li> <li>Intégrer des tableaux, des images<o:p></o:p></li> <li>Personnaliser les puces et numéros. Créer et utiliser des AutoTexte<o:p></o:p></li> <li>Mettre au point un mailing avec l’assistant<o:p></o:p> <o:p></o:p></li> </ul> <p class=\"MsoNormal\"><strong>Maîtriser le tableur Calc</strong><o:p></o:p></p> <ul> <li>Saisir des formules simples et imbriquées<o:p></o:p></li> <li>Utiliser l’assistant de création de formules<o:p></o:p></li> <li>Créer des listes personnalisées<o:p></o:p></li> <li>Travailler simultanément sur plusieurs onglets<o:p></o:p></li> <li>Utiliser des styles de cellules, appliquer un format conditionnel<o:p></o:p></li> <li>Contrôler la validité des données<o:p></o:p></li> <li>Activer la protection d’une feuille, d’un classeur<o:p></o:p></li> <li>Exploiter une base de données : tris, filtres, sous-totaux<o:p></o:p></li> <li>Consolider des données<o:p></o:p></li> <li>Effectuer des analyses croisées avec le pilote de données<o:p></o:p></li> <li>Illustrer les données. Mettre en page pour l’impression</li> </ul> <p class=\"MsoNormal\"><strong>Maîtriser le logiciel de présentation Impress</strong><o:p></o:p></p> <ul> <li>Travailler le plan de la présentation<o:p></o:p></li> <li>Définir la ligne graphique : pages maîtresses et masques<o:p></o:p></li> <li>Insérer un tableau ou un diagramme Calc<o:p></o:p></li> <li>Élaborer des schémas. Appliquer des effets d’animation et de transition<o:p></o:p></li> <li>Préparer la documentation en mode Notes ou Prospectus<o:p></o:p></li> <li>Exécuter le diaporama<o:p></o:p></li> </ul> <p class=\"MsoNormal\"><strong>Liaisons avec d’autres logiciels</strong><o:p></o:p></p> <ul> <li>Importer ou exporter au format Office. Exporter vers le format PDF<o:p></o:p></li> </ul> <p class=\"MsoNormal\"><strong>Modules «Annexes»</strong></p> <p class=\"MsoNormal\"><o:p></o:p></p> <ul> <li>Dessiner avec Draw<o:p></o:p></li> <li>Editer des pages HTML avec le Web.<o:p></o:p></li> <li>Créer des formules avec Math.<o:p></o:p></li> </ul> <p class=\"MsoNormal\"> <o:p></o:p></p> <p class=\"MsoNormal\"><o:p> </o:p></p>"
tp
=>
""
plan
=>
"CPF"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-30"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
12
=> stdClass Object (
id_formation
=>
173
code
=>
"off2012"
titre
=>
""
type
=>
16
nb_places
=>
8
niveau
=>
10
duree
=>
1
heure
=>
7
prerequis
=>
"Connaissance d\'une version précédente d\'Office"
public
=>
"utilisateurs d\'Office 2010"
moyentec
=>
""
objectif
=>
"s\'approprier la nouvelle interface Office 2010 et découvrir les nouveautés de Word, Excel, PowerPoint"
programme
=>
"<p><strong>Se repérer dans la nouvelle interface</strong></p> <ul> <li>Le bouton Office</li> <li>La barre d’outils d’accès rapide</li> <li>Le ruban : organisation, lanceur de boîtes de dialogue</li> </ul> <p><strong>Gérer ses documents</strong></p> <ul> <li>Création à partir d’un modèle</li> <li>Gestion des affichages</li> <li>Enregistrement en version antérieure</li> <li>Récupération des anciens documents et mode compatibilité</li> <li>Enregistrement au format PDF</li> <li>Notion de version finale</li> <li>Impression</li> </ul> <p><strong>Word 2010</strong></p> <ul> <li>Mettre en forme les documents : <ul> <li>principales modifications sur les mises en page</li> <li>galeries de styles prédéfinis</li> </ul> </li> <li>Mettre en forme les tableaux : <ul> <li>principales modifications dans la création d’un tableau</li> <li>options de style de tableau</li> <li>styles de tableau</li> </ul> </li> <li>Fonctions de correction et de traduction</li> </ul> <p><strong>Excel 2010 : </strong></p> <ul> <li>Mettre en forme les documents : <ul> <li>principales modifications sur les mises en forme</li> <li>appliquer un thème, un style de cellule</li> <li>utiliser les mises en forme conditionnelles</li> <li>gérer les en-têtes et pieds de page</li> </ul> </li> <li>Rédiger une formule de calcul : <ul> <li>barre de formule redimensionnable</li> <li>saisie semi-automatique des fonctions</li> </ul> </li> <li>Traiter les tableaux de données : nouvelles options de tri et de filtrage</li> <li>Créer un graphique simple : nouvelles présentations des graphiques </li> </ul> <p><strong>Powerpoint 2010 :</strong></p> <ul> <li>Mettre en forme : <ul> <li>thèmes</li> <li>dégradés et arrières plan</li> <li>nouveaux outils</li> </ul> </li> </ul>"
tp
=>
""
plan
=>
""
cout
=>
550
cout2
=>
0
datec
=>
"2012-07-24"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img173.jpg"
elus
=>
0
id_niveau_formation
=>
10
libelle
=>
"Cycle 1"
couleur
=>
"#000000"
niveau_libelle
=>
"Cycle 1"
)
13
=> stdClass Object (
id_formation
=>
218
code
=>
"EXCELPOW"
titre
=>
"PowerPivot Excel"
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
1
heure
=>
7
prerequis
=>
"Bon niveau Excel"
public
=>
""
moyentec
=>
"Traveaux pratiques"
objectif
=>
"Utiliser Power pivot en milieu professionnel"
programme
=>
"<div><strong>Présentation de PowerPivot</strong></div> <div> </div> <div>Accéder au module complémentaire PowerPivot</div> <div>Naviguer dans l\'interface</div> <div>Charger une seule source de données</div> <div>Créer un tableau de bord</div> <div><strong><br /> </strong></div> <div><strong>Utiliser PowerPivot dans le cadre del\'informatique décisionnelle</strong></div> <div> </div> <div>Extraire des informations des données avec PowerPivot</div> <div>Découvrir les problèmes d\'interprétation des données</div> <div> </div> <div>Conception du modèle de données avec PowerPivot</div> <div>Affichage des données consolidées</div> <div> </div> <div>Fusionner les données provenant de sources structurées et non structurées en un modèle de données</div> <div>Créer des relations entre les différentes sources de données avec l\'outil Relations et l\'affichage Diagramme</div> <div> </div> <div><strong>Créer une relation entre les différents ensemblesde données</strong></div> <div> </div> <div>Limites du copier-coller, afficher et connecter des données avec l\'Explorateur de données</div> <div>Créer un ensemble de données provenant de différentes sources avec les mêmes noms de champ</div> <div> </div> <div><strong>Présentation des informations dans des tableaux de bord</strong></div> <div>Exploration et analyse des données</div> <div> </div> <div>Utiliser une hiérarchie pour explorer les différents niveaux de détail des données</div> <div>Identifier les motifs et les tendances des données PowerPivot</div> <div>Classer les données en fonction de leur zone géographique</div> <div>Gérer les données avec les perspectives</div> <div> </div> <div>Concevoir des tableaux de bord efficaces</div> <div> </div> <div>Générer des rapports avec les tableaux croisés dynamiques et les segments, documenter les structures avec les diagrammes hiérarchiques, présenter les tendances avec les graphiques croisés dynamiques</div>"
tp
=>
""
plan
=>
""
cout
=>
850
cout2
=>
0
datec
=>
"2020-10-26"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
14
=> stdClass Object (
id_formation
=>
169
code
=>
"POW"
titre
=>
"Powerpoint et Diaporama"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
1
heure
=>
7
prerequis
=>
"Aucun"
public
=>
"Tous"
moyentec
=>
"Créer un support visuel pour animer une réunion Réaliser un album photos et le présenter avec des sons et des animation"
objectif
=>
"Créer rapidement des diaporamas clairs, attractifs et animés"
programme
=>
"<p><strong>INTRODUCTION&nbsp;</strong></p> <ul> <li>Que peut-on faire avec un diaporama ?</li> <li>Se familiariser avec la pr&eacute;sentation du logiciel</li> </ul> <p><strong>PRISE EN MAIN</strong></p> <ul> <li><strong>Ouvrir une nouvelle pr&eacute;sentation</strong></li> <li><strong>Enregistrer et fermer une pr&eacute;sentation existante</strong></li> <li><strong>Ins&eacute;rer, supprimer, d&eacute;placer ou dupliquer une diapositive</strong></li> </ul> <p><strong>CR&Eacute;ATION DE DIAPOSITIVES</strong></p> <ul> <li>Ins&eacute;rer du texte dans les zones de texte</li> <li>Mette des caract&egrave;res (police, taille, couleur, etc.) et alignement</li> <li>Mettre de l'arri&egrave;re-plan : utiliser des mod&egrave;les ou le masque des diapositives pour une mise en forme personnalis&eacute;e</li> <li>Ins&eacute;rer et g&eacute;rer les objets : images, graphiques, sons...</li> </ul> <p><strong>DYNAMISER LA PR&Eacute;SENTATION</strong></p> <ul> <li>Utiliser les diff&eacute;rentes possibilit&eacute;s d'apparition des diapositives pour les transitions, par le haut, en damier, en rotation, etc.</li> <li>Ajouter des animations sur les diff&eacute;rents &eacute;l&eacute;ments de la diapositive, sons, effets d'ouverture, etc.</li> </ul> <p><strong>LES MODES DE PR&Eacute;SENTATION</strong></p> <ul> <li>Normal : pour la cr&eacute;ation des diapositives</li> <li>Trieuse : facilite l'ajout, la suppression ou le d&eacute;placement de diapositives</li> <li>Diaporama : pour visualiser la pr&eacute;sentation</li> </ul> <p><strong>L'IMPRESSION</strong></p> <ul> <li>Bien choisir sa mise en page en fonction de l'utilisation attendue : diapositives, documents, pages de commentaires, mode plan</li> </ul> <p>&nbsp;</p><script src="//cdn.flmngr.com/widgets.js?apiKey=3wCDP2Uh" data-ts="1737561796802"></script>"
tp
=>
""
plan
=>
"CPF (TOSA DIGITAL)"
cout
=>
250
cout2
=>
0
datec
=>
"2012-06-13"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
15
=> stdClass Object (
id_formation
=>
47
code
=>
""
titre
=>
""
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
1
heure
=>
7
prerequis
=>
"Connaître l'environnement Windows."
public
=>
""
moyentec
=>
""
objectif
=>
""
programme
=>
"<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><b><span style=\"font-size: 10pt; color: black; font-family: Arial\">Elements de base<o:p></o:p></span></b></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 10pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Utilisation des assistants</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Utilisation des outils d’automatisation</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Générer le sommaire de la présentation</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Modifier le texte</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">L’assistant style de diapositive</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Les modèles de diapositives prédéfinis</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Les différents modes de travail <o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><b><span style=\"font-size: 10pt; color: black; font-family: Arial\">Les mises en page automatiques <o:p></o:p></span></b></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 10pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Insérer des cadres textes</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Graphiques</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Images</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Organigrammes</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Word Art</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Tableaux</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l4 level1 lfo2; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Dessins et formes automatiques <o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><b><span style=\"font-size: 10pt; color: black; font-family: Arial\">Impression d’un diaporama<o:p></o:p></span></b></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 10pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l2 level1 lfo3; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Transparents, diapositives et documents</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l2 level1 lfo3; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Mode commentaire et mode plan <o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><b><span style=\"font-size: 10pt; color: black; font-family: Arial\">Génération du diaporama<o:p></o:p></span></b></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 10pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l5 level1 lfo4; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Créer des transitions et compilations</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l5 level1 lfo4; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Gérer des animations</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l5 level1 lfo4; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Intervenir durant le diaporama</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l5 level1 lfo4; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Visionner le diaporama hors Powerpoint</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l5 level1 lfo4; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Enregistrement aux différents formats <o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><b><span style=\"font-size: 10pt; color: black; font-family: Arial\">Les masques <o:p></o:p></span></b></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 10pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l0 level1 lfo5; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Masques de diapos</span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l0 level1 lfo5; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Masques de titres <o:p></o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><b><span style=\"font-size: 10pt; color: black; font-family: Arial\">Les liens<o:p></o:p></span></b></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: 12.05pt; mso-layout-grid-align: none\"><span style=\"font-size: 10pt; color: black; font-family: Arial\"><o:p> </o:p></span></p> <p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 12.05pt; mso-layout-grid-align: none; mso-list: l3 level1 lfo6; tab-stops: list 18.0pt\"><span style=\"font-size: 9pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol\"><span style=\"mso-list: Ignore\">à<span style=\"font: 7pt "Times New Roman"\"> </span></span></span><span style=\"font-size: 9pt; color: black; font-family: Arial; mso-bidi-font-size: 12.0pt\">Liaison avec Office </span><span style=\"font-size: 9pt; color: black; font-family: Arial\"><o:p></o:p></span></p> <p> </p>"
tp
=>
""
plan
=>
"CPF"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-30"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
1
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
)
16
=> stdClass Object (
id_formation
=>
211
code
=>
"Cloud1"
titre
=>
"Utiliser les Applications et Collaborer (CLOUD)"
type
=>
16
nb_places
=>
8
niveau
=>
10
duree
=>
1
heure
=>
7
prerequis
=>
"Connaissance de la suite Office"
public
=>
"utilisateurs d\'Office 2010, 2013 ou 2016"
moyentec
=>
"Consultant spécialiste de la bureautique / Informatique"
objectif
=>
"découvrir Office 365 se repérer dans l'interface travailler avec les outils collaboratifs"
programme
=>
"<h1>Office 365 – Principes fondamentaux</h1> <ul> <li>Découverte d\'Office 365</li> <li>Vue d\'ensemble des différents composants d\'Office 365</li> <li>Accéder et se connecter à Office 365</li> <li>L’accès au portail, La mobilité</li> <li>Interface du portail</li> </ul> <h1>Office, Office Web App et Office à la demande</h1> <ul> <li>Découverte des solutions</li> <li>Découvrir Word, Excel, Powerpoint et OneNote Web App (Online)</li> <li>Récupérer un document pour l\'utilisation dans Office Online</li> <li>Utiliser Office 2010/2013/2016 avec Office 365</li> </ul> <h1>Outlook et Skype Entreprise</h1> <ul> <li>Découverte d’Outlook Web App : <ul> <li>Messagerie : Gérer ses messages, son absence, rechercher des messages</li> <li>Utilisation d\'Outlook Web App en mode Hors Connexion</li> <li>Calendrier</li> <li>Contacts</li> <li>Organiser ses Tâches</li> </ul> </li> <li>Découverte de Skype Entreprise : <ul> <li>Messagerie Instantanée et courrier électronique</li> <li>Appels audio et vidéo</li> <li>Partage de bureau et d’applications, animation de réunions à distance</li> </ul> </li> </ul> <h1>Travail collaboratif</h1> <ul> <li>Travailler à plusieurs sur un document (Co-autoring Office et Office Web App)</li> <li>Partage de documents dans Office 365</li> <li>Partager ses documents avec OneDrive</li> </ul> <p> </p>"
tp
=>
""
plan
=>
""
cout
=>
350
cout2
=>
0
datec
=>
"2018-10-16"
id_entreprise
=>
0
etat
=>
1
imagette
=>
""
elus
=>
0
id_niveau_formation
=>
10
libelle
=>
"Cycle 1"
couleur
=>
"#000000"
niveau_libelle
=>
"Cycle 1"
)
17
=> stdClass Object (
id_formation
=>
39
code
=>
"BUR"
titre
=>
"WORD Initiation"
type
=>
16
nb_places
=>
8
niveau
=>
1
duree
=>
1
heure
=>
7
prerequis
=>
"Initiation Windows souhaitable"
public
=>
"TOUT PUBLIC"
moyentec
=>
""
objectif
=>
""
programme
=>
"<p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Acquérir les principes de base</span></b><span style="font-size:9.0pt; font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR"><o:p></o:p></span></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Se repérer dans l’écran : barre d’outils, barre d’état, menus, règle<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Les menus<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Bien présenter un document</span></b></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Choisir les polices et leurs attributs : gras, souligné, italique, couleur<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Aérer le document : interligne, retrait<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Encadrer un paragraphe, l’ombrer<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Insérer des listes à puces, listes numérotées<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Insérer une image<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Créer des effets typographiques avec WordArt<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Modifier un document</span></b><span style="font-size:9.0pt;font-family: "Arial","sans-serif";mso-fareast-font-family:"Times New Roman";color:black; mso-fareast-language:FR"><o:p></o:p></span></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Supprimer, déplacer, recopier du texte : glisser/déplacer,<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">couper/coller, copier/coller<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Corriger un texte : le vérificateur d’orthographe,<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">le dictionnaire des synonymes<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Concevoir facilement un courrier</span></b><span style="font-size:9.0pt; font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR"><o:p></o:p></span></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Saisir le texte<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Positionner les références, l’adresse<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Présenter le corps de la lettre<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Mettre en page<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Paginer un document long</span></b></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Définir des sauts de page<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Insérer un numéro de page<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Créer un tableau simple</span></b><span style="font-size:9.0pt;font-family: "Arial","sans-serif";mso-fareast-font-family:"Times New Roman";color:black; mso-fareast-language:FR"><o:p></o:p></span></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Insérer un tableau dans un document<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Ajouter, supprimer des lignes ou des colonnes<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Appliquer des bordures, des trames<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;background:white"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Gérer et organiser ses documents</span></b><span style="font-size:9.0pt; font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR"><o:p></o:p></span></p> <ul> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Nommer et classer ses documents<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Gérer ses fichiers avec l’explorateur<o:p></o:p></span></li> <li><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR">Créer des dossiers, des sous-dossiers<o:p></o:p></span></li> </ul> <p class="MsoNormal"><o:p> </o:p></p>"
tp
=>
""
plan
=>
"CPF"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-28"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img39.jpg"
elus
=>
0
id_niveau_formation
=>
1
libelle
=>
"Initiation"
couleur
=>
"#000000"
niveau_libelle
=>
"Initiation"
)
18
=> stdClass Object (
id_formation
=>
40
code
=>
"BUR"
titre
=>
"WORD Perfectionnement"
type
=>
16
nb_places
=>
8
niveau
=>
2
duree
=>
2
heure
=>
7
prerequis
=>
"Maitrise des notions de base sous Word"
public
=>
"TOUT PUBLIC"
moyentec
=>
""
objectif
=>
"Concevoir rapidement des documents professionnels. Maîtriser la conception des tableaux simples et complexes. Envoyer des mailings."
programme
=>
"<p class=\"MsoNormal\" style=\"mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal;background:white\"><span style=\"font-size:9.0pt;font-family: "Arial","sans-serif";mso-fareast-font-family:"Times New Roman";color:black; mso-fareast-language:FR\"> <b>Automatiser la présentation des documents : styles et modèles</b><o:p></o:p></span></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Repérer les mises en forme répétitives<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer, appliquer, modifier et enchaîner des styles<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer des modèles de documents<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Organiser les styles entre différents modèles<o:p></o:p></span><font class=\"Apple-style-span\" face=\"\'Times New Roman\', serif\" size=\"3\"><br /> </font></li> </ul> <p><b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Envoyer un mailing</span></b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\"><o:p></o:p></span></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Concevoir et gérer un fichier de données<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer la lettre type<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Fusionner les données et la lettre<o:p></o:p></span><font class=\"Apple-style-span\" face=\"\'Times New Roman\', serif\" size=\"3\"><br /> </font></li> </ul> <p><span style=\"font-weight: bold; font-size: 9pt; font-family: Arial, sans-serif; color: black; \">Maîtriser la gestion de documents longs : rapports,</span><span style=\"font-size: 9pt; color: black; \"> </span><b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">mémoires, documentations</span></b></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Insérer des renvois, des notes de bas de page<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Numéroter automatiquement des figures, schémas<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer un index des mots clés<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Gérer des en-têtes et pieds de pages différents<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Afficher des informations relatives au document : nom de l’auteur,<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">taille du fichier,<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">nombre de pages, de caractères...<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Utiliser les signets<o:p></o:p></span><font class=\"Apple-style-span\" face=\"\'Times New Roman\', serif\" size=\"3\"><br /> </font></li> </ul> <p><b><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Construire des mises en page complexes</span></b><span style=\"font-size: 9.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"; color:black;mso-fareast-language:FR\"><o:p></o:p></span></p> <ul> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Présenter le texte en colonnes.<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Mixer les présentations dans un même document : orientations, marges ou<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">colonages différents<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Combiner textes et images dans une même page<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Centrer verticalement un texte dans la page<o:p></o:p></span></li> <li><span style=\"font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black;mso-fareast-language: FR\">Créer des fonds de page et textes en filigrane</span><font class=\"Apple-style-span\" face=\"Arial, sans-serif\"><br /> </font></li> </ul>"
tp
=>
""
plan
=>
"CPF"
cout
=>
350
cout2
=>
0
datec
=>
"2009-07-28"
id_entreprise
=>
0
etat
=>
1
imagette
=>
"form_img40.jpg"
elus
=>
0
id_niveau_formation
=>
2
libelle
=>
"Perfectionnement"
couleur
=>
"#000000"
niveau_libelle
=>
"Perfectionnement"
) ]
BUREAUTIQUE
Warning
: foreach() argument must be of type array|object, null given in
/home/www/client/www/CPT003/www2026/app/Vues/web/HEADER.php
on line
114
Fatal error
: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /home/www/client/www/CPT003/www2026/app/Vues/web/HEADER.php:123 Stack trace: #0 /home/www/client/www/CPT003/www2026/core/Vue.php(93): include_once() #1 /home/www/client/www/CPT003/www2026/app/Controllers/PublicController.php(124): Core\Vue->afficher('accueil-front', Array) #2 [internal function]: App\Controllers\PublicController->index() #3 /home/www/client/www/CPT003/www2026/core/Router.php(341): call_user_func_array(Array, Array) #4 /home/www/client/www/CPT003/www2026/core/Router.php(216): Core\Router->execute_action('App\\Controllers...', 'index', Array, NULL, 'zDlz-2ANbq4vk5M...') #5 /home/www/client/www/CPT003/www2026/public/index.php(157): Core\Router->repartition('/', 'GET') #6 {main} thrown in
/home/www/client/www/CPT003/www2026/app/Vues/web/HEADER.php
on line
123