Difference between revisions of "M365/Home/Excel"

From wiki
< M365‎ | Home
Jump to navigation Jump to search
Line 30: Line 30:
 
|+
 
|+
 
! rowspan="5" | [[Image:1._Excel_-_IG_-_BIL.PNG|245px|link=https://support.office.com/en-us/article/great-ways-to-work-with-office-6fe70269-b9a4-4ef0-a96e-7a5858b3bd5a?wt.mc_id=otc_home]]
 
! rowspan="5" | [[Image:1._Excel_-_IG_-_BIL.PNG|245px|link=https://support.office.com/en-us/article/great-ways-to-work-with-office-6fe70269-b9a4-4ef0-a96e-7a5858b3bd5a?wt.mc_id=otc_home]]
| <br>
+
| rowspan="5" | <br>
 
| [https://go.microsoft.com/fwlink/?linkid=2106614 8 secrets in Excel]
 
| [https://go.microsoft.com/fwlink/?linkid=2106614 8 secrets in Excel]
 
|-
 
|-
|
 
 
| [https://go.microsoft.com/fwlink/?linkid=2110003 7 most-used Excel functions]
 
| [https://go.microsoft.com/fwlink/?linkid=2110003 7 most-used Excel functions]
 
|-
 
|-
|
 
 
| [https://go.microsoft.com/fwlink/?linkid=2110101 5 charts in Excel]
 
| [https://go.microsoft.com/fwlink/?linkid=2110101 5 charts in Excel]
 
|-
 
|-
|
 
 
| [https://go.microsoft.com/fwlink/?linkid=2008987 50 time-saving Excel shortcuts]
 
| [https://go.microsoft.com/fwlink/?linkid=2008987 50 time-saving Excel shortcuts]
 
|-
 
|-
|
 
 
| [https://go.microsoft.com/fwlink/?linkid=2052032 50 Excel shortcuts for Mac]
 
| [https://go.microsoft.com/fwlink/?linkid=2052032 50 Excel shortcuts for Mac]
 
|}
 
|}

Revision as of 20:56, 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

1. Excel - IG - BIL.PNG
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
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.