Difference between revisions of "M365/Home/Excel"
Jump to navigation
Jump to search
| Line 32: | Line 32: | ||
{| | {| | ||
|- | |- | ||
| − | | ''' | + | | '''Create a workbook in Excel''' |||| '''Create a new workbook''' |||| '''Formulas in Excel''' |
|- | |- | ||
| − | | [[Image:|245px|link=]] ||[[Image:Blank.png|30px]]|| [[Image:|245px|link=]] ||[[Image:Blank.png|30px]]|| [[Image:|245px|link=]] | + | | [[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]] |
|} | |} | ||
| Line 41: | Line 41: | ||
{| | {| | ||
|- | |- | ||
| − | | ''' | + | | '''Create and format tables''' |||| '''Create a chart'''||||'''Create a PivotTable to analyze data''' |
|- | |- | ||
| − | | [[Image:|245px|link=]] ||[[Image:Blank.png|30px]]|| [[Image:|245px|link= | + | | [[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:|245px|link=]] ||[[Image:Blank.png|30px]]|| [[Image:|245px|link=]] ||[[Image:Blank.png|30px]]|| [[Image:|245px|link= | + | | [[Image:7._Excel_video_-_EN.PNG|245px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16400656.xltx]] ||[[Image:Blank.png|30px]]|| [[Image:8._Excel_video_-_EN.PNG|245px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16400647.xltx]] ||[[Image:Blank.png|30px]]|| [[Image:9._Excel_video_-_EN.PNG|245px|link=https://omextemplates.content.office.net/support/templates/en-us/tf16410255.xltx]] |
|} | |} | ||
| + | |||
| + | ==Discussion Board== | ||
| + | https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat | ||
<br> | <br> | ||
<br> | <br> | ||
Revision as of 21:42, 5 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
- []
- []
Recorded Webinars
| Title | |
| [[Image:|245px|link=]] |
Upcoming Instructor-led Learning Events
- []
- []
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
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat
