Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!
Difference between revisions of "M365/test5"
Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
=Excel - Training Materials= | =Excel - Training Materials= | ||
− | Below is a collection of Excel training products to support public servants. | + | Below is a collection of Microsoft Excel training products to support public servants. |
==Virtual Training== | ==Virtual Training== | ||
Line 12: | Line 12: | ||
'''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. | '''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/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb Excel video training (Microsoft)] | |
− | + | #[https://support.microsoft.com/en-us/excel Excel help & learning (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] | |
− | |||
− | #[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] | ||
#[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/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/available-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2?wt.mc_id=otc_excel Formatting] | ||
Line 24: | Line 22: | ||
#[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/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] | #[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] | ||
+ | #[https://www.microsoft.com/en-us/videoplayer/embed/RWeorM?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Create a workbook in Excel] | ||
+ | #[https://www.microsoft.com/en-us/videoplayer/embed/RWfBN5?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Create a new workbook] | ||
+ | #[https://www.microsoft.com/en-us/videoplayer/embed/RWfjs9?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Formulas in Excel] | ||
+ | #[https://www.microsoft.com/en-us/videoplayer/embed/RWfBNc?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Create and format tables] | ||
+ | #[https://www.microsoft.com/en-us/videoplayer/embed/RWfod9?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Create a chart]] | | ||
+ | #[https://www.microsoft.com/en-us/videoplayer/embed/RWfyHX?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Create a PivotTable to analyze data] | ||
+ | # [https://omextemplates.content.office.net/support/templates/en-us/tf16400656.xltx Formula tutorial]] | ||
+ | #[https://omextemplates.content.office.net/support/templates/en-us/tf16400647.xltx Make a PivotTable]] | ||
+ | #[https://omextemplates.content.office.net/support/templates/en-us/tf16410255.xltx Get more out of PivotTables]] | ||
− | === | + | ===Infographics=== |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | * {{M365_Info_Excel_EN}} | |
− | {{M365_Info_Excel_EN}} | ||
===Discussion Board=== | ===Discussion Board=== |
Revision as of 11:25, 30 March 2023
Excel - Training Materials
Below is a collection of Microsoft Excel training products to support public servants.
Virtual Training
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 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.
- Excel video training (Microsoft)
- Excel help & learning (Microsoft)
- Rows & columns
- Cells
- Formatting
- Formulas & functions
- Tables
- Charts
- PivotTables
- Share & co-author
- Create a workbook in Excel
- Create a new workbook
- Formulas in Excel
- Create and format tables
- Create a chart] |
- Create a PivotTable to analyze data
- Formula tutorial]
- Make a PivotTable]
- Get more out of PivotTables]
Infographics
Discussion Board
Do you have a question about Excel? Simply click here to join the community and get started.