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/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.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] |
− | ===Articles and other Documents===
| |
− | #[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]] |
| | | |
− | ===Videos (Beginners)=== | + | ===Infographics=== |
− | # [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]
| |
− | | |
− | ===Templates===
| |
− | # [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=== |