Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!
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] | ||
| + | |||
| + | ==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]] | | [[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== | ==Infographics== | ||
| Line 41: | Line 44: | ||
| [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 58: | 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 66: | Line 71: | ||
| [[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 11:01, 10 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
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.
