Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!

Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
<!-- This template is used on https://wiki.gccollab.ca/M365/Excel, Do NOT delete. -->
+
<multilang>
=Excel - Training Materials=
+
@en|
Below is a collection of Microsoft Excel training products to support public servants.
+
[https://www.gcpedia.gc.ca/wiki/Accessible-M365# Click here to return to Accessible-M365]
 +
{{TOC limit|2}}
   −
==Virtual Training==
+
== Page Status ==
[[Image:Virtual_Training.PNG|alt="Virtual Training"|Virtual Training|100px|link=https://wiki.gccollab.ca/M365/Training-Formation]]
     −
==Departmental Resources==
+
This page was last updated on '''April 4, 2024''' and currently reflects the data of the '''March 2024''' period.
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.''']]
     −
==Additional Resources==
+
== Overview ==
'''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.
     −
*[https://support.microsoft.com/en-us/office/create-a-workbook-in-excel-94b00f50-5896-479c-b0c5-ff74603b35a3 Excel Quick Start (Microsoft)]
+
The DCC M365 accessibility issues summary tables surface data and trends in relation to Government of Canada (GC) M365 accessibility issues. The three tables include the following key data labels:
*[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)]
+
==== SSC DCC M365 Total Accessibility Issues Summary Table Definitions====
*[https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 List of all Excel functions available (Microsoft)]
+
* ''Total M365 Accessibility Issues'': The total number of M365 accessibility issues tracked by SSC DCC.
*[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)]
+
* ''Total Active Accessibility Issues'': The total number of active (Investigation is underway) M365 accessibility issues.
*[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)]
+
* ''Total Pending M365 Accessibility Issues'': The total number of M365 accessibility issues currently subject to a workload backlog.
*[https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664?wt.mc_id=otc_excel Tables (Microsoft)]
+
* ''Total Closed M365 Accessibility Issues'': The total number of closed (fixed to the production environment, or the issue is no longer a problem) M365 accessibility issues.
*[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)]
+
==== Accessibility Issues by M365 Application Summary Table ====
*[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)]
+
* The total number of issues by M365 product or application, such as MS Teams or SharePoint, among others.
*[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)]
     −
===Accessibility===
+
<u>[[Media:SSC-DCC-M365-Accessibility-Issues-Tracker-EN.xlsx | The SSC DCC UX Accessibility Issues Tracker]]</u> is available for download.
* [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/en-us/office/screen-reader-support-for-excel-0976b140-7033-4e2d-8887-187280701bf8 Screen reader support for Excel (Microsoft)]
+
== M365 Total Accessibility Issues Summary Table ==
   −
* Make your Excel documents accessible to people with disabilities (Microsoft)
+
{| class='wikitable' border='1'
::[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)]
+
|-
 +
!#
 +
! Issues Summary
 +
! Number of Reported Issues
 +
|-
 +
| 1
 +
| '''Total M365 Accessibility Issues'''
 +
| 1434
 +
|-
 +
| 2
 +
