6,010
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − Below is a collection of Microsoft Excel training products to support public servants. + − ==Virtual Training==+ − [[Image:Virtual_Training.PNG|alt="Virtual Training"|Virtual Training|100px|link=https://wiki.gccollab.ca/M365/Training-Formation]] − + − Various departments and agencies across the GC are developing content to support the adoption of M365 applications. Instead of creating your own, review the content that is already shared here. If you have drafted content, please consider sharing it for your colleagues. [[M365/Resources-Ressources|'''Click here to see other Departments' Resources or to add your own.''']]+ − + − + − *[https://support.microsoft.com/en-us/office/create-a-workbook-in-excel-94b00f50-5896-479c-b0c5-ff74603b35a3 Excel Quick Start (Microsoft)]+ − *[https://support.microsoft.com/en-us/office/create-a-new-workbook-ae99f19b-cecb-4aa0-92c8-7126d6212a83?wt.mc_id=otc_excel# Intro to Excel (Microsoft)]+ − *[https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 List of all Excel functions available (Microsoft)] − *[https://support.office.com/en-us/article/insert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246?wt.mc_id=otc_excel Rows & columns (Microsoft)] − *[https://support.office.com/en-us/article/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173?wt.mc_id=otc_excel Formulas & functions (Microsoft)] − *[https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664?wt.mc_id=otc_excel Tables (Microsoft)] − *[https://support.office.com/en-us/article/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2?wt.mc_id=otc_excel Charts (Microsoft)] − *[https://support.office.com/en-us/article/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576?wt.mc_id=otc_excel PivotTables (Microsoft)] − *[https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb Excel video training (Microsoft)] − *[https://support.microsoft.com/en-us/excel Excel help & learning (Microsoft)] − + − + + + + + + + + + − + + − + − ::[https://support.microsoft.com/en-us/office/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593#Picktab=Windows (Windows)] [https://support.microsoft.com/en-us/office/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=macOS (macOS)] [https://support.microsoft.com/en-us/office/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=iOS (iOS)] [https://support.microsoft.com/en-us/office/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=Android (Android)] [https://support.microsoft.com/en-us/office/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=Web (Web)] − + + − + − ::[https://support.microsoft.com/en-us/office/improve-accessibility-with-the-accessibility-checker-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f#PickTab=Windows (Windows)] [https://support.microsoft.com/en-us/office/improve-accessibility-with-the-accessibility-checker-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f#PickTab=macOS (macOS)] [https://support.microsoft.com/en-us/office/improve-accessibility-with-the-accessibility-checker-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f#PickTab=Web (Web)] − + + − + − {{M365_Info_Excel_EN}} − + − *[[gccollab:groups/about/4590555|Clicks and Tips (GCcollab)]]+ − *[https://www.gcpedia.gc.ca/wiki/Clicks_and_Tips_for_PC Clicks and Tips for PC (GCpedia)] − *[https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel?sort=LastReplyDate&dir=Desc&tab=All&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=All&isFilterExpanded=true&page=1 Microsoft Excel Answers (Microsoft)] − *[https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat Microsoft Excel Community Hub (Microsoft)] − * [https://www.linkedin.com/showcase/microsoft-365/?lipi=urn%3Ali%3Apage%3Ad_flagship3_showcase%3BhLMIsi6cT0WFN4rIkEsW8Q%3D%3D Microsoft 365 Profile (LinkedIn)] − * [https://www.youtube.com/user/officevideos/playlists Microsoft 365 YouTube Channel (YouTube)] − * [https://www.facebook.com/groups/msofficetutorial/ Microsoft Office Facebook Group (Facebook)] − + − + + + + + + + − + − + + + + − +
no edit summary
<!-- This template is used on https://wiki.gccollab.ca/M365/Excel, Do NOT delete. -->
<!-- This template is used on https://wiki.gccollab.ca/M365/Home/Excel, Do NOT delete. -->
=Excel - Training Materials=
=Excel - Matériel de formation=
Les matériels ci-dessous sont une collection de produits de formation sur Microsoft Excel pour soutenir les fonctionnaires.
'''Remarque : Certaines de ces ressources ne sont disponibles qu'en anglais.'''
==Departmental Resources==
==Formation virtuelle==
[[Image:Virtual_TrainingF.PNG|alt="Formation virtuelle"|Formation virtuelle|100px|link=https://wiki.gccollab.ca/M365/Training-Formation]]
==Additional Resources==
==Ressources ministérielles==
'''Disclaimer''': SSC provides these links to resources for your convenience. However, these resources reside outside of the Government of Canada and may not adhere to GC standards.
Divers ministères et organismes du gouvernement du Canada élaborent actuellement du contenu pour soutenir l'adoption des applications M365. Au lieu de créer votre propre contenu, passez en revue le contenu qui est déjà partagé ici. Si vous avez rédigé du contenu, veuillez envisager de le partager avec vos collègues. '''[[M365/Resources-Ressources|Cliquez ici pour voir les ressources des autres ministères ou pour ajouter les vôtres.]]'''
==Ressources supplémentaires==
'''Avertissement''' : SPC fournit ces liens vers des ressources pour votre commodité. Cependant, ces ressources sont situées à l’extérieur du gouvernement du Canada et peuvent ne pas respecter les normes du GC.
===Accessibility===
*[https://support.microsoft.com/fr-fr/office/cr%C3%A9er-un-classeur-dans-excel-94b00f50-5896-479c-b0c5-ff74603b35a3 Guide de démarrage rapide d’Excel (Microsoft)]
* [https://support.microsoft.com/en-us/office/accessibility-tools-for-excel-9d06ce53-457b-49dc-abd1-b31a7a92993f Accessibility tools for Excel (Microsoft)]
*[https://support.microsoft.com/fr-fr/office/cr%C3%A9er-un-classeur-ae99f19b-cecb-4aa0-92c8-7126d6212a83?wt.mc_id=otc_excel# Présentation d’Excel (Microsoft)]
*[https://support.microsoft.com/fr-fr/office/fonctions-excel-par-ordre-alphab%C3%A9tique-b3944572-255d-4efb-bb96-c6d90033e188 Liste de toutes les fonctions Excel disponibles (Microsoft)]
*[https://support.office.com/fr-fr/article/ins%C3%A9rer-ou-supprimer-des-lignes-et-des-colonnes-6f40e6e4-85af-45e0-b39d-65dd504a3246?wt.mc_id=otc_excel Lignes et colonnes (Microsoft)]
*[https://support.office.com/fr-fr/article/vue-d-ensemble-des-formules-dans-excel-ecfdc708-9162-49e8-b993-c311f47ca173?wt.mc_id=otc_excel Formules et fonctions (Microsoft)]
*[https://support.office.com/fr-fr/article/cr%C3%A9er-et-mettre-en-forme-des-tableaux-e81aa349-b006-4f8a-9806-5af9df0ac664?wt.mc_id=otc_excel Tableaux (Microsoft)]
*[https://support.office.com/fr-fr/article/cr%C3%A9er-un-graphique-de-bout-en-bout-0baf399e-dd61-4e18-8a73-b3fd5d5680c2?wt.mc_id=otc_excel Graphiques (Microsoft)]
*[https://support.office.com/fr-fr/article/cr%C3%A9er-un-tableau-crois%C3%A9-dynamique-pour-analyser-des-donn%C3%A9es-de-feuille-de-calcul-a9a84538-bfe9-40a9-a8e9-f99134456576?wt.mc_id=otc_excel Tableaux croisés dynamiques (Microsoft)]
*[https://support.microsoft.com/fr-fr/office/vid%C3%A9o-de-formation-excel-9bc05390-e94c-46af-a5b3-d7c22f6990bb Vidéo de formation Excel (Microsoft)]
*[https://support.microsoft.com/fr-fr/excel Aide et apprentissage d'Excel (Microsoft)]
* [https://support.microsoft.com/en-us/office/screen-reader-support-for-excel-0976b140-7033-4e2d-8887-187280701bf8 Screen reader support for Excel (Microsoft)]
====Accessibilité====
* [https://support.microsoft.com/fr-fr/office/outils-d-accessibilit%C3%A9-pour-les-excel-9d06ce53-457b-49dc-abd1-b31a7a92993f Outils d’accessibilité pour les Excel (Microsoft)]
* Make your Excel documents accessible to people with disabilities (Microsoft)
* [https://support.microsoft.com/fr-fr/office/prise-en-charge-du-lecteur-d-%C3%A9cran-pour-les-excel-0976b140-7033-4e2d-8887-187280701bf8 Prise en charge du lecteur d’écran pour les Excel (Microsoft)]
* [https://support.microsoft.com/en-us/office/video-start-with-an-accessible-excel-template-918db751-1585-41c5-9ddf-5d7a0915afaf Create accessible Excel workbooks (Microsoft)]
* Rendre vos documents Excel accessibles aux personnes atteintes d’un handicap (Microsoft)
::[https://support.microsoft.com/fr-fr/office/rendre-vos-documents-excel-accessibles-aux-personnes-atteintes-d-un-handicap-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=Windows (Windows)] [https://support.microsoft.com/fr-fr/office/rendre-vos-documents-excel-accessibles-aux-personnes-atteintes-d-un-handicap-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=macOS (macOS)] [https://support.microsoft.com/fr-fr/office/rendre-vos-documents-excel-accessibles-aux-personnes-atteintes-d-un-handicap-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=iOS (iOS)] [https://support.microsoft.com/fr-fr/office/rendre-vos-documents-excel-accessibles-aux-personnes-atteintes-d-un-handicap-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=Android (Android)] [https://support.microsoft.com/fr-fr/office/rendre-vos-documents-excel-accessibles-aux-personnes-atteintes-d-un-handicap-6cc05fc5-1314-48b5-8eb3-683e49b3e593#PickTab=Web (Web)]
* Improve accessibility with the Accessibility Checker (Microsoft)
* [https://support.microsoft.com/fr-fr/office/vid%C3%A9o-partir-d-un-mod%C3%A8le-excel-accessible-918db751-1585-41c5-9ddf-5d7a0915afaf Créer des classeurs Excel accessibles (Microsoft)]
* [https://www.youtube.com/watch?v=cW5J0Nd0Pg0 Accessibility Learning Webinar Series: Excel Tips and Tricks (YouTube)]
* Améliorer l’accessibilité à l’aide du Vérificateur d’accessibilité (Microsoft)
::[https://support.microsoft.com/fr-fr/office/am%C3%A9liorer-l-accessibilit%C3%A9-%C3%A0-l-aide-du-v%C3%A9rificateur-d-accessibilit%C3%A9-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f#PickTab=Windows (Windows)] [https://support.microsoft.com/fr-fr/office/am%C3%A9liorer-l-accessibilit%C3%A9-%C3%A0-l-aide-du-v%C3%A9rificateur-d-accessibilit%C3%A9-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f#PickTab=macOS (macOS)] [https://support.microsoft.com/fr-fr/office/am%C3%A9liorer-l-accessibilit%C3%A9-%C3%A0-l-aide-du-v%C3%A9rificateur-d-accessibilit%C3%A9-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f#PickTab=Web (Web)]
===Infographics===
* [https://www.youtube.com/watch?v=cW5J0Nd0Pg0 Série de webinaires d'apprentissage sur l'accessibilité : Astuces pour maîtriser Excel - Vidéo (YouTube)] - disponible uniquement en anglais
===Communities===
===Infographies===
{{M365_Info_Excel_FR}}
==Contact Us==
===Communautés===
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Excel M365 Training Feedback]
* [[gccollab:groups/about/4590555|Clics et conseils (GCcollab)]]
* [https://www.gcpedia.gc.ca/wiki/Clicks_and_Tips_pour_ordinateur Clicks and Tips pour ordinateur (GCpedia)]
* [https://answers.microsoft.com/fr-fr/msoffice/forum/msoffice_excel?sort=LastReplyDate&dir=Desc&tab=All&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=All&isFilterExpanded=true&page=1 Réponses Microsoft Excel (Microsoft)]
*[https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat Centre communautaire Microsoft Excel (Microsoft)] - disponible uniquement en anglais
* [https://www.linkedin.com/showcase/microsoft-365/?lipi=urn%3Ali%3Apage%3Ad_flagship3_showcase%3BhLMIsi6cT0WFN4rIkEsW8Q%3D%3D Profil de Microsoft 365 (LinkedIn)] - disponible uniquement en anglais
* [https://www.youtube.com/user/officevideos/playlists Canal YouTube de Microsoft 365 (YouTube)] - disponible uniquement en anglais
*[https://www.facebook.com/groups/msofficetutorial/ Groupe Facebook de Microsoft Office (Facebook)] - disponible uniquement en anglais
==Attributions and Sources==
==Contactez-nous==
[[M365/Attributions|Attributions and Sources]]
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=Rétroaction%20sur%20la%20formation%20M365&body=https://wiki.gccollab.ca/M365/Excel Rétroaction sur la formation M365]
==Attributions et Sources==
[[M365/Attributions|Attributions et Sources]]
[[Category:M365]]
[[Category:M365]]
[[Category:MS Excel]]
[[Category:MS Excel]]
[[Category:Training]]
[[Category:Formation]]
[[Category:Microsoft]]
[[Category:Microsoft]]
