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

Difference between revisions of "M365/test5"

From wiki
Jump to navigation Jump to search
Line 13: Line 13:
  
 
===Articles and other Documents===
 
===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/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]
* [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/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-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-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/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]
  
 
===Quick Guides===
 
===Quick Guides===

Revision as of 10:44, 29 March 2023

Excel - Training Materials

Below is a collection of Excel training products to support public servants.

Virtual Training

"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.

Articles and other Documents

  1. Rows & columns
  2. Cells
  3. Formatting
  4. Formulas & functions
  5. Tables
  6. Charts
  7. PivotTables
  8. Share & co-author

Quick Guides

For Windows For Mac
1. Excel - Guide - EN.PNG Blank.png 1. Excel - Guide Mac - EN.PNG

Infographics

Videos (Beginners)

  1. Create a workbook in Excel
  2. Create a new workbook
  3. Formulas in Excel
  4. Create and format tables
  5. Create a chart] |
  6. Create a PivotTable to analyze data

Templates

  1. Formula tutorial]
  2. Make a PivotTable]
  3. 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