Difference between revisions of "M365/Home/Excel"

From wiki
< M365‎ | Home
Jump to navigation Jump to search
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]]  
 
[[Image:MS365_Banner_-_Excel.png|920px]]  
 
__NOTOC__
 
__NOTOC__
Line 31: Line 32:
 
| '''Title''' ||
 
| '''Title''' ||
 
|-
 
|-
| [[Image:|245px|link=]]
+
|<nowiki> [[Image:|245px|link=]]</nowiki>
 +
|
 
|}
 
|}
  
 
+
{| class="wikitable"
 +
|+
 +
! rowspan="5" |
 +
!
 +
|-
 +
|
 +
|-
 +
|
 +
|-
 +
!
 +
|-
 +
|
 +
|}
  
 
==Videos (Beginners)==
 
==Videos (Beginners)==
Line 44: Line 58:
 
| [[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)==

Revision as of 21:48, 9 April 2020


MS365 Banner - Excel.png "Teams" "Word" "PowerPoint" "Excel" "SharePoint" "OneNote" "Outlook" "OneDrive" "Planner" "Power BI" "Power Automate" "Power Apps"

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 Guide (Windows) Quick Guide (Mac)
1. Excel - Guide - EN.PNG Blank.png 1. Excel - Guide Mac - EN.PNG

Infographics

Title
[[Image:|245px|link=]]

Videos (Beginners)

Create a workbook in Excel Create a new workbook Formulas in Excel
1. Excel video - EN.PNG Blank.png 2. Excel video - EN.PNG Blank.png 3. Excel video - EN.PNG

Videos (Intermediate)

Create and format tables Create a chart Create a PivotTable to analyze data
4. Excel video - EN.PNG Blank.png 5. Excel video - EN.PNG Blank.png 6. Excel video - EN.PNG

Templates

Formula tutorial Make a PivotTable Get more out of PivotTables
7. Excel video - EN.PNG Blank.png 8. Excel video - EN.PNG Blank.png 9. Excel video - EN.PNG

Discussion Board

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