Difference between revisions of "M365/test3"

From wiki
Jump to navigation Jump to search
 
(91 intermediate revisions by the same user not shown)
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]]
+
This page was last updated on '''November 29, 2024''' and currently reflects the data of the '''November 2024''' period.
  
==Departmental Resources==
+
== Accessibility Issues Tracker ==
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.''']]
+
<u>[[Media:SSC-DCC-M365-Accessibility-Issues-Tracker-EN.xlsx | The SSC SBPO UX Accessibility Issues Tracker]]</u> is available for download.
  
==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.
+
The SBPO M365 accessibility issues summary tables surface data and trends in relation to Government of Canada (GC) M365 accessibility issues. The two tables include the following key data labels:
  
*[https://support.microsoft.com/en-us/office/create-a-workbook-in-excel-94b00f50-5896-479c-b0c5-ff74603b35a3 Excel Quick Start (Microsoft)]
+
=== SSC SBPO M365 Total Accessibility Issues Summary Table Definitions ===
*[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)]
+
* ''Total M365 Accessibility Issues'': The total number of M365 accessibility issues tracked by SSC SBPO.
*[https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 List of all Excel functions available (Microsoft)]
+
* ''Total Active Accessibility Issues'': The total number of active (Investigation is underway) M365 accessibility issues.
*[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 Pending M365 Accessibility Issues'': The total number of M365 accessibility issues currently subject to a workload backlog.
*[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 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-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)]
 
  
===Accessibility===
+
==== M365 Total Accessibility Issues Summary Table ====
* [https://support.microsoft.com/en-us/office/accessibility-tools-for-excel-9d06ce53-457b-49dc-abd1-b31a7a92993f Accessibility tools for Excel (Microsoft)]
+
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Issues Summary
 +
! Number of Reported Issues
 +
|-
 +
| 1
 +
| '''Total M365 Accessibility Issues'''
 +
| 1798
 +
|-
 +
| 2
 +
| Total '''Active''' Accessibility Issues
 +
| 213
 +
|-
 +
| 3
 +
| Total '''Pending''' Accessibility Issues
 +
| 297
 +
|-
 +
| 4
 +
| Total '''Closed''' Accessibility Issues
 +
| 1253
 +
|}
  
* [https://support.microsoft.com/en-us/office/screen-reader-support-for-excel-0976b140-7033-4e2d-8887-187280701bf8 Screen reader support for Excel (Microsoft)]
+
=== Accessibility Issues by M365 Application Summary Table ===
 +
* The total number of issues by M365 product or application, such as MS Teams or SharePoint, among others.
  
* Make your Excel documents accessible to people with disabilities (Microsoft)
+
==== Accessibility Issues by M365 Application Summary Table ====
::[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)]
+
{| class='wikitable' border='1'
 +
|-  
 +
!#
 +
! Affected M365 Application
 +
! Number of Reported Issues
 +
|-
 +
| 1
 +
| Dynamics
 +
| 403
 +
|-
 +
| 2
 +
| SharePoint
 +
| 403
 +
|-
 +
| 3
 +
| Power Apps
 +
| 223
 +
|-
 +
| 4
 +
| Teams
 +
| 146
 +
|-
 +
| 5
 +
|  Forms
 +
| 111
 +
|-
 +
| 6
 +
| Power BI
 +
| 95
 +
|-  
 +
| 7
 +
| Planner
 +
| 53
 +
|-  
 +
| 8
 +
| My Sign-ins
 +
| 48
 +
|-
 +
| 9
 +
| Word
 +
| 41
 +
|-
 +
| 10
 +
| Delve
 +
| 36
 +
|-
 +
| 11
 +
| *Not product specific
 +
| 30
 +
|-
 +
| 12
 +
| SQL Server
 +
| 22
 +
|-
 +
| 13
 +
| Office 365
 +
| 18
 +
|-
 +
| 14
 +
| One Drive
 +
| 18
 +
|-
 +
| 15
 +
| Outlook
 +
| 15
 +
|-
 +
| 16
 +
| OneNote
 +
| 13
 +
|-
 +
| 17
 +
| Yammer
 +
| 12
 +
|-
 +
| 18
 +
| Excel
 +
| 10
 +
|-
 +
| 19
 +
| PowerPoint
 +
| 10
 +
|-  
 +
| 20
 +
| Sway
 +
| 10
 +
|-
 +
| 21
 +
| Whiteboard
 +
| 10
 +
|-
 +
| 22
 +
| Azure Dev Ops
 +
| 9
 +
|-
 +
| 23
 +
| Authenticator
 +
| 8
 +
|-  
 +
| 24
 +
| *Not Listed
 +
| 5
 +
|-
 +
| 25
 +
| Viva Insights
 +
| 5
 +
|-
 +
| 26
 +
| Microsoft 365
 +
| 4
 +
|-  
 +
| 27
 +
| Office - General
 +
| 4
 +
|-  
 +
| 28
 +
| Viva Learning
 +
| 4
 +
|-
 +
| 29
 +
| Windows
 +
| 4
 +
|-
 +
| 30
 +
| Windows 11
 +
| 4
 +
|-
 +
| 31
 +
| *All Products
 +
| 3
 +
|-  
 +
| 32
 +
| Bookings
 +
| 3
 +
|-
 +
| 33
 +
| IAM - Self Service Credentials Management Service
 +
| 2
 +
|-
 +
| 34
 +
| Microsoft Lists
 +
| 2
 +
|-
 +
| 35
 +
| Viva Engage
 +
| 2
 +
|-
 +
| 36
 +
| *All Digital Products
 +
| 1
 +
|-
 +
| 37
 +
| Accessibility Insights
 +
| 1
 +
|-
 +
| 38
 +
| Azure Active Directory
 +
| 1
 +
|-
 +
|39
 +
| Azure Command-Line Interface
 +
| 1
 +
|-
 +
| 40
 +
| Azure Information Protection
 +
| 1
 +
|-
 +
| 41
 +
| D365 Customer Voice
 +
| 1
 +
|-
 +
| 42
 +
| Edge
 +
| 1
 +
|-
 +
| 43
 +
| Microsoft Deployment Toolkit
 +
| 1
 +
|-
 +
| 44
 +
| Microsoft Purview
 +
| 1
 +
|-
 +
| 45
 +
| Microsoft Translator
 +
| 1
 +
|-
 +
| 46
 +
| Quick Assist (Remote Assistance Service)
 +
| 1
 +
|-
 +
| 47
 +
| Windows Defender
 +
| 1
 +
|-
 +
| 48
 +
| All
 +
| 1798
 +
|}
  
* [https://support.microsoft.com/en-us/office/video-start-with-an-accessible-excel-template-918db751-1585-41c5-9ddf-5d7a0915afaf  Create accessible Excel workbooks (Microsoft)]
+
==Contact Us==
 +
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca SBPO.Accessibility (SSC), dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca]
 +
 
 +
<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 '''29 novembre 2024''' et reflète actuellement les données de la période de '''novembre 2024'''.
  
* Improve accessibility with the Accessibility Checker (Microsoft)
+
== Suivi des problèmes d'accessibilité ==
::[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)]
+
<u>[[Media:SSC-DCC-M365-Accessibility-Issues-Tracker-FR.xlsx | Le Suivi des problèmes d'accessibilité de POSS de SPC]]</u> est disponible pour le téléchargement.
  
* [https://www.youtube.com/watch?v=cW5J0Nd0Pg0 Accessibility Learning Webinar Series: Excel Tips and Tricks (YouTube)]
+
== Aperçu ==
 +
Les tableaux récapitulatifs du total des problèmes d’accessibilité de M365 du POSS de SSC présentent les données et les tendances relatives aux problèmes d'accessibilité de M365 du gouvernement du Canada (GC).  Les deux tableaux comprennent les étiquettes de données clés suivantes :
  
===Infographics===
+
=== Tableau récapitulatif des problèmes d'accessibilité de M365 du POSS de SSC ===
{{M365_Info_Excel_EN}}
+
* ''Total des problèmes d'accessibilité de M365 :'' Le nombre total de problèmes d'accessibilité de M365 suivis par POSS 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).
  
===Communities===
+
==== Tableau récapitulatif des problèmes d'accessibilité de M365 ====
*[[gccollab:groups/about/4590555|Clicks and Tips (GCcollab)]]
+
{| class='wikitable' border='1'
*[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)]
+
! Résumé des problèmes
* [https://www.linkedin.com/showcase/microsoft-365/?lipi=urn%3Ali%3Apage%3Ad_flagship3_showcase%3BhLMIsi6cT0WFN4rIkEsW8Q%3D%3D Microsoft 365 Profile (LinkedIn)]
+
! Nombre de problèmes signalés
* [https://www.youtube.com/user/officevideos/playlists Microsoft 365 YouTube Channel (YouTube)]
+
|-
* [https://www.facebook.com/groups/msofficetutorial/ Microsoft Office Facebook Group (Facebook)]
+
| 1
 +
| '''Total des problèmes d'accessibilité de M365'''
 +
