Difference between revisions of "M365/test3"

From wiki
Jump to navigation Jump to search
 
(12 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]]
 
  
==Departmental Resources==
+
This page was last updated on '''April 30, 2024''' and currently reflects the data of the '''April 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 two 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'''
 +
| 1466
 +
|-
 +
| 2
 +
| 'Total '''Active''' Accessibility Issues
 +
| 109
 +
|-
 +
| 3
 +
| Total '''Pending''' Accessibility Issues
 +
| 272
 +
|-
 +
| 4
 +
| Total '''Closed''' Accessibility Issues
 +
| 1085
 +
|}
  
* [https://support.microsoft.com/en-us/office/video-start-with-an-accessible-excel-template-918db751-1585-41c5-9ddf-5d7a0915afaf Create accessible Excel workbooks (Microsoft)]
+
== Accessibility Issues by M365 Application Summary Table ==
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Affected M365 Application
 +
! Number of Reported Issues
 +
|- 
 +
| 1
 +
| SharePoint
 +
| 383
 +
|- 
 +
| 2
 +
| Dynamics
 +
| 240
 +
|-
 +
| 3
 +
| Power Apps
 +
| 194
 +
|-
 +
| 4
 +
| Teams
 +
| 115
 +
|- 
 +
| 5
 +
|  Forms
 +
| 108
 +
|- 
 +
| 6
 +
| Power BI
 +
| 92
 +
|-
 +
| 7
 +
| Planner
 +
| 53
 +
|-
 +
| 8
 +
| My Sign-ins
 +
| 50
 +
|- 
 +
| 9
 +
| Delve
 +
| 36
 +
|- 
 +
| 10
 +
| Word
 +
| 24
 +
|-
 +
| 11
 +
| SQL Server
 +
| 22
 +
|-
 +
| 12
 +
| Office 365
 +
| 18
 +
|-
 +
| 13
 +
| OneDrive
 +
| 18
 +
|-
 +
| 14
 +
|  Outlook
 +
| 13
 +
|-
 +
| 15
 +
| *Not Product-specific
 +
| 11
 +
|-
 +
| 16
 +
| OneNote
 +
| 10
 +
|-
 +
| 17
 +
| Sway
 +
| 10
 +
|-
 +
| 18
 +
| Whiteboard
 +
| 10
 +
|-
 +
| 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
 +
| Viva Insights
 +
| 2
 +
|-   
 +
| 31
 +
| *Tous les produits
 +
| 1
 +
|- 
 +
| 32
 +
| Accessibility Insights
 +
| 1
 +
|-
 +
| 33
 +
| Azure Active Directory
 +
| 1
 +
|- 
 +
| 34
 +
| Azure Information Protection
 +
| 1
 +
|-
 +
| 35
 +
| D365 Customer Voice
 +
| 1
 +
|-
 +
| 36
 +
| Sécurité et conformité M365
 +
| 1
 +
|-
 +
| 37
 +
| Microsoft Deployment Toolkit
 +
| 1
 +
|-
 +
| 38
 +
| Microsoft Translator
 +
| 1
 +
|-
 +
|39
 +
| Quick Assist (Remote Assistance Service)
 +
| 1
 +
|-
 +
| 40
 +
| Windows Defender
 +
| 1
 +
|-
 +
| 41
 +
| All
 +
| 1466
 +
|}
  
* Improve accessibility with the Accessibility Checker (Microsoft)
 
::[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)]
+
<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.
  
===Infographics===
+
==Contact Us==
{{M365_Info_Excel_EN}}
 
  
===Communities===
+
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca DCC.Accessibility (SSC), dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca]
*[[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)]
 
  
==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==
+
<u>[https://www.gcpedia.gc.ca/wiki/Accessible-M365# Click here to return to Accessible-M365]</u>
[[M365/Attributions|Attributions and Sources]]
+
 
 +
@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 '''30 avril 2024''' et reflète actuellement les données de la période de '''avril 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 deux 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'''
 +
| 1466
 +
|-
 +
| 2
 +
| '''Total des problèmes d'accessibilités actifs'''
 +
| 109
 +
|- 
 +
| 3
 +
| '''Total des problèmes d'accessibilités En suspens'''
 +
| 272
 +
|- 
 +
| 4
 +
| '''Total des problèmes d'accessibilité fermés'''
 +
