Revision as of 10:14, 29 March 2023

Excel - Training Materials

Below is a collection of Excel training products to support public servants. Click on one of the following resources or feel free to add your own.

Articles and other Documents

Departmental Resources

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. Click here to add your own.

Quick Guides

For Windows		For Mac

Infographics

Work smarter in Excel (Microsoft)

Videos (Beginners)

Create a workbook in Excel		Create a new workbook		Formulas in Excel

Videos (Advanced)

Create and format tables		Create a chart		Create a PivotTable to analyze data

Templates

Formula tutorial		Make a PivotTable		Get more out of PivotTables

Discussion Board

Do you have a question about Excel? Simply click here to join the community and get started.

Contact Us

M365 Training Feedback

@@ Line 1: / Line 1: @@
 __NOTOC__
-<!-- Comment out this code when you want to edit the page -->
+=Excel - Training Materials=
+Below is a collection of Excel training products to support public servants. Click on one of the following resources or feel free to add your own.
-<!-- __NOEDITSECTION__ -->
+==Articles and other Documents==
-=Microsoft Teams - Matériel de formation=
+* [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]
-Les matériels de formation ci-dessous sont une collection de produits de formation des équipes des États membres pour soutenir les fonctionnaires. Cliquez sur l'une des ressources suivantes ou n'hésitez pas à ajouter la vôtre.
+* [https://support.office.com/en-us/article/move-or-copy-cells-and-cell-contents-803d65eb-6a3e-4534-8c6f-ff12d1c4139e?wt.mc_id=otc_excel Cells]
+* [https://support.office.com/en-us/article/available-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2?wt.mc_id=otc_excel Formatting]
+* [https://support.office.com/en-us/article/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173?wt.mc_id=otc_excel Formulas & functions]
+* [https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664?wt.mc_id=otc_excel Tables]
+* [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]
+* [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]
+* [https://support.office.com/en-us/article/share-your-excel-workbook-with-others-8d8a52bb-03c3-4933-ab6c-330aabf1e589?wt.mc_id=otc_excel Share & co-author]
-'''Remarque : Certaines de ces ressources ne sont disponibles qu'en anglais'''
+==Departmental Resources==
+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/Home/Excel/Departmental_Resources|'''Click here to add your own.''']]
+==Quick Guides==
+{|
+|-
+| {{M365_Guides_Excel_EN}}
+|}
-==Formation virtuelle==
+==Infographics==
-[[Image:Virtual_TrainingF.PNG|alt="Formation virtuelle"|Formation virtuelle|100px|link=https://wiki.gccollab.ca/M365/Accueil/Formation]]
+{{M365_Info_Excel_EN}}
-==Ressources ministérielles==
+==Videos (Beginners)==
-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/Accueil/Teams/Ressources_Ministérielle|'''Cliquez ici pour voir les ressources des autres ministères ou pour ajouter les vôtres.''']]
+{|
+|-
+| '''Create a workbook in Excel''' |||| '''Create a new workbook''' |||| '''Formulas in Excel'''
+|-
+| [[Image:1._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWeorM?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]]  ||[[Image:Blank.png|30px]]|| [[Image:2._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfBN5?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]|| [[Image:3._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfjs9?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]]
+|}
-==Ressources supplémentaires==
+==Videos (Advanced)==
-'''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.
+{|
+|-
+| '''Create and format tables''' |||| '''Create a chart'''||||'''Create a PivotTable to analyze data'''
+|-
+| [[Image:4._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfBNc?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]|| [[Image:5._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfod9?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]||[[Image:6._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfyHX?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]]
+|}
-*[https://support.microsoft.com/fr-fr/office/formation-vid%C3%A9o-microsoft-teams-4f108e54-240b-4351-8084-b1089f0d21d7 Formation vidéo Microsoft Teams (Microsoft)]
+==Templates==
-*[https://support.microsoft.com/fr-fr/teams Aide & apprentissage de Microsoft Teams (Microsoft)]
+{|
-*[https://teamsdemo.office.com/ Démonstration interactive (Microsoft)] - disponible uniquement en anglais
+|-
+| '''Formula tutorial''' |||| '''Make a PivotTable''' |||| '''Get more out of PivotTables'''
+|-
+| [[Image:7._Excel_video_-_EN.PNG|235px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16400656.xltx]]  ||[[Image:Blank.png|30px]]|| [[Image:8._Excel_video_-_EN.PNG|235px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16400647.xltx]] ||[[Image:Blank.png|30px]]|| [[Image:9._Excel_video_-_EN.PNG|235px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16410255.xltx]]
+|}
-===Articles===
+==Discussion Board==
-*[https://support.office.com/fr-fr/article/se-connecter-et-commencer-%c3%a0-utiliser-teams-6723dc43-dbc0-46e6-af49-8a2d1c5cb937?ui=fr-FR&rs=fr-FR&ad=FR Se connecter et commencer à utiliser Teams (Microsoft)]
+Do you have a question about Excel? Simply [https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat '''click here'''] to join the community and get started.
-*[https://support.office.com/fr-fr/article/discuter-et-partager-des-fichiers-dans-teams-d7978db0-33b5-4ad3-93ac-ef0bd3c2a670?ui=fr-FR&rs=fr-FR&ad=FR Discuter et partager des fichiers dans Teams (Microsoft)]
-*[https://support.office.com/fr-fr/article/collaborer-dans-teams-31e38b35-96ab-447a-acb2-97bb5c0716c0?ui=fr-FR&rs=fr-FR&ad=FR Collaborer dans Teams (Microsoft)]
-*[https://support.office.com/fr-fr/article/configurer-vos-applications-mobiles-teams-1ba8dce3-1122-47f4-8db6-00a4f93117e8?ui=fr-FR&rs=fr-FR&ad=FR Configurer vos applications mobiles Teams (Microsoft)]
-*[https://support.office.com/fr-fr/article/en-savoir-plus-sur-teams-f87289ef-3c5a-4b8e-aaed-6eb99e51ade7?ui=fr-FR&rs=fr-FR&ad=FR En savoir plus sur Teams (Microsoft)]
-*[https://support.microsoft.com/fr-fr/office/utiliser-les-sous-titres-en-direct-dans-une-r%C3%A9union-teams-4be2d304-f675-4b57-8347-cbd000a21260 Utiliser les sous-titres en direct dans une réunion Teams (Microsoft)]
-*[https://support.microsoft.com/fr-fr/office/prise-en-main-des-%C3%A9v%C3%A9nements-en-direct-microsoft-teams-d077fec2-a058-483e-9ab5-1494afda578a?ui=fr-fr&rs=fr-fr&ad=fr Prise en main des événements en direct Microsoft Teams (Microsoft)]
-===Vidéos===
+==Contact Us==
-*[https://support.microsoft.com/fr-fr/office/vid%C3%A9o-qu-est-ce-que-microsoft-teams-422bf3aa-9ae8-46f1-83a2-e65720e1a34d?wt.mc_id=otc_microsoft_teams# Qu’est-ce que Microsoft Teams ? (Microsoft)]
+[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Home/Excel M365 Training Feedback]
-*[https://support.microsoft.com/fr-fr/topic/communiquez-ou-d%C3%A9marrez-une-r%C3%A9union-en-utilisant-teams-34dd1c2a-8921-45a5-a22e-60ac515039ce Bienvenue dans Microsoft Teams (Microsoft)]
-*[https://www.youtube.com/playlist?list=PLXPr7gfUMmKyjYYCcNx4Q4Pik9js8XoBu Formation Microsoft Teams - francais (Youtube)] , [https://www.youtube.com/playlist?list=PLXPr7gfUMmKzR7_jXN5s886apYoHNC3Xk Formation Microsoft Teams - anglais (Youtube)] - disponible uniquement en anglais
-*[https://www.microsoft.com/fr-fr/videoplayer/embed/RE2MpH5?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=fr-fr Organiser votre liste d'équipes (Microsoft)]
-*[https://www.microsoft.com/fr-fr/videoplayer/embed/RE2Mswk?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=fr-fr Attirez l’attention avec @mention (Microsoft)]
-*[https://www.microsoft.com/fr-fr/videoplayer/embed/RE2Mswl?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=fr-fr Transformer un fichier en onglet (Microsoft)]
-===Parcours d'apprentissage===
-*[https://docs.microsoft.com/fr-fr/learn/browse/?products=m365&resource_type=module&term=Teams Cliquez ici pour trouver plus de 20 modules de parcours d'apprentissage (Microsoft).]
-*[https://learn.microsoft.com/fr-ca/training/modules/manage-meetings-virtual-events-experiences/ Gérer les réunions et les événements (Microsoft)]
-*[https://learn.microsoft.com/fr-ca/microsoft-365/business-premium/create-teams-for-collaboration?view=o365-worldwide&viewFallbackFrom=o365-worldwide%2F Gérer la collaboration en équipe (Microsoft)]
-===Forum de discussion===
-Si vous avez une question sur Teams, il vous suffit de [https://techcommunity.microsoft.com/t5/microsoft-teams/ct-p/MicrosoftTeams '''cliquer ici pour rejoindre la collectivité, Microsoft Teams Community Hub'''] - disponible unique en anglais
-==Contactez-nous==
-[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=Rétroaction%20sur%20la%20formation%20M365&body=https://wiki.gccollab.ca/M365/Accueil/Teams Rétroaction sur la formation M365]
 <br>
 <br>
 [[Category:M365]]
-[[Category:MS Teams]]
+[[Category:MS Excel]]
-[[Category:Formation]]
+[[Category:Training]]
 [[Category:Microsoft]]

Difference between revisions of "M365/test5"