| 1798
 +
|-
 +
| 2
 +
| Total des problèmes d'accessibilités '''actifs'''
 +
| 213
 +
|- 
 +
| 3
 +
| Total des problèmes d'accessibilités '''En suspens'''
 +
| 297
 +
|-
 +
| 4
 +
| Total des problèmes d'accessibilité '''fermés'''
 +
| 1253
 +
|}
  
==Contact Us==
+
=== Tableau récapitulatif des problèmes d'accessibilité par application M365 ===
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Excel M365 Training Feedback]
+
* Le nombre total de problèmes par produit ou application M365, par exemple MS Teams ou SharePoint.
 +
 
 +
==== Tableau récapitulatif des problèmes d'accessibilité de M365 ====
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Application M365 affecté
 +
! Nombre de problèmes signalés
 +
|-
 +
| 1
 +
| Dynamics
 +
| 403
 +
|- 
 +
| 2
 +
| SharePoint
 +
| 403
 +
|-
 +
| 3
 +
| Power Apps
 +
| 223
 +
|-
 +
| 4
 +
| Teams
 +
| 146
 +
|- 
 +
| 5
 +
|  Forms
 +
| 111
 +
|- 
 +
| 6
 +
| Power BI
 +
| 95
 +
|-
 +
| 7
 +
| Planner
 +
| 53
 +
|-
 +
| 8
 +
| My Sign-ins
 +
| 48
 +
|- 
 +
| 9
 +
| Word
 +
| 41
 +
|- 
 +
| 10
 +
| Delve
 +
| 36
 +
|-
 +
| 11
 +
| *Pas spécifique au produit
 +
| 30
 +
|-
 +
| 12
 +
| SQL Server
 +
| 22
 +
|-
 +
| 13
 +
| Office 365
 +
| 18
 +
|-
 +
| 14
 +
| One Drive
 +
| 18
 +
|-
 +
| 15
 +
| Outlook
 +
| 15
 +
|-
 +
| 16
 +
| OneNote
 +
| 13
 +
|-
 +
| 17
 +
| Yammer
 +
| 12
 +
|-
 +
| 18
 +
| Excel
 +
| 10
 +
|-
 +
| 19
 +
| PowerPoint
 +
| 10
 +
|-
 +
| 20
 +
| Sway
 +
| 10
 +
|-
 +
| 21
 +
| Whiteboard
 +
| 10
 +
|-
 +
| 22
 +
| Azure Dev Ops
 +
| 9
 +
|- 
 +
| 23
 +
| Authenticator
 +
| 8
 +
|-
 +
| 24
 +
| *Non répertorié
 +
| 5
 +
|-
 +
| 25
 +
| Viva Insights
 +
| 5
 +
|-
 +
| 26
 +
| Microsoft 365
 +
| 4
 +
|-
 +
| 27
 +
| Office - Général
 +
| 4
 +
|-
 +
| 28
 +
| Viva Learning
 +
| 4
 +
|- 
 +
| 29
 +
| Windows
 +
| 4
 +
|- 
 +
| 30
 +
| Windows 11
 +
| 4
 +
|- 
 +
| 31
 +
| *Tous les produits
 +
| 3
 +
|- 
 +
| 32
 +
| Bookings
 +
| 3
 +
|-
 +
| 33
 +
| IAM - Self Service Credentials Management Service
 +
| 2
 +
|- 
 +
| 34
 +
| Microsoft Lists
 +
| 2
 +
|-
 +
| 35
 +
| Viva Engage
 +
| 2
 +
|-
 +
| 36
 +
| *All Digital Products
 +
| 1
 +
|-
 +
| 37
 +
| Accessibility Insights
 +
| 1
 +
|-
 +
| 38
 +
| Azure Active Directory
 +
| 1
 +
|-
 +
|39
 +
| Azure Command-Line Interface
 +
| 1
 +
|-
 +
| 40
 +
| Azure Information Protection
 +
| 1
 +
|-
 +
| 41
 +
| D365 Customer Service
 +
| 1
 +
|-
 +
| 42
 +
| Edge
 +
| 1
 +
|-
 +
| 43
 +
| Microsoft Deployment Toolkit
 +
| 1
 +
|-
 +
| 44
 +
| Microsoft Purview
 +
| 1
 +
|-
 +
| 45
 +
| Microsoft Translator
 +
| 1
 +
|-
 +
| 46
 +
| Quick Assist (Remote Assistance Service)
 +
| 1
 +
|-
 +
| 47
 +
| Windows Defender
 +
| 1
 +
|-
 +
| 48
 +
| Tous
 +
| 1798
 +
 
 +
|}
  
==Attributions and Sources==
+
==Contactez-nous==
[[M365/Attributions|Attributions and Sources]]
+
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca Accessibilite.POSS (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]]
 

Latest revision as of 11:54, 22 November 2024

Click here to return to Accessible-M365

Template:TOC limit

Page Status[edit | edit source]

This page was last updated on November 29, 2024 and currently reflects the data of the November 2024 period.

Accessibility Issues Tracker[edit | edit source]

The SSC SBPO UX Accessibility Issues Tracker is available for download.

Overview[edit | edit source]

The SBPO M365 accessibility issues summary tables surface data and trends in relation to Government of Canada (GC) M365 accessibility issues. The two tables include the following key data labels:

SSC SBPO M365 Total Accessibility Issues Summary Table Definitions[edit | edit source]

  • Total M365 Accessibility Issues: The total number of M365 accessibility issues tracked by SSC SBPO.
  • Total Active Accessibility Issues: The total number of active (Investigation is underway) M365 accessibility issues.
  • Total Pending M365 Accessibility Issues: The total number of M365 accessibility issues currently subject to a workload backlog.
  • 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.

M365 Total Accessibility Issues Summary Table[edit | edit source]

# Issues Summary Number of Reported Issues
1 Total M365 Accessibility Issues 1798
2 Total Active Accessibility Issues 213
3 Total Pending Accessibility Issues 297
4 Total Closed Accessibility Issues 1253

Accessibility Issues by M365 Application Summary Table[edit | edit source]

  • The total number of issues by M365 product or application, such as MS Teams or SharePoint, among others.

Accessibility Issues by M365 Application Summary Table[edit | edit source]

# Affected M365 Application Number of Reported Issues
1 Dynamics 403
2 SharePoint 403
3 Power Apps 223
4 Teams 146
5 Forms 111
6 Power BI 95
7 Planner 53
8 My Sign-ins 48
9 Word 41
10 Delve 36
11 *Not product specific 30
12 SQL Server 22
13 Office 365 18
14 One Drive 18
15 Outlook 15
16 OneNote 13
17 Yammer 12
18 Excel 10
19 PowerPoint 10
20 Sway 10
21 Whiteboard 10
22 Azure Dev Ops 9
23 Authenticator 8
24 *Not Listed 5
25 Viva Insights 5
26 Microsoft 365 4
27 Office - General 4
28 Viva Learning 4
29 Windows 4
30 Windows 11 4
31 *All Products 3
32 Bookings 3
33 IAM - Self Service Credentials Management Service 2
34 Microsoft Lists 2
35 Viva Engage 2
36 *All Digital Products 1
37 Accessibility Insights 1
38 Azure Active Directory 1
39 Azure Command-Line Interface 1
40 Azure Information Protection 1
41 D365 Customer Voice 1
42 Edge 1
43 Microsoft Deployment Toolkit 1
44 Microsoft Purview 1
45 Microsoft Translator 1
46 Quick Assist (Remote Assistance Service) 1
47 Windows Defender 1
48 All 1798

Contact Us[edit | edit source]

SBPO.Accessibility (SSC), dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca

Click here to return to Accessible-M365