|
|
| Line 1: |
Line 1: |
| − | {{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}}
| + | <multilang> |
| | | | |
| − | [[Image:MS365_Banner_-_Excel.png|920px|https://wiki.gccollab.ca/M365/Home]]
| + | <!-- English section starts here --> |
| − | __NOTOC__
| + | @en| |
| | + | <!-- English template --> |
| | + | {{Excel_EN}} |
| | | | |
| − | [[FR:M365/Accueil/Excel]]
| + | <!-- French section starts here --> |
| | + | @fr| |
| | + | <!-- French template --> |
| | + | {{Excel_FR}} |
| | + | </multilang> |
| | | | |
| − | {{MS_icons_EN}}
| + | <!-- Templates used on this page --> |
| − | | + | <!-- English: https://wiki.gccollab.ca/Template:Excel_EN --> |
| − | [[M365/Accueil/Excel|<u>Cliquez ici pour consulter la version française de cette page.</u>]]
| + | <!-- French: https://wiki.gccollab.ca/Template:Excel_FR ---> |
| − | | |
| − | =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.
| |
| − | | |
| − | ==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/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]
| |
| − | | |
| − | ==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.''']]
| |
| − |
| |
| − | ==Quick Guides==
| |
| − | {|
| |
| − | |-
| |
| − | | {{M365_Guides_Excel_EN}}
| |
| − | |}
| |
| − | | |
| − | ==Infographics==
| |
| − | {{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]]
| |
| − | |}
| |
| − | | |
| − | ==Videos (Advanced)==
| |
| − | {|
| |
| − | |-
| |
| − | | '''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]]
| |
| − | |}
| |
| − | | |
| − | ==Templates==
| |
| − | {|
| |
| − | |-
| |
| − | | '''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]]
| |
| − | |}
| |
| − | | |
| − | ==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==
| |
| − | [mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/Home/Excel M365 Training Feedback]
| |
| − | | |
| − | | |
| − | <br>
| |
| − | <br>
| |
| − | [[Category:M365]]
| |
| − | [[Category:MS Excel]]
| |
| − | [[Category:Training]]
| |
| − | [[Category:Microsoft]]
| |
