Difference between revisions of "M365/Home/Excel"

From wiki
< M365‎ | Home
Jump to navigation Jump to search
 
(38 intermediate revisions by 2 users not shown)
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 --->

Latest revision as of 09:00, 1 June 2023

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.

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.

"M365 Home"

"Teams" "Word" "PowerPoint" "Excel" "SharePoint" "OneNote" "Outlook" "OneDrive" "Planner" "Power BI" "Power Automate" "Power Apps"


Excel - Training Materials

Below is a collection of Microsoft 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.

Infographics

Discussion Board

Do you have a question about Excel? Simply click here to join the Microsoft Excel Community hub to join the community and get started.

Contact Us

M365 Training Feedback