M365/Home/Excel

From wiki
< M365‎ | Home
Revision as of 17:52, 24 April 2020 by Jeffrey.outram (talk | contribs)
Jump to navigation Jump to search


https://wiki.gccollab.ca/M365/Home "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

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

Infographics

1. Excel - IG - BIL.PNG Blank.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 (Advanced)

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.