button.pswp__button{--wpr-bg-30125cb2-5990-4914-90e8-49314db349e3: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/css/photoswipe/default-skin/default-skin.png');}.pswp__button,.pswp__button--arrow--left:before,.pswp__button--arrow--right:before{--wpr-bg-de3ad90c-04c0-40e9-9631-3c3288217602: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/css/photoswipe/default-skin/default-skin.png');}.pswp__preloader--active .pswp__preloader__icn{--wpr-bg-a43f3524-efeb-4bf6-8327-54dd6bf04bda: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/css/photoswipe/default-skin/preloader.gif');}.pswp--svg .pswp__button,.pswp--svg .pswp__button--arrow--left:before,.pswp--svg .pswp__button--arrow--right:before{--wpr-bg-38efad4d-f8ab-4f5d-8d1a-9a9a3455c496: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/css/photoswipe/default-skin/default-skin.svg');}.woocommerce .blockUI.blockOverlay::before{--wpr-bg-2907f315-e00f-4c04-9412-382bd6401034: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/loader.svg');}.woocommerce .loader::before{--wpr-bg-7f94a309-fc5b-48dd-ad03-3b4cb4deec3a: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/loader.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.visa,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.visa,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.visa,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.visa,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.visa,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.visa,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.visa,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.visa,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.visa{--wpr-bg-d73dc61d-a3d0-48c9-9daa-ad4b94b6f38a: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/visa.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.mastercard,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.mastercard,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.mastercard,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.mastercard,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.mastercard,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.mastercard,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.mastercard,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.mastercard,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.mastercard{--wpr-bg-25d4f63b-897e-44b6-8c7c-1f53e83c4278: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/mastercard.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.laser,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.laser,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.laser,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.laser,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.laser,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.laser,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.laser,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.laser,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.laser{--wpr-bg-c37072e5-e06a-4746-8105-de57156c87c6: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/laser.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.dinersclub,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.dinersclub,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.dinersclub,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.dinersclub,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.dinersclub,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.dinersclub,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.dinersclub,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.dinersclub,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.dinersclub{--wpr-bg-0004b6c0-3c7a-49c0-b9b3-be470d557151: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/diners.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.maestro,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.maestro,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.maestro,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.maestro,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.maestro,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.maestro,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.maestro,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.maestro,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.maestro{--wpr-bg-022b68e3-bea6-4549-8f52-ff4acdf5fa52: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/maestro.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.jcb,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.jcb,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.jcb,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.jcb,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.jcb,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.jcb,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.jcb,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.jcb,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.jcb{--wpr-bg-b62814cd-30e8-471e-a01a-f532610fdbec: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/jcb.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.amex,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.amex,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.amex,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.amex,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.amex,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.amex,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.amex,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.amex,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.amex{--wpr-bg-e1d10934-c4d2-491a-8429-6fdf783fa0f6: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/amex.svg');}#add_payment_method #payment div.payment_box .wc-credit-card-form-card-cvc.discover,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-expiry.discover,#add_payment_method #payment div.payment_box .wc-credit-card-form-card-number.discover,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-cvc.discover,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-expiry.discover,.woocommerce-cart #payment div.payment_box .wc-credit-card-form-card-number.discover,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-cvc.discover,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-expiry.discover,.woocommerce-checkout #payment div.payment_box .wc-credit-card-form-card-number.discover{--wpr-bg-1a514fb6-2ad1-4b7d-a87e-61aa4820a114: url('https://www.apting.fr/wp-content/plugins/woocommerce/assets/images/icons/credit-cards/discover.svg');}.single-jet-popup{--wpr-bg-cbf9878a-9ccb-4f68-8151-86db8fb693ce: url('https://www.apting.fr/wp-content/plugins/jet-popup/assets/image/transparent.jpg');}.elementor-88 .elementor-element.elementor-element-dc852b3::before, .elementor-88 .elementor-element.elementor-element-dc852b3 > .elementor-background-video-container::before, .elementor-88 .elementor-element.elementor-element-dc852b3 > .e-con-inner > .elementor-background-video-container::before, .elementor-88 .elementor-element.elementor-element-dc852b3 > .elementor-background-slideshow::before, .elementor-88 .elementor-element.elementor-element-dc852b3 > .e-con-inner > .elementor-background-slideshow::before, .elementor-88 .elementor-element.elementor-element-dc852b3 > .elementor-motion-effects-container > .elementor-motion-effects-layer::before{--wpr-bg-0f2f9710-45b9-4da7-a80d-26d0ae0d68f5: url('https://www.apting.fr/wp-content/uploads/2024/04/Apting-4.png');}.elementor-88 .elementor-element.elementor-element-1591ccb::before, .elementor-88 .elementor-element.elementor-element-1591ccb > .elementor-background-video-container::before, .elementor-88 .elementor-element.elementor-element-1591ccb > .e-con-inner > .elementor-background-video-container::before, .elementor-88 .elementor-element.elementor-element-1591ccb > .elementor-background-slideshow::before, .elementor-88 .elementor-element.elementor-element-1591ccb > .e-con-inner > .elementor-background-slideshow::before, .elementor-88 .elementor-element.elementor-element-1591ccb > .elementor-motion-effects-container > .elementor-motion-effects-layer::before{--wpr-bg-65ec0eeb-a733-4228-93d2-d3914489757b: url('https://www.apting.fr/wp-content/uploads/2024/04/Apting-1.png');}#elementor-popup-modal-4940 .dialog-widget-content{--wpr-bg-3c3140ae-d05b-4edf-a361-14d24a5038c9: url('https://www.apting.fr/wp-content/uploads/2024/04/Apting-4.svg');}.chosen-container-single .chosen-single abbr{--wpr-bg-ef93cd06-6fe6-42f2-b5d1-be099490f7dc: url('https://www.apting.fr/wp-content/plugins/jet-search/assets/lib/chosen/chosen-sprite.png');}.chosen-container-single .chosen-single div b{--wpr-bg-f4ef6f4e-a8a0-4299-a8e4-dae7b6d28cf1: url('https://www.apting.fr/wp-content/plugins/jet-search/assets/lib/chosen/chosen-sprite.png');}.chosen-container-single .chosen-search input[type=text]{--wpr-bg-178657b1-8f5a-4a9a-95ae-b12b329c5b91: url('https://www.apting.fr/wp-content/plugins/jet-search/assets/lib/chosen/chosen-sprite.png');}.chosen-container-multi .chosen-choices li.search-choice .search-choice-close{--wpr-bg-06340388-a9a7-474f-aaca-f554f1700ae9: url('https://www.apting.fr/wp-content/plugins/jet-search/assets/lib/chosen/chosen-sprite.png');}.chosen-rtl .chosen-search input[type=text]{--wpr-bg-a460833c-41d5-419a-be27-d447aa54f070: url('https://www.apting.fr/wp-content/plugins/jet-search/assets/lib/chosen/chosen-sprite.png');}.chosen-container .chosen-results-scroll-down span,.chosen-container .chosen-results-scroll-up span,.chosen-container-multi .chosen-choices .search-choice .search-choice-close,.chosen-container-single .chosen-search input[type=text],.chosen-container-single .chosen-single abbr,.chosen-container-single .chosen-single div b,.chosen-rtl .chosen-search input[type=text]{--wpr-bg-e89beaa1-e76b-4dfb-9644-6b00ba75eca3: url('https://www.apting.fr/wp-content/plugins/jet-search/assets/lib/chosen/chosen-sprite@2x.png');}.elementor-11535 .elementor-element.elementor-element-ce679c4::before, .elementor-11535 .elementor-element.elementor-element-ce679c4 > .elementor-background-video-container::before, .elementor-11535 .elementor-element.elementor-element-ce679c4 > .e-con-inner > .elementor-background-video-container::before, .elementor-11535 .elementor-element.elementor-element-ce679c4 > .elementor-background-slideshow::before, .elementor-11535 .elementor-element.elementor-element-ce679c4 > .e-con-inner > .elementor-background-slideshow::before, .elementor-11535 .elementor-element.elementor-element-ce679c4 > .elementor-motion-effects-container > .elementor-motion-effects-layer::before{--wpr-bg-942396c1-d1ad-4cb6-87b5-5fe953846996: url('https://www.apting.fr/wp-content/uploads/2024/04/Apting-4.png');}.stripe-gateway-checkout-email-field button.stripe-gateway-stripelink-modal-trigger{--wpr-bg-0e858b94-f4b5-49cd-9b19-eb734c577784: url('https://www.apting.fr/wp-content/plugins/woocommerce-gateway-stripe/assets/images/link.svg');}

