Difference between revisions of "M365/Home/Excel"
Jump to navigation
Jump to search
| Line 19: | Line 19: | ||
* [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] | * [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/Word/Departmental_Resources|'''Click here to add your own.''']] | ||
| + | |||
==Quick Guides== | ==Quick Guides== | ||
{| | {| | ||
| Line 44: | Line 46: | ||
| [https://go.microsoft.com/fwlink/?linkid=2052032 50 Excel shortcuts for Mac] | | [https://go.microsoft.com/fwlink/?linkid=2052032 50 Excel shortcuts for Mac] | ||
|} | |} | ||
| − | |||
==Videos (Beginners)== | ==Videos (Beginners)== | ||
| − | |||
{| | {| | ||
|- | |- | ||
| Line 54: | Line 54: | ||
| [[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]] | | [[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)== | ==Videos (Intermediate)== | ||
| Line 63: | Line 62: | ||
| [[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]] | | [[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== | ==Templates== | ||
| Line 72: | Line 70: | ||
| [[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]] | | [[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== | ==Discussion Board== | ||
Revision as of 20:08, 22 April 2020
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
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 add your own.
Quick Guides
| For Windows | For Mac | |
 |
 |
|
Infographics
|
|
8 secrets in Excel |
|---|---|---|
| 7 most-used Excel functions | ||
| 5 charts in Excel | ||
| 50 time-saving Excel shortcuts | ||
| 50 Excel shortcuts for Mac |
Videos (Beginners)
| Create a workbook in Excel | Create a new workbook | Formulas in Excel | ||
 |
|
 |
|
|
Videos (Intermediate)
| Create and format tables | Create a chart | Create a PivotTable to analyze data | ||
 |
|
 |
|
|
Templates
| Formula tutorial | Make a PivotTable | Get more out of PivotTables | ||
 |
|
 |
|
|
Discussion Board
Do you have a question about Excel? Simply click here to join the community and get started.
