| Line 1: |
Line 1: |
| | {{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}} | | {{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}} |
| | + | '''Old Page Alert:''' ''Please note that you are currently on our old page. Our new and improved page can now be found at https://wiki.gccollab.ca/M365. Please update your bookmark.'' |
| | | | |
| − | [[Image:MS365_Banner_-_Excel.png|920px]] | + | '''Alerte à l’ancienne page :''' ''Veuillez noter que vous êtes actuellement sur notre ancienne page. Notre nouvelle page améliorée se trouve maintenant à https://wiki.gccollab.ca/M365. Veuillez mettre à jour votre signet.'' |
| − | __NOTOC__
| + | |
| − | __NOEDITSECTION__
| + | <multilang> |
| − | [[FR:M365/Accueil/Excel]]
| + | <!-- English section starts here --> |
| | + | @en| |
| | + | <!-- English template --> |
| | + | [[Image:MS365_Banner_-_Excel.png|alt="M365 Home"|M365 Home|920px|link=https://wiki.gccollab.ca/M365/Home]] |
| | {{MS_icons_EN}} | | {{MS_icons_EN}} |
| − | =Excel - Training Materials=
| + | {{Excel_EN}} |
| − | 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]
| |
| − | | |
| − | | |
| − | ==Quick Guides==
| |
| − | {| | |
| − | |-
| |
| − | | '''For Windows''' |||| '''For Mac'''
| |
| − | |-
| |
| − | | [[Image:1._Excel_-_Guide_-_EN.PNG|245px|link=http://download.microsoft.com/download/5/3/0/5303FC2D-E52C-41F9-A4E3-EC99D7D7019D/Excel%20QS.pdf]] ||[[Image:Blank.png|30px]]|| [[Image:1._Excel_-_Guide_Mac_-_EN.PNG|245px|link=https://download.microsoft.com/download/B/D/6/BD6ADCF5-9D12-44CF-BBB6-7903FDAF8870/EXCEL%202016%20FOR%20MAC%20QUICK%20START%20GUIDE.PDF]]
| |
| − | |}
| |
| − | | |
| − | | |
| − | ==Infographics==
| |
| − | {|
| |
| − | |+
| |
| − | ! rowspan="5" | [[Image:1._Excel_-_IG_-_BIL.PNG|245px|link=https://support.office.com/en-us/article/great-ways-to-work-with-office-6fe70269-b9a4-4ef0-a96e-7a5858b3bd5a?wt.mc_id=otc_home]]
| |
| − | | rowspan="5" | [[Image:Blank.png|10px|link=https://wiki.gccollab.ca/M365/Home/Excel]]
| |
| − | | [https://go.microsoft.com/fwlink/?linkid=2106614 8 secrets in Excel]
| |
| − | |-
| |
| − | | [https://go.microsoft.com/fwlink/?linkid=2110003 7 most-used Excel functions]
| |
| − | |-
| |
| − | | [https://go.microsoft.com/fwlink/?linkid=2110101 5 charts in Excel]
| |
| − | |-
| |
| − | | [https://go.microsoft.com/fwlink/?linkid=2008987 50 time-saving Excel shortcuts]
| |
| − | |-
| |
| − | | [https://go.microsoft.com/fwlink/?linkid=2052032 50 Excel shortcuts for Mac]
| |
| − | |}
| |
| − | | |
| − | | |
| − | ==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 (Intermediate)==
| |
| − | {| | |
| − | |-
| |
| − | | '''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.
| |
| | | | |
| | + | <!-- French section starts here --> |
| | + | @fr| |
| | + | <!-- French template --> |
| | + | [[Image:MS365_Banner_-_Excel.png|alt="Accueil M365"|Accueil M365|920px|link=https://wiki.gccollab.ca/M365/Accueil]] |
| | + | {{MS_icons_FR}} |
| | + | {{Excel_FR}} |
| | + | </multilang> |
| | | | |
| − | <br> | + | <!-- Templates used on this page --> |
| − | <br> | + | <!-- English: https://wiki.gccollab.ca/Template:Excel_EN --> |
| | + | <!-- French: https://wiki.gccollab.ca/Template:Excel_FR ---> |