[WooAjaxCartCount]

Excel : prise en main

Objectifs

Prendre en main l’interface de travail Excel
Gérer les onglets et les classeurs
Connaître les fonctionnalités et concevoir des formules

Participants

Toute personne amenée à utiliser Excel.

Pré-requis

Aucun.

Programme

Présentation des fonctionnalités et de l’interface de travail
Saisir, modifier et supprimer des données
Créer un tableau de calcul
Mettre en forme les données (dates, texte, nombres)
Mettre en page, désélectionner une sélection et imprimer
Créer des formules
Créer des listes déroulantes
Appréhender l’utilisation des parenthèses
Utiliser les fonctions usuelles (SOMME, NB, CONTACT, SI…)
Calculer des pourcentages
Gérer les classeurs
Utiliser des formules de liaison entre feuilles Excel

Exercices pratiques

Entraînement : créer un tableau et s’exercer à trier et gérer les données
Exercice pratique : utiliser les outils de calculs
Mise en situation : travailler via plusieurs classeurs Excel

Aptibox

Les fonctions usuelles sur Excel
Méthodologie d’une création d’un tableau Excel et de ses utilisations
Les 10 conseils pour utiliser efficacement Excel

Référence

EXC01

Participants

Individuel
Collectif

Durée

2 heures

Prix

290,00 € HT

Format

Distanciel
Présentiel

Dates

Sur mesure

Options

Aptibox
Coaching
Entrainement intensif
Suivi

Ajouter au panier

Télécharger ce programme

Réserver une séance

Financements

Nous vous aidons dans vos démarches pour financer vos formations. Retrouvez toutes les informations sur les solutions de financement.

Nos forfaits

Nous vous proposons des forfaits/packs d’achat de modules à prix dégressifs, selon la quantité demandée.

Ces modules de 2h sont valables pour nos 5000 aptitudes ( = ateliers de formation 100% sur mesure allant à l’essentiel, tous thèmes confondus, sur tous nos catalogues management, RH, communication, développement personnel, commercial…) et valables également sur toutes nos prestations (séances de coaching, bilan de compétences , feedback 360°, codéveloppement…).