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>}} |
− | [[Image:MS365_Banner_-_Excel.png|920px]]
| + | '''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.'' |
− | __NOTOC__
| |
− | __NOEDITSECTION__
| |
− | [[FR:M365/Accueil/Excel]]
| |
− | {{MS_icons_EN}}
| |
− | =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==
| + | '''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.'' |
− | * []
| |
− | * []
| |
| | | |
| + | <multilang> |
| + | <!-- 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}} |
| + | {{Excel_EN}} |
| | | |
− | ==Recorded Webinars==
| + | <!-- 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]] |
− | | '''Title''' ||
| + | {{MS_icons_FR}} |
− | |-
| + | {{Excel_FR}} |
− | | [[Image:|245px|link=]]
| + | </multilang> |
− | |}
| |
− | | |
− | ==Upcoming Instructor-led Learning Events==
| |
− | | |
− | * []
| |
− | * []
| |
− | | |
− | | |
− | ==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 PowerBI? Simply [https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat '''click here'''] to join the community and get started.
| |
− | | |
| | | |
− | <br> | + | <!-- Templates used on this page --> |
− | <br> | + | <!-- English: https://wiki.gccollab.ca/Template:Excel_EN --> |
| + | <!-- French: https://wiki.gccollab.ca/Template:Excel_FR ---> |