| 'Total '''Active''' Accessibility Issues
 +
| 99
 +
|-
 +
| 3
 +
| Total '''Pending''' Accessibility Issues
 +
| 266
 +
|-
 +
| 4
 +
| Total '''Closed''' Accessibility Issues
 +
| 1069
 +
|}
   −
* [https://support.microsoft.com/en-us/office/video-start-with-an-accessible-excel-template-918db751-1585-41c5-9ddf-5d7a0915afaf  Create accessible Excel workbooks (Microsoft)]
     −
* Improve accessibility with the Accessibility Checker (Microsoft)
+
==== NEW! M365 Total Accessibility Issues Progress Summary Table ====
::[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)]
     −
* [https://www.youtube.com/watch?v=cW5J0Nd0Pg0 Accessibility Learning Webinar Series: Excel Tips and Tricks (YouTube)]
+
* Total M365 Accessibility '''Archived''' Issues : Tickets created from 2020 and until 6 months prior to the latest monthly data updates, and are in a Closed status.
 +
* Total M365 Accessibility '''In Progress''' Issues: Tickets created from 2020 and until 6 months prior to the latest monthly data updates, and are in an Active, Pending, or Closed status.
   −
===Infographics===
+
== M365 Total Accessibility Issues - Progress Summary Table ==
{{M365_Info_Excel_EN}}
     −
===Communities===
+
{| class='wikitable' border='1'
*[[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)]
+
! Issues Progress Summary
*[https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat Microsoft Excel Community Hub (Microsoft)]
+
! Number of Issues
* [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)]
+
| 1
* [https://www.facebook.com/groups/msofficetutorial/ Microsoft Office Facebook Group (Facebook)]
+
| '''Total M365 Accessibility Issues'''
 +
| 1434
 +
|-
 +
| 2
 +
| Total '''Archived''' Accessibility Issues
 +
| 834
 +
|- 
 +
| 3
 +
| Total '''In Progress''' Accessibility Issues
 +
| 600
 +
|-
 +
|}
 +
 
 +
 
 +
== Accessibility Issues by M365 Application Summary Table ==
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Affected M365 Application
 +
! Number of Reported Issues
 +
|- 
 +
| 1
 +
| SharePoint
 +
| 375
 +
|- 
 +
| 2
 +
| Dynamics
 +
| 237
 +
|-
 +
| 3
 +
| Power Apps
 +
| 194
 +
|-
 +
| 4
 +
| Teams
 +
| 112
 +
|- 
 +
| 5
 +
|  Forms
 +
| 108
 +
|- 
 +
| 6
 +
| Power BI
 +
| 86
 +
|-
 +
| 7
 +
| Planner
 +
| 53
 +
|-
 +
| 8
 +
| My Sign-ins
 +
| 50
 +
|- 
 +
| 9
 +
| Delve
 +
| 36
 +
|- 
 +
| 10
 +
| Word
 +
| 24
 +
|-
 +
| 11
 +
| SQL Server
 +
| 22
 +
|-
 +
| 12
 +
| Office 365
 +
| 18
 +
|-
 +
| 13
 +
| Outlook
 +
 
 +
| 12
 +
|-
 +
| 14
 +
|  Not Product-specific
 +
| 11
 +
|-
 +
| 15
 +
| OneNote
 +
| 10
 +
|-
 +
| 16
 +
| Sway
 +
| 10
 +
|-
 +
| 17
 +
| Whiteboard
 +
| 10
 +
|-
 +
| 18
 +
| OneDrive
 +
| 9
 +
|-
 +
| 19
 +
| Yammer
 +
| 8
 +
|-
 +
| 20
 +
| Authenticator
 +
| 6
 +
|-
 +
| 21
 +
| Excel
 +
| 5
 +
|-
 +
| 22
 +
| PowerPoint
 +
| 5
 +
|- 
 +
| 23
 +
| Office - General
 +
| 4
 +
|-
 +
| 24
 +
| Windows
 +
| 4
 +
|-
 +
| 25
 +
| Windows 11
 +
| 4
 +
|-
 +
| 26
 +
| *Not Listed
 +
| 3
 +
|-
 +
| 27
 +
| Bookings
 +
| 3
 +
|-  
 +
| 28
 +
| Microsoft 365
 +
| 3
 +
|- 
 +
| 29
 +
| Microsoft Lists
 +
| 2
 +
|- 
 +
| 30
 +
| *All Products
 +
| 1
 +
|- 
 +
| 31
 +
| Accessibility Insights
 +
| 1
 +
|- 
 +
| 32
 +
| Azure Active Directory
 +
| 1
 +
|-
 +
| 33
 +
| Azure Information Protection
 +
| 1
 +
|- 
 +
| 34
 +
| D365 Customer Voice
 +
| 1
 +
|-
 +
| 35
 +
| M365 Security and Compliance
 +
| 1
 +
|-
 +
| 36
 +
| Microsoft Deployment Toolkit
 +
| 1
 +
|-
 +
| 37
 +
| Microsoft Translator
 +
| 1
 +
|-
 +
| 38
 +
| Quick Assist (Remote Assistance Service)
 +
| 1
 +
|-
 +
|39
 +
| Windows Defender
 +
| 1
 +
|-
 +
| 40
 +
| All
 +
| 1434
 +
|}
 +
 
 +
 
 +
 
 +
 
 +
<br>
 +
Note: The SSC DCC M365 accessibility issues intake process is currently being reviewed and optimized to help ensure the aggregation and action of all GC M365 accessibility issues.
    
==Contact Us==
 
==Contact Us==
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Excel M365 Training Feedback]
     −
==Attributions and Sources==
+
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca DCC.Accessibility (SSC), dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca]
[[M365/Attributions|Attributions and Sources]]
+
 
 +
 
 +
<u>[https://www.gcpedia.gc.ca/wiki/Accessible-M365# Click here to return to Accessible-M365]</u>
 +
 
 +
@fr|
 +
[https://www.gcpedia.gc.ca/wiki/Accessibilit%C3%A9-M365# Cliquez ici pour retourner à Accessibilité-M365]
 +
{{TOC limit|2}}
 +
 
 +
== Statut de la page ==
 +
 
 +
Cette page a été mise à jour pour la dernière fois le '''4 avril 2024''' et reflète actuellement les données de la période de '''mars 2024'''.
 +
 
 +
 
 +
== Aperçu ==
 +
 
 +
Les tableaux récapitulatifs du total des problèmes d’accessibilité de M365 du CCN de SSC présentent les données et les tendances relatives aux problèmes d'accessibilité de M365 du gouvernement du Canada (GC).  Les trois tableaux comprennent les étiquettes de données clés suivantes :
 +
 
 +
==== Tableau récapitulatif des problèmes d'accessibilité de M365 du CCN de SSC ====
 +
* ''Total des problèmes d'accessibilité de M365 :'' Le nombre total de problèmes d'accessibilité de M365 suivis par CCN de SSC.
 +
* ''Total des problèmes d'accessibilités actifs :'' Le nombre total de problèmes d'accessibilité de M365 actifs (enquête en cours).
 +
* ''Total des problèmes d'accessibilités En suspens de M365 : Le nombre total de problèmes En suspens faisant actuellement l'objet d'un retard dans la charge de travail.
 +
* ''Total des problèmes d'accessibilité fermés :'' Le nombre total de problèmes d'accessibilité M365 fermés (fixés à l'environnement de production, ou le problème n'est plus un problème).
 +
==== Tableau récapitulatif des problèmes d'accessibilité par application M365 ====
 +
* Le nombre total de problèmes par produit ou application M365, par exemple MS Teams ou SharePoint.
 +
 
 +
<u>[[Media:SSC-DCC-M365-Accessibility-Issues-Tracker-FR.xlsx | Le Suivi des problèmes d'accessibilité de CCN de SPC]]</u> est disponible pour le téléchargement.
 +
 
 +
== Tableau récapitulatif des problèmes d'accessibilité de M365 ==
 +
 
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Résumé des problèmes
 +
! Nombre de problèmes signalés
 +
|- 
 +
| 1
 +
| '''Total des problèmes d'accessibilité de M365'''
 +
