6,010
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
<!-- This template is used on https://wiki.gccollab.ca/M365/Excel, Do NOT delete. -->
=Excel - Training Materials=
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]]
==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/Resources-Ressources|'''Click here to see other Departments' Resources or to add your own.''']]
==Additional Resources==
'''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)]
*[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)]
===Accessibility===
* [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)]
* Make your Excel documents accessible to people with disabilities (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/video-start-with-an-accessible-excel-template-918db751-1585-41c5-9ddf-5d7a0915afaf Create accessible Excel workbooks (Microsoft)]
* 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)]
===Infographics===
{{M365_Info_Excel_EN}}
===Communities===
*[[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==
[[M365/Attributions|Attributions and Sources]]
[[Category:M365]]
[[Category:MS Excel]]
[[Category:Training]]
[[Category:Microsoft]]
