{"id":3,"count":17,"description":"Ces astuces Excel, soit le logiciel phare de la suite Microsoft Office. C'est le tableur le plus utilis\u00e9 au monde dans les entreprises pour g\u00e9rer les tableaux et d'une mani\u00e8re g\u00e9n\u00e9rale les nombres. Certainement un des outils bureautiques sur lequel les financiers passent le plus clair de leur temps.\r\n\r\nC'est en quelque sorte l'outil de Business Intelligence N\u00b01, et de tr\u00e8s loin. Car Excel permet d'analyser les donn\u00e9es, de les cr\u00e9er et de les mettre en forme. Quelles sont les astuces pour gagner du temps avec Excel?\r\n<h2>Astuces Excel pour maitriser le logiciel et gagner du temps<\/h2>\r\n<h3>Tout d'abord, la gestion des fichiers Excel et des tableaux<\/h3>\r\n<ul>\r\n \t<li><a href=\"https:\/\/expert-only.com\/astuces-excel\/comment-creer-un-fichier-avec-excel\/\">Comment cr\u00e9er un nouveau fichier Excel ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/ouvrir-2-fichiers-excel-2016-2-fenetres-windows-10\/\">Comment ouvrir deux fichiers Excel dans des fen\u00eatres diff\u00e9rentes ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/astuces-excel\/comment-faire-un-tableau-excel-et-trier-les-colonnes\/\">Comment cr\u00e9er un tableau Excel, le mettre en forme et trier les donn\u00e9es ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/fr\/excel\/tableau-croise-dynamique-excel\/\">Tutoriel pour cr\u00e9er un tableau dynamique avec Excel<\/a><\/li>\r\n<\/ul>\r\n<h3>Ensuite, la gestion des heures et des dates avec Excel<\/h3>\r\n<ul>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/separer-la-date-et-l-heure-avec-excel-2016\/\">Avec Excel comment s\u00e9parer la date et l'heure dans deux colonnes diff\u00e9rentes?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/afficher-nom-du-jour-toutes-lettres-excel\/\">Afficher le jour en toutes lettres \u00e0 partir d'une date avec Excel ?<\/a><\/li>\r\n<\/ul>\r\n<h3>Apr\u00e8s, les formules et les calculs dans les cellules<\/h3>\r\n<ul>\r\n \t<li><a href=\"https:\/\/expert-only.com\/astuces-excel\/supprimer-erreurs-excel-value-na-div0\/\">Comment supprimer les erreurs dans les formules Excel comme\u00a0 #VALUE! , #N\/A et la division par z\u00e9ro #DIV\/0! ?<\/a><\/li>\r\n<\/ul>\r\n<h3>Quatri\u00e8mement, les raccourcis Excel<\/h3>\r\n<ul>\r\n \t<li><a href=\"https:\/\/expert-only.com\/astuces-excel\/selectionner-une-colonne-entiere-avec-excel\/\">S\u00e9lectionner une colonne enti\u00e8re du d\u00e9but \u00e0 la fin ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/les-meilleurs-raccourcis-excel-de-selection\/\">Les meilleurs raccourcis Excel de s\u00e9lection de donn\u00e9es ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/raccourcis-excel-tableaux-croises-dynamiques\/\">Quels raccourcis Excel pour g\u00e9rer les tableaux crois\u00e9s dynamiques ?<\/a><\/li>\r\n<\/ul>\r\n<h3>Astuces diverses sur les fichiers Excel et les options<\/h3>\r\n<ul>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/afficher-une-feuille-de-calcul-excel-masquee\/\">Comment afficher une feuille de calcul Excel masqu\u00e9e ou cach\u00e9e ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/desactiver-option-arret-defilement-sur-excel\/\">Quel raccourci pour d\u00e9sactiver l\u2019option d'arr\u00eat d\u00e9filement sur Excel ?<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/desactiver-loption-de-modification-directe-sur-excel\/\">Comment d\u00e9sactiver l\u2019option de modification directe sur Excel?<\/a><\/li>\r\n<\/ul>\r\n<h3>Enfin, t\u00e9l\u00e9charger et installer les pilotes Excel et d'autres astuces sur la configuration<\/h3>\r\n<ul>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/telecharger-driver-oledb-excel-2007\/\">Lien pour t\u00e9l\u00e9charger le driver Excel OLEDB pour Excel 2007<\/a><\/li>\r\n \t<li><a href=\"https:\/\/expert-only.com\/excel\/telecharger-driver-oledb-pour-excel-2010\/\">Enfin, le lien pour t\u00e9l\u00e9charger le driver OLEDB pour la version 2010<\/a><\/li>\r\n<\/ul>\r\nEn conclusion, ces astuces Excel, utilis\u00e9es au quotidien permettent d'\u00eatre beaucoup plus efficace au travail ou dans la vie priv\u00e9e pour analyser les donn\u00e9es et les statistiques.","link":"https:\/\/expert-only.com\/fr\/excel\/","name":"Astuces Excel","slug":"excel","taxonomy":"category","parent":0,"meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Astuces Excel - Tutoriels SQL et IT<\/title>\n<meta name=\"description\" content=\"Pour apprendre de nouvelles astuces Excel et gagner du temps au travail? Microsoft Excel est le c\u00e9l\u00e8bre tableur de la suite Microsoft Office. Page .\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/excel\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Archives des Astuces Excel\" \/>\n<meta property=\"og:description\" content=\"Pour apprendre de nouvelles astuces Excel et gagner du temps au travail? Microsoft Excel est le c\u00e9l\u00e8bre tableur de la suite Microsoft Office. Page .\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"CollectionPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/\",\"url\":\"https:\/\/expert-only.com\/fr\/excel\/\",\"name\":\"Astuces Excel - Tutoriels SQL et IT\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"description\":\"Pour apprendre de nouvelles astuces Excel et gagner du temps au travail? Microsoft Excel est le c\u00e9l\u00e8bre tableur de la suite Microsoft Office. Page .\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Astuces Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Astuces Excel - Tutoriels SQL et IT","description":"Pour apprendre de nouvelles astuces Excel et gagner du temps au travail? Microsoft Excel est le c\u00e9l\u00e8bre tableur de la suite Microsoft Office. Page .","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/excel\/","og_locale":"fr_FR","og_type":"article","og_title":"Archives des Astuces Excel","og_description":"Pour apprendre de nouvelles astuces Excel et gagner du temps au travail? Microsoft Excel est le c\u00e9l\u00e8bre tableur de la suite Microsoft Office. Page .","og_url":"https:\/\/expert-only.com\/fr\/excel\/","og_site_name":"Tutoriels SQL et IT","twitter_card":"summary_large_image","twitter_site":"@expert_only","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/expert-only.com\/fr\/excel\/","url":"https:\/\/expert-only.com\/fr\/excel\/","name":"Astuces Excel - Tutoriels SQL et IT","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"description":"Pour apprendre de nouvelles astuces Excel et gagner du temps au travail? Microsoft Excel est le c\u00e9l\u00e8bre tableur de la suite Microsoft Office. Page .","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/excel\/#breadcrumb"},"inLanguage":"fr-FR"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Astuces Excel"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories\/3","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/taxonomies\/category"}],"wp:post_type":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts?categories=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}