| 1434
 +
|-
 +
| 2
 +
| '''Total des problèmes d'accessibilités actifs'''
 +
| 99
 +
|- 
 +
| 3
 +
| '''Total des problèmes d'accessibilités En suspens'''
 +
| 266
 +
|- 
 +
| 4
 +
| '''Total des problèmes d'accessibilité fermés'''
 +
| 1069
 +
|}
 +
 
 +
 
 +
==== NOUVEAU! Tableau récapitulatif des progrès du total des problèmes d'accessibilité de M365 ====
 +
 
 +
* Total des problèmes d'accessibilité de M365 de catégorie '''Archivé''' : Billets créés à partir de 2020 et jusqu'à 6 mois avant les dernières mises à jour mensuelles des données, et dont le statut est Fermé.
 +
* Total des problèmes d'accessibilité de M365 de catégorie '''En cours''' : Billets créés à partir de 2020 et jusqu'à 6 mois avant les dernières mises à jour mensuelles des données, et dont le statut est Actif, En attente, ou Fermé.
 +
 
 +
== Tableau récapitulatif des progrès du total des problèmes d'accessibilité de M365 ==
 +
 
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Résumé des progrès des problèmes
 +
! Nombre de problèmes
 +
|- 
 +
| 1
 +
| '''Total des problèmes d'accessibilité de M365'''
 +
| 1434
 +
|-
 +
| 2
 +