| 1085
 +
|}
 +
 
 +
== Tableau récapitulatif des progrès du total des problèmes d'accessibilité de M365 ==
 +
 
 +
{| class='wikitable' border='1'
 +
|-
 +
!#
 +
! Affected M365 Application
 +
! Number of Reported Issues
 +
|- 
 +
| 1
 +
| SharePoint
 +
| 383
 +
|- 
 +
| 2
 +
| Dynamics
 +
| 240
 +
|-
 +
| 3
 +
| Power Apps
 +
| 194
 +
|-
 +
| 4
 +
| Teams
 +
| 115
 +
|- 
 +
| 5
 +
|  Forms
 +
| 108
 +
|- 
 +
| 6
 +
| Power BI
 +
| 92
 +
|-
 +
| 7
 +
| Planner
 +
| 53
 +
|-
 +
| 8
 +
| My Sign-ins
 +
| 50
 +
|- 
 +
| 9
 +
| Delve
 +
| 36
 +
|- 
 +
| 10
 +
| Word
 +
| 24
 +
|-
 +
| 11
 +
| SQL Server
 +
| 22
 +
|-
 +
| 12
 +
| Office 365
 +
| 18
 +
|-
 +
| 13
 +
| OneDrive
 +
| 18
 +
|-
 +
| 14
 +
|  Outlook
 +
| 13
 +
|-
 +
| 15
 +
| *Pas spécifique au produit
 +
| 11
 +
|-
 +
| 16
 +
| OneNote
 +
| 10
 +
|-
 +
| 17
 +
| Sway
 +
| 10
 +
|-
 +
| 18
 +
| Whiteboard
 +
| 10
 +
|-
 +
| 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
 +
| Viva Insights
 +
| 2
 +
|- 
 +
| 31
 +
| *Tous les produits
 +
| 1
 +
|- 
 +
| 32
 +
| Accessibility Insights
 +
| 1
 +
|-
 +
| 33
 +
| Azure Active Directory
 +
| 1
 +
|- 
 +
| 34
 +
| Azure Information Protection
 +
| 1
 +
|-
 +
| 35
 +
| D365 Customer Voice
 +
| 1
 +
|-
 +
| 36
 +
| Sécurité et conformité M365
 +
| 1
 +
|-
 +
| 37
 +
| Microsoft Deployment Toolkit
 +
| 1
 +
|-
 +
| 38
 +
| Microsoft Translator
 +
| 1
 +
|-
 +
|39
 +
| Assistance rapide (Outil d’assistance à distance)
 +
| 1
 +
|-
 +
| 40
 +
| Windows Defender
 +
| 1
 +
|-
 +
| 41
 +
| All
 +
| 1466
 +
|}
 +
 
 +
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]]
 

Latest revision as of 07:53, 30 April 2024

Click here to return to Accessible-M365

Template:TOC limit

Page Status[edit | edit source]

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

Overview[edit | edit source]

The DCC 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 DCC M365 Total Accessibility Issues Summary Table Definitions[edit | edit source]

  • Total M365 Accessibility Issues: The total number of M365 accessibility issues tracked by SSC DCC.
  • 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.

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.

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

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

# Issues Summary Number of Reported Issues
1 Total M365 Accessibility Issues 1466
2 'Total Active Accessibility Issues 109
3 Total Pending Accessibility Issues 272
4 Total Closed Accessibility Issues 1085

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

# Affected M365 Application Number of Reported Issues
1 SharePoint 383
2 Dynamics 240
3 Power Apps 194
4 Teams 115
5 Forms 108
6 Power BI 92
7 Planner 53
8 My Sign-ins 50
9 Delve 36
10 Word 24
11 SQL Server 22
12 Office 365 18
13 OneDrive 18
14 Outlook 13
15 *Not Product-specific 11
16 OneNote 10
17 Sway 10
18 Whiteboard 10
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 Viva Insights 2
31 *Tous les produits 1
32 Accessibility Insights 1
33 Azure Active Directory 1
34 Azure Information Protection 1
35 D365 Customer Voice 1
36 Sécurité et conformité M365 1
37 Microsoft Deployment Toolkit 1
38 Microsoft Translator 1
39 Quick Assist (Remote Assistance Service) 1
40 Windows Defender 1
41 All 1466



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[edit | edit source]

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


Click here to return to Accessible-M365