6,010
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + − * [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/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/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-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] − + − − ==Quick Guides== − {| − |- − | {{M365_Guides_Excel_EN}} − |} − + − {{M365_Info_Excel_EN}}+ − ==Videos (Beginners)==+ − {|+ − |-+ − | '''Create a workbook in Excel''' |||| '''Create a new workbook''' |||| '''Formulas in Excel'''+ − |-+ − | [[Image:1._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWeorM?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]|| [[Image:2._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfBN5?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]|| [[Image:3._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfjs9?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]]+ − |}+ + + + − + − {|+ − |- − | '''Create and format tables''' |||| '''Create a chart'''||||'''Create a PivotTable to analyze data''' − |- − | [[Image:4._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfBNc?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]|| [[Image:5._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfod9?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] ||[[Image:Blank.png|30px]]||[[Image:6._Excel_video_-_EN.PNG|245px|link=https://www.microsoft.com/en-us/videoplayer/embed/RWfyHX?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us]] − |} − + − {|+ − |- − | '''Formula tutorial''' |||| '''Make a PivotTable''' |||| '''Get more out of PivotTables''' − |- − | [[Image:7._Excel_video_-_EN.PNG|235px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16400656.xltx]] ||[[Image:Blank.png|30px]]|| [[Image:8._Excel_video_-_EN.PNG|235px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16400647.xltx]] ||[[Image:Blank.png|30px]]|| [[Image:9._Excel_video_-_EN.PNG|235px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16410255.xltx]] − |} − − − − − − <br> − <br>
no edit summary
__NOTOC__
__NOTOC__
__NOEDITSECTION__
=Excel - Training Materials=
=Excel - Training Materials=
Below is a collection of Excel training products to support public servants. Click on one of the following resources or feel free to add your own.
Below is a collection of Microsoft Excel training products to support public servants.
==Articles and other Documents==
==Virtual Training==
[[Image:Virtual_Training.PNG|alt="Virtual Training"|Virtual Training|100px|link=https://wiki.gccollab.ca/M365/Home/Training]]
==Departmental Resources==
==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/Home/Excel/Departmental_Resources|'''Click here to add your own.''']]
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/Home/Excel/Departmental_Resources|'''Click here to see other Departments' Resources or to add your own.''']]
==Infographics==
==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)]
==Videos (Advanced)==
===Infographics===
{{M365_Info_Excel_EN}}
==Templates==
===Discussion Board===
Do you have a question about Excel? Simply [https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat '''click here to join the Microsoft Excel Community hub'''] to join the community and get started.
==Discussion Board==
Do you have a question about Excel? Simply [https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat '''click here'''] to join the community and get started.
==Contact Us==
==Contact Us==
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Home/Excel M365 Training Feedback]
[mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Home/Excel M365 Training Feedback]
[[Category:M365]]
[[Category:M365]]
[[Category:MS Excel]]
[[Category:MS Excel]]
[[Category:Training]]
[[Category:Training]]
[[Category:Microsoft]]
[[Category:Microsoft]]