| Total des problèmes d'accessiblité de catégorie '''Archivé'''
 +
| 834
 +
|- 
 +
| 3
 +
| Total des problèmes d'accessibilité de catégorie '''En cours'''
 +
| 600
 +
|-
 +
|}
 +
 
 +
 
 +
== Tableau récapitulatif des problèmes d'accessibilité par application M365 ==
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Résumé des problèmes
 +
! Nombre de problèmes signalés
 +
|- 
 +
| 1
 +
| SharePoint
 +
| 375
 +
|- 
 +
| 2
 +
| Dynamics
 +
| 237
 +
|-
 +
| 3
 +
| Power Apps
 +
| 194
 +
|-
 +
| 4
 +
| Teams
 +
| 112
 +
|- 
 +
| 5
 +
|  Forms
 +
| 108
 +
|- 
 +
| 6
 +
| Power BI
 +
| 86
 +
|-
 +
| 7
 +
| Planner
 +
| 53
 +
|-
 +
| 8
 +
| My Sign-ins
 +
| 50
 +
|- 
 +
| 9
 +
| Delve
 +
| 36
 +
|- 
 +
| 10
 +
| Word
 +
| 24
 +
|-
 +
| 11
 +
| SQL Server
 +
| 22
 +
|-
 +
| 12
 +
| Office 365
 +
| 18
 +
|-
 +
| 13
 +
| Outlook
 +
 
 +
| 12
 +
|-
 +
| 14
 +
|  *Pas spécifique au produit
 +
| 11
 +
|-
 +
| 15
 +
| OneNote
 +
| 10
 +
|-
 +
| 16
 +
| Sway
 +
| 10
 +
|-
 +
| 17
 +
| Whiteboard
 +
| 10
 +
|-
 +
| 18
 +
| OneDrive
 +
| 9
 +
|-
 +
| 19
 +
| Yammer
 +
| 8
 +
|-
 +
| 20
 +
| Authenticator
 +
| 6
 +
|-
 +
| 21
 +
| Excel
 +
| 5
 +
|-
 +
| 22
 +
| PowerPoint
 +
| 5
 +
|- 
 +
| 23
 +
| Office - General
 +
| 4
 +
|-
 +
| 24
 +
| Windows
 +
| 4
 +
|-
 +
| 25
 +
| Windows 11
 +
| 4
 +
|-
 +
| 26
 +
| *Non répertorié
 +
| 3
 +
|-
 +
| 27
 +
| Bookings
 +
| 3
 +
|-
 +
| 28
 +
| Microsoft 365
 +
| 3
 +
|- 
 +
| 29
 +
| Microsoft Lists
 +
| 2
 +
|- 
 +
| 30
 +
| *Tous les produits
 +
| 1
 +
|- 
 +
| 31
 +
| Accessibility Insights
 +
| 1
 +
|- 
 +
| 32
 +
| Azure Active Directory
 +
| 1
 +
|-
 +
| 33
 +
| Azure Information Protection
 +
| 1
 +
|- 
 +
| 34
 +
| D365 Customer Voice
 +
| 1
 +
|-
 +
| 35
 +
|Sécurité et conformité M365
 +
| 1
 +
|-
 +
| 36
 +
| Microsoft Deployment Toolkit
 +
| 1
 +
|-
 +
| 37
 +
| Microsoft Translator
 +
| 1
 +
|-
 +
| 38
 +
| Assistance rapide (Outil d’assistance à distance)
 +
| 1
 +
|-
 +
|39
 +
| Windows Defender
 +
| 1
 +
|-
 +
|40
 +
| Tous
 +
| 1434
 +
|}
 +
 
 +
 
 +
 
 +
 
 +
 
 +
Remarque : Le processus de réception des problèmes d'accessibilité de M365 du CCN de SSC est en cours de révision et d'optimisation afin de garantir le regroupement et l'action de tous les problèmes d'accessibilité de la CCN M365.
 +
 
 +
==Contactez-nous==
 +
 
 +
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca Accessibilite.CNN (SPC), dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca]
 +
 
   −
[[Category:M365]]
+
<u>[https://www.gcpedia.gc.ca/wiki/Accessibilit%C3%A9-M365# Cliquez ici pour retourner à Accessibilité-M365]</u>
[[Category:MS Excel]]
+
</multilang>
[[Category:Training]]
  −
[[Category:Microsoft]]
 

Navigation menu

GCwiki