Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!

Changes

Jump to navigation Jump to search
77 bytes removed ,  11:25, 30 March 2023
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===

Navigation menu

GCwiki