다음을 통해 공유

Office 365 Training Resources

  • 아티클

Introduction

This article provides a usefull list of training assets for Office 365 and Office 2016 for business and end users. 

​Training Overview

Below you find an overview of all the training assets.

Excel

Application_Service Title URL
Excel; OneDrive for Business Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
Excel; OneDrive for Business Me and my docs https://support.office.com/article/Me-and-my-docs-f4038601-67d7-465c-82be-11e15eac1bf8
Excel; OneDrive for Business Save a Workbook to OneDrive for Business https://support.office.com/article/Save-a-workbook-to-OneDrive-for-Business-981691f3-9f67-4fa9-b99f-e0cf2b224d95
Excel; OneDrive for Business Open an Excel spreadsheet on a tablet https://support.office.com/article/Open-an-Excel-spreadsheet-on-a-tablet-1abe822d-fa93-45d1-acee-f6e191b8c702
Excel; OneDrive for Business Edit an Excel spreadsheet on a tablet https://support.office.com/article/Edit-an-Excel-spreadsheet-on-a-tablet-01c80851-89a4-41a1-9b97-cf6f92c0e9fb
Excel; OneDrive for Business Edit an Excel spreadsheet on a smartphone https://support.office.com/article/Edit-an-Excel-spreadsheet-on-a-smartphone-dce82d15-9417-47a5-b8ea-89040d93a7ec
Excel; OneDrive for Business Share a spreadsheet in OneDrive for Business with teammates https://support.office.com/article/Share-a-spreadsheet-in-OneDrive-for-Business-with-teammates-e468b5e0-31a1-4ea3-be53-187bb6c2db2b
Excel; OneDrive for Business Co-edit a spreadsheet using Excel Online https://support.office.com/article/Co-edit-a-spreadsheet-using-Excel-Online-670344b7-2a09-46de-92fc-82df158762c2
OneDrive; PowerPoint; Word; Excel Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
OneDrive; PowerPoint; Word; Excel Work together seamlessly https://support.office.com/article/Work-together-seamlessly-27136232-e097-48da-9002-41812629d3d8
OneDrive; PowerPoint; Word; Excel Save a presentation to OneDrive for Business using your tablet https://support.office.com/article/Save-a-presentation-to-OneDrive-for-Business-using-your-tablet-38a8b931-5176-46a0-bff1-1e20bea4c66a
OneDrive; PowerPoint; Word; Excel Edit a presentation on a tablet https://support.office.com/article/Edit-a-presentation-on-a-tablet-f2cfd7ae-4bf0-4c41-a9ca-0dc3cc0b41ef
OneDrive; PowerPoint; Word; Excel Share a presentation with teammates https://support.office.com/article/Share-a-presentation-with-teammates-bff69294-17e9-4429-8753-afa9c349e169
OneDrive; PowerPoint; Word; Excel Collaborate on a presentation https://support.office.com/article/Collaborate-on-a-presentation-071d5ecf-f4c5-4727-bfd5-b33f7b433759
OneDrive; PowerPoint; Word; Excel Find and open a Word document on a tablet https://support.office.com/article/Find-and-open-a-Word-document-on-a-tablet-dfae0ec5-d5c3-41d3-93c6-03be47c609ff
OneDrive; PowerPoint; Word; Excel Copy a chart from Excel to a Word document on a tablet https://support.office.com/article/Copy-a-chart-from-Excel-to-a-Word-document-on-a-tablet-6a243031-3a71-4de8-8a60-70ecff29c8c5
OneDrive; PowerPoint; Word; Excel Share a folder in OneDrive for Business with teammates https://support.office.com/article/Share-a-folder-in-OneDrive-for-Business-with-teammates-2aff5b21-2586-4a80-af7d-6d6ec8ac48e7
OneDrive; PowerPoint; Word; Excel Co-edit a Word document with teammates https://support.office.com/article/Co-edit-a-Word-document-with-teammates-f4e988f8-95d5-425c-9e90-d50229ea43a9

Word

 Application_Service  Title  URL
OneDrive; Word Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
OneDrive; Word Anywhere access and file sharing with OneDrive for Business https://support.office.com/article/Anywhere-access-and-file-sharing-with-OneDrive-for-Business-376db1bc-1721-447b-be5d-ebd74238a87c
OneDrive; Word Create and save a file to OneDrive for Business https://support.office.com/article/Create-and-save-a-file-to-OneDrive-for-Business-b8b89a11-9a80-44e7-81a4-9bbbd8b30086
OneDrive; Word Take advantage of the Next Generation Sync Client https://support.office.com/article/Take-advantage-of-the-Next-Generation-Sync-Client-b17f764f-7dc6-4b34-91b4-0698c87619c7
OneDrive; Word Share the file internally and externally https://support.office.com/article/Share-the-file-internally-and-externally-b5806145-aa7c-4119-93fd-035d060ed15a
OneDrive; Word Coauthor in Word on the desktop https://support.office.com/article/Coauthor-in-Word-on-the-desktop-df921d50-ae67-4922-9867-10a4cc8b12bc
OneDrive; Word Coauthor in Word on a smartphone https://support.office.com/article/Coauthor-in-Word-on-a-smartphone-87e6816b-5192-4225-8178-deb65af5312c
OneDrive; Word Stop sharing a file https://support.office.com/article/Stop-sharing-a-file-01d7bdf1-3fce-4307-8157-df74a159693d
OneDrive; Word Set up a face-to-face meeting https://support.office.com/article/Set-up-a-face-to-face-meeting-76c9ead0-7fb4-41c3-b17b-57095c943726
OneDrive; Word Use the Version History feature of OneDrive for Business https://support.office.com/article/Use-the-Version-History-feature-of-OneDrive-for-Business-20f8a9eb-7b8c-477a-a909-ca32e74a52b0
OneDrive; Word Save a OneDrive for Business file to a team site https://support.office.com/article/Save-a-OneDrive-for-Business-file-to-a-team-site-b3036d7e-64e1-49ed-9317-6ffd38178661&ocmsassetID=b3036d7e-64e1-49ed-9317-6ffd38178661
OneDrive; Word Add final touches and distribute the file https://support.office.com/article/Add-final-touches-and-distribute-the-file-1958e801-e9de-4478-9c76-629a45b6c4cf

Sharepoint & OneNote

     
SharePoint; OneNote Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
SharePoint; OneNote Collaborate with team content using SharePoint Online https://support.office.com/article/Collaborate-with-team-content-using-SharePoint-Online-2dd9aeff-7749-4b78-9696-eb0f6267f1f5
SharePoint; OneNote Start designing your team site https://support.office.com/article/Start-designing-your-team-site-7b77c8cc-6131-47a9-9470-f39ec6027c07
SharePoint; OneNote Change the look and feel https://support.office.com/article/Change-the-look-and-feel-baff6052-436d-4065-953f-24612834fff5
SharePoint; OneNote Add a video and slide show to the home page https://support.office.com/article/Add-a-video-and-slide-show-to-the-home-page-370488f5-d439-44b7-a704-211aff690673
SharePoint; OneNote Use the OneNote notebook provided with the team site https://support.office.com/article/Use-the-OneNote-notebook-provided-with-the-team-site-39b34ba9-29f9-4035-a792-256e85df8f1a
SharePoint; OneNote Create a list to capture customer feedback https://support.office.com/article/Create-a-list-to-capture-customer-feedback-68b0aac3-6cb1-4203-adda-e0720059850a
SharePoint; OneNote Create a confidential document library https://support.office.com/article/Create-a-confidential-document-library-e0660483-3d95-4016-a2e9-5dc8d4ac139d
SharePoint; OneNote Share a site with external users https://support.office.com/article/Share-a-site-with-external-users-140714b0-a8e5-4bad-a0bd-1aff813510b0
SharePoint; OneNote Access your team site from a mobile device https://support.office.com/article/Access-your-team-site-from-a-mobile-device-6f2d23ba-d64f-48d5-ad31-f9aad964d23d

Outlook & Skype For Business

     
Skype for Business; Outlook Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
Skype for Business; Outlook Communicate your way https://support.office.com/article/Communicate-your-way-c50059a4-9114-4c81-8581-bd4fd6e97fc6
Skype for Business; Outlook Find a contact from Outlook https://support.office.com/article/Find-a-contact-from-Outlook-93681411-530c-40d3-b838-e8bfbf78bdc9
Skype for Business; Outlook IM a contact https://support.office.com/article/IM-a-contact-7b7416c2-e426-4308-b97d-78eb8e1990bd
Skype for Business; Outlook Add people and video to a conversation https://support.office.com/article/Add-people-and-video-to-a-conversation-286b8ee5-9fcd-4eb3-8e6c-4dd0f474c3c1
Skype for Business; Outlook Desktop sharing https://support.office.com/article/Desktop-sharing-2c09d629-b59f-4892-8bb9-f57414814ac3
Skype for Business; Outlook Schedule a follow-up Skype for Business meeting https://support.office.com/article/Schedule-a-follow-up-Skype-for-Business-meeting-6ab7f862-84bf-46da-80af-155174318b86
Skype for Business; OneNote; PowerPoint Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
Skype for Business; OneNote; PowerPoint Communicate your way https://support.office.com/article/Complete-meeting-solution-518a36ec-8b7d-4c12-a77a-f4a2c9f47e45
Skype for Business; OneNote; PowerPoint Join a meeting https://support.office.com/article/Join-a-meeting-92632d49-50c1-4ed1-80df-c3f7685209d8
Skype for Business; OneNote; PowerPoint Start taking notes in OneNote https://support.office.com/article/Start-taking-notes-in-OneNote-23c10a01-87ba-44a4-b413-9298f8b621bc
Skype for Business; OneNote; PowerPoint Record your Skype for Business meeting https://support.office.com/article/Record-your-Skype-for-Business-meeting-04e43eff-b188-4bb0-b23c-1b07974a8ba8
Skype for Business; OneNote; PowerPoint Communicate with voice and video https://support.office.com/article/Communicate-with-voice-and-video-c1fb68bb-fdfc-4bf5-af41-2ac88e9b6fb0
Skype for Business; OneNote; PowerPoint Invite more people https://support.office.com/article/Invite-more-people-b3c6cacb-8175-4c38-bcb2-1048f4a29670
Skype for Business; OneNote; PowerPoint Use desktop and app sharing https://support.office.com/article/Use-desktop-and-app-sharing-712965d0-fa10-4da0-86c2-66ec68d8dbc8
Skype for Business; OneNote; PowerPoint Present and annotate a PowerPoint deck that you are sharing https://support.office.com/article/Present-and-annotate-a-PowerPoint-deck-that-you-are-sharing-87bd02f5-e3e0-4b21-9b5b-61aa8c10cda8
Skype for Business; OneNote; PowerPoint Meeting follow up https://support.office.com/article/Meeting-follow-up-0d937221-6276-49f4-b7d3-fc9ed12455f6

Outlook

     
O365; Outlook Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
O365; Outlook Tame your email and calendar https://support.office.com/article/Tame-your-email-and-calendar-20e822dc-1c7a-4b3f-ab79-c00beb3f8e92
O365; Outlook Manage your Inbox https://support.office.com/article/Manage-your-Inbox-33b96e3d-94ea-4c23-b1fb-74fc7c9d480d
O365; Outlook Choose how to reply https://support.office.com/article/Choose-how-to-reply-f4041b2d-a283-41fb-b964-3874b9a944f2
O365; Outlook Smarter attachments https://support.office.com/article/Smarter-attachments-1640e4ed-5322-4145-8798-cbf16ca3773e
O365; Outlook Command your calendar https://support.office.com/article/Command-your-calendar-926bc197-3625-465b-bcc8-a5432e2daa06
O365; Outlook Find out who's available https://support.office.com/article/Find-out-who-s-available-096221a6-ab46-4f02-9006-658836d43810
O365; Outlook Unite your team with Groups https://support.office.com/article/Unite-your-team-with-Groups-in-Outlook-`aef27003-2ce6-4c62-ad6c-d5fc472507cf
O365; Outlook Get caught up with your team

https://support.office.com/article/Get-caught-up-with-your-team-60282443-1619-4f40-a271-11b42c04564a
O365; Outlook Communicate with your team https://support.office.com/article/Communicate-with-your-team-325b6790-e268-4c10-a192-379efdaa92ab
O365; Outlook Collaborate with your team https://support.office.com/article/Collaborate-with-your-team-d8618d5c-63af-4faa-b2cd-70747e2c7fb8
O365; Outlook Schedule with your team https://support.office.com/article/Schedule-with-your-team-5285b398-3361-429d-a78d-4c2290ceba36
O365; Outlook Organize your team's tasks https://support.office.com/article/Organize-your-team-s-tasks-df139af4-387d-460a-bb05-460e930ff273
O365; Outlook Get a new team member up to speed https://support.office.com/article/Get-a-new-team-member-up-to-speed-ded7bc51-7243-4af5-8a03-8d69c7fe278e

Yammer

     
Yammer Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
Yammer Roll out a successful Yammer network https://support.office.com/article/Roll-out-a-successful-Yammer-network-a19aedab-6dc8-44b1-a8c3-72c38abf18b4
Yammer What is Yammer https://support.office.com/article/What-is-Yammer-1b0f3b3e-89ee-4b66-aac5-30def12f287c
Yammer Personalize your Yammer Network https://support.office.com/article/Personalize-your-Yammer-network-bea38233-f248-4665-903f-558f731ea54c
Yammer Identify the right use cases for your organization https://support.office.com/article/Identify-the-right-use-cases-for-your-organization-af6075de-475a-4e8e-9d04-0da4b6014814
Yammer Create a group for each use case https://support.office.com/article/Create-a-group-for-each-use-case-7f0cf5d8-1f9d-48d2-a83c-d777578fa4a0
Yammer Grow your Yammer network https://support.office.com/article/Grow-your-Yammer-network-ba276bcc-dfd8-48e9-970d-6c854b501da2
Yammer Embed a group discussion into SharePoint Online https://support.office.com/article/Embed-a-group-discussion-into-SharePoint-Online-175d913b-386d-4fa7-933b-b9b7ff8f4b4e
Yammer Office 365 scenario-based training https://support.office.com/article/Office-365-scenario-based-training-af07cb6b-980d-4f33-8599-322582767408
Yammer Use Yammer everday https://support.office.com/article/Use-Yammer-every-day-47526868-b136-40cc-a80d-c870eadd9ba5
Yammer Edit your Yammer Profile https://support.office.com/article/Edit-your-yammer-profile-dc06d227-c4c9-4fdb-9bfe-9f6a6b1caa83
Yammer Accentuate the positive https://support.office.com/article/Accentuate-the-positive-da65b1c3-6651-4141-8dbd-d50d61b98a6e
Yammer Follow along https://support.office.com/article/Follow-along-53e74097-c1fc-4098-a8ad-cf40b8e02e6c
Yammer Communicate in Groups https://support.office.com/article/Communicate-in-groups-52db606b-2f29-4a9a-8cbb-b43bf2a27d2e
Yammer Enhance communication with @mentions and polls https://support.office.com/article/Enhance-communication-with-mentions-and-polls-eb096f3b-ef81-49d8-9b44-9bec6fe50c3c
Yammer Search for answers and use the discovery feed https://support.office.com/article/Search-for-answers-and-use-the-discovery-feed-e9f31b53-f1b1-407f-8cd6-6cda93fe23be
Yammer Add and edit files https://support.office.com/article/Add-and-edit-files-4ca4f40e-f9ee-4554-aa6d-e00687977875
Yammer Stay organized with notifications and inbox https://support.office.com/article/Stay-organized-with-notifications-and-inbox-856d45cc-dd94-48de-bea6-ae4f9ecdc472
Yammer Keep it going https://support.office.com/article/Keep-it-going-b8e6c9cd-bbca-49b6-bb28-7ed313d52fb0

OneNote

OneNote Office help and training https://support.office.com/
OneNote OneNote training https://support.office.com/article/OneNote-training-1c983b65-42f6-42c1-ab61-235aae5d0115
OneNote What is OneNote? https://support.office.com/article/What-is-OneNote-be6cc6cc-3ca7-4f46-8876-5000f013c563
OneNote Use OneNote in the cloud https://support.office.com/article/Use-OneNote-in-the-cloud-54fcce99-65b6-4501-ab96-27c30a176139
OneNote Get started with OneNote and notebooks https://support.office.com/article/Get-started-with-OneNote-and-notebooks-4beb2128-51d9-4531-a4e0-078f605bbfea
OneNote Add sections and pages https://support.office.com/article/Add-sections-and-pages-b041747d-f29c-4cd3-a52e-f835ee315660
OneNote Maximize your pages https://support.office.com/article/Maximize-your-pages-d57f386d-38de-4bd9-91bc-6820a3988bed
OneNote Take notes https://support.office.com/article/Take-notes-2f9f2dac-57ce-4836-ba8e-fdbf525a52ab
OneNote Create a quick note https://support.office.com/article/Create-a-Quick-Note-d7c202c5-c8e5-4a47-8645-a7ba29c26baa
OneNote Clip from the Web https://support.office.com/article/Clip-from-the-Web-b503dc7e-f320-4d7a-8546-1fb31123c308
OneNote Record audio https://support.office.com/article/Record-audio-d69dcbfe-1fd7-4930-9564-bbd83099e2c4
OneNote Capture the screen https://support.office.com/article/Capture-the-screen-c763fc05-7bd8-4020-aebb-e0b054149d94
OneNote Insert a picture https://support.office.com/article/Insert-a-picture-56292764-e25d-4712-91e6-f51c6a22453e
OneNote Copy text from an image https://support.office.com/article/Copy-text-from-an-image-0ab3ecd7-57e5-4372-a5bd-e684cb52c150
OneNote Insert a link https://support.office.com/article/Insert-a-link-c505156d-148f-4160-8b00-27a6cb501d1d
OneNote Create a table https://support.office.com/article/Create-a-table-211cf0fe-2116-4af8-92e8-608161494d66
OneNote Sort a table https://support.office.com/article/Sort-a-table-03f6e2c8-6482-470e-9670-343fa18a8d48
OneNote Convert a table to Excel https://support.office.com/article/Convert-a-table-to-Excel-a24c39e2-32b6-4366-ad21-537e2a1675e8

Powerpoint

PowerPoint Office help and training https://support.office.com/
PowerPoint PowerPoint Traning https://support.office.com/article/PowerPoint-training-40e8c930-cb0b-40d8-82c4-bd53d3398787
PowerPoint Explore PowerPoint 2016 https://support.office.com/article/Explore-PowerPoint-2016-74d69873-993c-4618-87c9-98aa3adf11cf
PowerPoint Insert stuff in your presentation https://support.office.com/article/Insert-stuff-into-your-presentation-313b6793-bc76-4f43-bd69-a511dcd83bd3
PowerPoint Save and share your presentation https://support.office.com/article/Save-and-share-your-presentation-b40d547f-a07d-48d2-bc60-ef3fb653ac22
PowerPoint Presenting with PowerPoint https://support.office.com/article/Presenting-with-PowerPoint-edb122e7-2ef2-4361-a078-708c3b84022a

Word

     
Word Office help and training https://support.office.com/
Word Word Training https://support.office.com/article/Word-training-7bcd85e6-2c3d-4c3c-a2a5-5ed8847eae73
Word Create a document in Word 2016 https://support.office.com/article/Create-a-document-in-Word-2016-f01a7977-3942-4daa-b651-23cc06a0054b
Word Format a document in Word 2016 https://support.office.com/article/Format-a-document-in-Word-2016-780772c6-9506-4081-afd1-aff9aab19f5f
Word Insert items in a Word 2016 document https://support.office.com/article/Insert-items-in-a-Word-2016-document-5c967406-a472-498b-a2e3-cdd5f0d5c50a
Word Add headers and footers and change page numbers in Word 2016 https://support.office.com/article/Add-headers-and-footers-and-change-page-numbers-in-Word-2016-f4875508-bb0c-498d-a79b-540160a7a85f
Word Save a document in Word 2016 https://support.office.com/article/Save-a-document-in-Word-2016-78c23f64-2791-4137-903d-ab0bb7a9007a

Access

     
Access Office help and training https://support.office.com/
Access Acces Training https://support.office.com/article/Access-training-a5ffb1ef-4cc4-4d79-a862-e2dda6ef38e6
Access Get Started with Access https://support.office.com/article/What-is-Access-f2338765-ff59-4cfc-b8ba-74059fcb1874
Access What is Access https://support.office.com/article/What-is-Access-f2338765-ff59-4cfc-b8ba-74059fcb1874
Access Get started with databases https://support.office.com/article/Get-started-with-databases-457013e7-f75d-48a9-bc8a-4b816436a5a0
Access Get to know database objects https://support.office.com/article/Get-to-know-database-objects-020bfb91-394e-4555-84a4-5b0fd673e6d6
Access Decide whether to create a desktop database or an Access web app https://support.office.com/article/Decide-whether-to-create-a-desktop-database-or-an-Access-web-app-7bf7ccc9-0850-48f2-858f-273271d30fa0
Access Desktop database or web app? https://support.office.com/article/Decide-whether-to-create-a-desktop-database-or-an-Access-web-app-7bf7ccc9-0850-48f2-858f-273271d30fa0
Access Create a desktop database https://support.office.com/article/Create-a-desktop-database-1446ab07-b54a-4b8a-b38e-63bb5db8f9da
Access Create an Access web app https://support.office.com/article/Create-an-Access-web-app-10855ec0-3a12-4e6c-a67c-c88267f00a3c
Access Add Tables https://support.office.com/article/Build-tables-and-set-data-types-997c250d-aec6-4430-8de5-a08671e13921
Access Build tables and set data types https://support.office.com/article/Build-tables-and-set-data-types-997c250d-aec6-4430-8de5-a08671e13921
Access Build tables with Table Designer https://support.office.com/article/Build-tables-with-the-Table-Designer-ac5a2bfb-4537-469c-8580-50eb24053383&ocmsassetID=ac5a2bfb-4537-469c-8580-50eb24053383
Access Combine fields https://support.office.com/article/Combine-fields-using-a-calculated-data-type-2a290bbc-46f6-42ae-8590-6fbc497d1de9
Access Use Relationships https://support.office.com/article/Get-started-with-table-relationships-728d53ff-f332-4ac6-9382-574ee271500a
Access Get started with table relationships https://support.office.com/article/Get-started-with-table-relationships-728d53ff-f332-4ac6-9382-574ee271500a
Access Using the Lookup Wizard https://support.office.com/article/Create-relationships-with-the-Lookup-Wizard-692775ed-5f4f-4d47-8153-d65c13ffc799
Access Using the Relationships Pane https://support.office.com/article/Create-relationships-with-the-Relationships-Pane-51c67574-c0e3-4ba3-b3f8-06f2b9b4d9a9
Access Create many-to-many relationships https://support.office.com/article/Create-many-to-many-relationships-e65bcc53-8e1c-444a-b4fb-1c0b8c1f5653
Access Create one-to-one relationships https://support.office.com/article/Create-one-to-one-relationships-a5868c76-50ea-44b7-892d-43f2af2802e0
Access Add and edit data https://support.office.com/article/Copy-data-from-Excel-b0bee2b9-e721-4332-869d-51fc9180f411
Access Copy data from Excel https://support.office.com/article/Copy-data-from-Excel-b0bee2b9-e721-4332-869d-51fc9180f411
Access Link to shared data https://support.office.com/article/Link-to-shared-data-0dadda2d-a795-4489-8098-c741879f4259
Access Manage data with queries https://support.office.com/article/Get-started-with-queries-07e75b65-5eda-414f-b822-ea4e7aaf1ccb
Access Get started with queries https://support.office.com/article/Get-started-with-queries-07e75b65-5eda-414f-b822-ea4e7aaf1ccb
Access Create basic queries https://support.office.com/article/Create-basic-queries-23887ef4-1ab7-44b1-b1f6-fab20a944c17
Access Queries with multiple data sources https://support.office.com/article/Create-queries-with-more-than-one-data-source-440d7af0-08a3-4a15-a6b6-bb7650e08465
Access Create queries with outer joins https://support.office.com/article/Create-queries-with-outer-joins-4fc01018-61ea-414a-ad26-2a058badde46
Access Query unconnected tables https://support.office.com/article/Query-unconnected-tables-8b5f68b1-a0a0-43b0-a0d6-fde58db84ddd

Skype For Business

     
Skype for Business Office help and training https://support.office.com/
Skype for Business Discover Skype for Business https://support.office.com/article/Skype-for-Business-training-8a3491a3-c095-4718-80cf-cbbe4afe4eba
Skype for Business Introducing Skype for Business https://support.office.com/article/Introducing-Skype-for-Business-e705627e-8e94-4bae-ac8b-4ccea5a9c4c0
Skype for Business Skype for Business 2016 Training https://support.office.com/article/Skype-for-Business-2016-training-eb2081bc-fd0a-4eda-94da-5a39f369ee74
Skpe for Business Explore Skype for Business https://support.office.com/article/Explore-Skype-for-Business-8b7aecb2-bdf0-436b-894f-31af502e912b
Skpe for Business Add a contact https://support.office.com/article/Add-a-contact-f3f993dd-3cd8-49cb-a68c-6764ba23db4a
Skpe for Business Check a contact's presence and IM them https://support.office.com/article/Check-a-contact-s-presence-and-IM-them-9d0b09c3-8e5e-4db3-8077-263a2b120fe8
Skpe for Business Change your picture https://support.office.com/article/Change-your-picture-772fcd80-55a7-4196-bff7-1e3f172c8eb2

One Drive for Business

OneDrive for Business OneDrive training https://support.office.com/
OneDrive for Business OneDrive training https://support.office.com/article/OneDrive-training-1f608184-b7e6-43ca-8753-2ff679203132
OneDrive for Business What is OneDrive for Business? https://support.office.com/article/What-is-OneDrive-for-Business-187f90af-056f-47c0-9656-cc0ddca7fdc2
OneDrive for Business Why Store files in the cloud? https://support.office.com/article/Why-store-files-in-the-cloud-f891c1f0-55b1-48f2-9e76-3dcf93191ced
OneDrive for Business Microsoft Cloud Services for files https://support.office.com/article/The-Microsoft-cloud-services-for-files-33dbbb4c-a569-4e96-9244-0e85ddfedd29
OneDrive for Business OneDrive training https://support.office.com/
OneDrive for Business OneDrive for Business https://support.office.com/article/OneDrive-training-1f608184-b7e6-43ca-8753-2ff679203132
OneDrive for Business Share files with One Drive for Business https://support.office.com/article/Share-files-in-OneDrive-for-Business-4f605827-a1a4-41a3-871e-6308d8b12bb1
OneDrive for Business Sync files with One Drive for Business https://support.office.com/article/Sync-files-in-OneDrive-for-Business-2c71bb7a-65bb-4232-99a1-b14aca99b9f0
OneDrive for Business Choosing where to store files in the cloud https://support.office.com/article/Choosing-where-to-store-files-in-the-cloud-7d6de218-2ed5-47ad-82a8-d093312a7340
OneDrive for Business What is file sharing? https://support.office.com/article/What-is-file-sharing-5f24ac1e-f4e4-4f0a-bebf-f8404e4a13ac

Sharepoint Online

     
SharePoint Online   https://support.office.com/
SharePoint Online Discover SharePoint https://support.office.com/article/Discover-SharePoint-cb8ef501-84db-4427-ac77-ec2009fb8e23
SharePoint Online Store files in a site library https://support.office.com/article/Store-files-in-a-site-library-9adcc8c6-3522-4306-bb53-73b907b3a282
SharePoint Online Share files in a Site Library https://support.office.com/article/Share-files-in-a-site-library-8e52537e-7e36-46e1-88bc-6312be601de2
SharePoint Online Sync files in a Site Library https://support.office.com/article/Sync-files-in-a-site-library-1f1928c2-c8f9-48c2-9ec0-db29c481b5e5
SharePoint SharePoint 2016 Help https://support.office.com/article/SharePoint-help-6c06e621-02bb-49d6-8449-509ba36d6e62
Excel Excel 2016 Help https://support.office.com/excel
OneNote OneNote 2016 Help https://support.office.com/onenote
Outlook Outlook 2016 Help https://support.office.com/outlook
PowerPoint PowerPoint 2016 Help https://support.office.com/powerpoint
Word Word 2016 Help https://support.office.com/word
Skype for Business SkypeforBusiness 2016 Help https://support.office.com/article/Skype-for-Business-help-4fbe07ce-6b15-4a06-bcf0-baea57890410&ocmsassetID=4fbe07ce-6b15-4a06-bcf0-baea57890410
OneDrive for Business OneDrive Help https://support.office.com/onedrive

Delve, Project, Publisher, Sway & Visio

     
Delve What is Delve? Help https://support.office.com/article/What-is-Office-Delve-1315665a-c6af-4409-a28d-49f8916878ca
Delve Delve 2016 Help https://support.office.com/article/Delve-help-f85fbc9b-433c-4e00-8ff4-0964281f54d5
Project and Planner Discover Project Help https://support.office.com/article/Discover-Project-63f1db89-1ee0-4113-bedc-03fc5ec6223a
Project and Planner Project 2016 Help https://support.office.com/article/Project-help-afac1e38-1219-4a88-bd22-81534778d528
Publisher Publisher Training https://support.office.com/article/Publisher-training-5ce4abaa-3557-4115-84c0-3232a5d59939
Publisher Publisher 2016 Help https://support.office.com/article/Publisher-help-3cbbff10-3e24-4b60-8800-cf0a7d58be50
Sway Getting Started With Sway https://support.office.com/article/Getting-Started-with-Sway-2076C468-63F4-4A89-AE5F-424796714A8A
Sway Sway 2016 Help https://support.office.com/article/Sway-help-56273b18-d0db-423d-a9ac-c8dc407f34b7
Visio Visio Training https://support.office.com/article/Visio-training-e058bcfa-1d90-4653-afc6-e84d54cf94a6
Visio Visio 2016 Help https://support.office.com/article/Visio-help-d511cc44-08a9-4157-bc38-8738ce586823

Office 365

     
O365; Office 2016 Office 365 Subscriptions https://support.office.com/article/What-s-new-and-improved-in-Office-2016-for-Office-365-95c8d81d-08ba-42c1-914f-bca4603e1426
O365; OneDrive Office Training Center https://support.office.com/article/Office-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb
O365; Office 2016 Get started with Office 365 https://support.office.com/article/What-is-Office-365-847caf12-2589-452c-8aca-1c009797678b
O365; Office 2016 What is Office 365 https://support.office.com/article/What-is-Office-365-847caf12-2589-452c-8aca-1c009797678b
O365; Office 2016 Sign in to Office 365 https://support.office.com/article/Sign-in-to-Office-365-f374bfd7-a280-4dae-9274-fbe1b3c04593
O365; Office 2016 Get help and support https://support.office.com/article/Get-help-and-support-d3c495a5-d7a1-4e59-997b-5ce61768262e&ocmsassetID=d3c495a5-d7a1-4e59-997b-5ce61768262e
O365; Office 2016 Get the most on Android https://support.office.com/article/Get-the-most-out-of-Office-365-on-Android-phones-and-tablets-3c7dd576-cbd2-449f-8bb6-f33912c05038
O365; Office 2016 Get the most on iPhone or iPad https://support.office.com/article/Get-the-most-out-of-Office-365-on-iPhones-and-iPads-179728f7-7287-453b-832f-558145681219
O365; Office 2016 Get the most on Windows https://support.office.com/article/Get-the-most-out-of-Office-365-on-Windows-10-phones-727e6249-f442-4935-89b3-7f2281e59ddb
O365; Office 2016 Download and install Office https://support.office.com/article/How-do-you-download-Office-afa6d3a0-b2cd-4549-9dbd-7f54ff8119b4
O365; Office 2016 How do you download Office https://support.office.com/article/How-do-you-download-Office-afa6d3a0-b2cd-4549-9dbd-7f54ff8119b4
O365; Office 2016 Install on your PC at work https://support.office.com/article/Install-Office-365-for-business-on-your-PC-47032d48-efde-42f8-b1eb-439283362a43
O365; Office 2016 Install on your Mac https://support.office.com/article/Install-Office-365-for-business-on-your-Mac-4cc698c0-e8b4-48a3-bba3-ee48255deb71
O365; Office 2016 Find your apps on Windows 10 https://support.office.com/article/Find-your-Office-apps-on-Windows-10-d6ea6c68-5d72-4012-95ea-fa6fd5bb5509
O365; Office 2016 Uninstall Office https://support.office.com/article/Uninstall-Office-dc998d82-350e-432b-a09f-a5225d10b90d
O365; Office 2016 Get started with OneDrive for Business https://support.office.com/article/What-is-OneDrive-for-Business-b30da4eb-ddd2-44b6-943b-e6fbfc6b8dde
O365; OneDrive; OneDrive for Business What is OneDrive for Business? https://support.office.com/article/What-is-OneDrive-for-Business-b30da4eb-ddd2-44b6-943b-e6fbfc6b8dde
O365; OneDrive; OneDrive for Business Set up on your phone or tablet https://support.office.com/article/Set-up-OneDrive-for-Business-on-your-phone-or-tablet-03bb3e62-d16f-4658-a632-ed30121560ef&ocmsassetID=03bb3e62-d16f-4658-a632-ed30121560ef
O365; OneDrive; OneDrive for Business Basics https://support.office.com/article/OneDrive-for-Business-basics-110ca7b0-ae3d-4e51-a14c-9d583e2d630c
O365; OneDrive; OneDrive for Business Upload files and folders https://support.office.com/article/Upload-files-and-folders-in-OneDrive-for-Business-5bd927ad-d186-495c-93e8-7ca116fe7b83
O365; OneDrive; OneDrive for Business Create files and folders https://support.office.com/article/Create-files-and-folders-in-OneDrive-for-Business-e1f59717-2f02-494d-93c6-8ef9613e82ba
O365; OneDrive; OneDrive for Business Share files and folders https://support.office.com/article/Share-files-and-folders-in-OneDrive-for-Business-72f26d6c-bf9e-432c-8b96-e3c2437f5b65
O365; OneDrive; OneDrive for Business Get started with Skype for Business https://support.office.com/article/What-is-Skype-for-Business-3a21eca4-434d-41f1-ab06-3d4a268573b7
O365; Skype; Skype for Business What is Skype for Business? https://support.office.com/article/What-is-Skype-for-Business-3a21eca4-434d-41f1-ab06-3d4a268573b7
O365; Skype; Skype for Business Download and install https://support.office.com/article/Download-and-install-Skype-for-Business-video-9162ae37-12f9-4971-bbbe-2e4a05590f36
O365; Skype; Skype for Business Sign in and out https://support.office.com/article/Sign-in-and-out-of-Skype-for-Business-8abed4b3-ac48-493e-9d76-0e10140e9451
O365; Skype; Skype for Business Set up audio and video https://support.office.com/article/Set-up-audio-and-video-in-Skype-for-Business-fa4c98cc-6982-4d8b-95ec-646dd0fbc375
O365; Skype; Skype for Business Set presence options https://support.office.com/article/Set-presence-options-in-Skype-for-Business-c5eead1e-37b9-41a4-a1f3-0cc6088b91bb
O365; Skype; Skype for Business Add or change your photo https://support.office.com/article/Add-or-change-your-photo-in-Skype-for-Business-40d7785c-b513-443f-bde8-5f5268972744
O365; Skype; Skype for Business Set up an online meeting https://support.office.com/article/Set-up-an-online-meeting-with-Skype-for-Business-c9c2294b-a56a-493a-beba-7ccb1117314e
O365; Skype; Skype for Business Change your Office 365 settings https://support.office.com/article/How-do-you-customize-Office-365-for-business-586a29c0-0db9-4b6a-b4c8-d9c96e351017
O365; Office 2016 Customize Office 365 https://support.office.com/article/How-do-you-customize-Office-365-for-business-586a29c0-0db9-4b6a-b4c8-d9c96e351017
O365; Office 2016 Update your home page https://support.office.com/article/Update-your-Office-365-for-business-home-page-d7a05fde-af1f-4b23-a444-8f980d2253d1
O365; Office 2016 Privacy settings and permissions https://support.office.com/article/Adjust-privacy-settings-and-understand-app-permissions-19415d87-7d26-45a6-ab37-82a673c1d2dc
O365; Office 2016 See what products you have https://support.office.com/article/See-what-products-you-have-deeb6ff1-fc79-423a-a84c-d7563b535f8b
O365; Office 2016 Get Started with OneDrive https://support.office.com/article/What-is-OneDrive-a7707a86-7a07-4147-839a-40928b7f1d2c
O365; Office 2016 What is OneDrive? https://support.office.com/article/What-is-OneDrive-a7707a86-7a07-4147-839a-40928b7f1d2c
O365; OneDrive Sign in or create an account https://support.office.com/article/Sign-in-or-create-an-account-for-OneDrive-6c63b4e3-c92f-4f52-80e2-237c798cec1e
O365; OneDrive OneDrive basics https://support.office.com/article/OneDrive-basics-fe8aab1e-3d1a-4a65-a9b6-77b79b6dbb30
O365; OneDrive Upload files and folders https://support.office.com/article/Upload-files-and-folders-to-OneDrive-7f630d4a-0af2-40f9-a32a-de5f149eb1de
O365; OneDrive Create files and folders https://support.office.com/article/Create-files-and-folders-in-OneDrive-b7885b2d-e40d-4fb8-ac65-84bf37b87cbf
O365; OneDrive Share files and folders https://support.office.com/article/Share-files-and-folders-in-OneDrive-3fcefa26-1371-401e-8c04-589de81ed5eb
O365; OneDrive Delete and restore files https://support.office.com/article/Delete-and-restore-files-in-OneDrive-bef769c1-0771-4a01-bcaa-2d72461672e5
O365; OneDrive Share Office 365 with your household https://support.office.com/article/Share-your-Office-365-Home-subscription-fcf21d14-f4d2-4f7e-994a-8f26d888de3c
O365; Office 2016; Skype; Word; Excel; PowerPoint Share your subscription https://support.office.com/article/Share-your-Office-365-Home-subscription-fcf21d14-f4d2-4f7e-994a-8f26d888de3c
O365; Office 2016; Skype; Word; Excel; PowerPoint When Office 365 is shared with me https://support.office.com/article/What-to-do-when-Office-365-Home-is-shared-with-me-6a9a6774-9d7a-4d2e-9e66-c55a16c1c00c
O365; Office 2016; Skype; Word; Excel; PowerPoint Deactivate an Office 365 install https://support.office.com/article/Deactivate-an-Office-365-install-34cb8d8f-3458-41fc-b002-ea20145198cf&ocmsassetID=34cb8d8f-3458-41fc-b002-ea20145198cf
O365; Office 2016; Skype; Word; Excel; PowerPoint Stop sharing your subscription https://support.office.com/article/Stop-sharing-your-subscription-with-a-family-member-245d52da-38e8-4a7d-9adb-3f308059c045
O365; Office 2016; Skype; Word; Excel; PowerPoint Get started with Skype https://support.office.com/article/Activate-Skype-minutes-39545964-e373-4ef6-a382-85085839fcb4
O365; Skype; Skype for Business Activate Skype minutes https://support.office.com/article/Activate-Skype-minutes-39545964-e373-4ef6-a382-85085839fcb4
O365; Skype; Skype for Business Use Skype minutes https://support.office.com/article/Use-Skype-minutes-0bdbbe58-4977-4c71-9f68-be6b2c32fe17
O365; Word Accessibility in Office 2016 and Windows 10 https://support.office.com/article/Accessibility-in-Office-2016-and-Windows-10-5df36873-d574-4d07-b21d-2dc4e61384ac
O365; Word Learn to create accessible Word documents https://support.office.com/article/Learn-to-create-accessible-Word-documents-0b2ca649-69a5-4d3b-9ff5-a56e6611d194
O365; Word Find and fix accessibility issues in Word 2016 https://support.office.com/article/Find-and-fix-accessibility-issues-in-Word-2016-9d660cba-1fcd-45ad-a9d1-c4f4b5eb5b7d
O365; Word Use alternative text for images and objects https://support.office.com/article/Use-alternative-text-for-images-and-objects-9c57ee44-bb48-40e3-aad4-7647fc1dba51
O365; Word Use heading styles to make your document more accessible https://support.office.com/article/Use-heading-styles-to-make-your-document-more-accessible-68f1eeff-6113-410f-8313-b5d382cc3be1
O365; Word Create meaningful hyperlinks that people understand https://support.office.com/article/Create-meaningful-hyperlinks-that-people-understand-28305cc8-3be2-417c-a313-dc22082d1ee0
O365; Word Use meaningful file names for documents https://support.office.com/article/Use-meaningful-file-names-for-documents-4e73d73a-aedc-47af-88e4-8f2375a69fad
O365; Word Structure tables for easy navigation in Word https://support.office.com/article/Structure-tables-for-easy-navigation-in-Word-cb464015-59dc-46a0-ac01-6217c62210e5
O365; Windows 10; Narrator Using Mail for Windows 10 with Narrator https://support.office.com/article/Accessibility-in-Office-2016-and-Windows-10-5df36873-d574-4d07-b21d-2dc4e61384ac
O365; Windows 10; Narrator Set up your email in Mail for Windows 10 using Narrator https://support.office.com/article/Using-Mail-for-Windows-10-with-Narrator-6017079f-5087-4fa9-9111-0527e456d817
O365; Windows 10; Narrator Read and respond to email in Windows 10 using Narrator https://support.office.com/article/Read-and-respond-to-email-in-Windows-10-using-Narrator-2df61adf-194a-450d-a0d6-edee8b70da67
O365; Windows 10; Narrator Using Narrator with the Mail app in Windows 10: search, folders, and filters https://support.office.com/article/Using-Narrator-with-the-Mail-app-in-Windows-10-search-folders-and-filters-b320cdcb-7b71-4196-9889-c8f82d87136e
O365; Windows 10; Narrator Create and format email messages in Mail for Windows 10 using Narrator https://support.office.com/article/Create-and-format-email-messages-in-Mail-for-Windows-10-using-Narrator-60278fe4-4b38-41ef-ac04-dee79586c974
O365; Windows 10; Narrator Use Narrator to read more complex email messages in Mail for Windows 10 https://support.office.com/article/Use-Narrator-to-read-more-complex-email-messages-in-Mail-for-Windows-10-fc0d84e2-f1b9-41b6-8cd1-ca4d9d8c4e4d

Quick start

     
Excel Office 2016 Quick Start Guide https://support.office.com/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e
OneNote Office 2016 Quick Start Guide https://support.office.com/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e
Outlook Office 2016 Quick Start Guide https://support.office.com/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e
PowerPoint Office 2016 Quick Start Guide https://support.office.com/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e
Word Office 2016 Quick Start Guide https://support.office.com/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e

Skype fro Business

     
Skype for Business Office 2016 Quick Start Guide https://docs.com/OfficeTraining/9869/skype-for-business-quick-start-guides
Skype for Business Quick Start Guide Audio setup and making calls https://docs.com/OfficeTraining/3218/skype-for-business-audio-setup-and-making-calls?c=nPwVig
Skype for Business Quick Start Guide contacts, presence and IM https://docs.com/OfficeTraining/8995/skype-for-business-contacts-presence-and-im?c=nPwVig
Skype for Business Quick Start Guide meetings https://docs.com/OfficeTraining/2553/skype-for-business-meetings?c=nPwVig
Skype for Business Quick Start Guide sharing and collaboration https://docs.com/OfficeTraining/4139/skype-for-business-sharing-and-collaboration?c=nPwVig
Skype for Business Quick Start Guide video https://docs.com/OfficeTraining/3042/skype-for-business-video?c=nPwVig

Office for Mac

Office 2016 for Mac Office 2016 for Mac Basics Training (English) https://docs.com/OfficeTraining/4663/office-2016-for-mac-basics-training-english
OneNote 2016 for Mac OneNote 2016 for Mac Basics https://docs.com/OfficeTraining/1862/onenote-2016-for-mac-basics-training?c=3AM3U6
PowerPoint 2016 for Mac PowerPoint 2016 for Mac Basics https://docs.com/OfficeTraining/2082/powerpoint-2016-for-mac-basics?c=3AM3U6
Excel 2016 for Mac Excel 2016 for Mac Basics https://docs.com/OfficeTraining/5255/excel-2016-for-mac-basics?c=3AM3U6
Word 2016 for Mac Word 2016 for Mac Basics https://docs.com/OfficeTraining/1025/word-2016-for-mac-basics?c=3AM3U6
Outlook 2016 for Mac Outlook 2016 for Mac Basics https://docs.com/OfficeTraining/6434/outlook-for-mac-2016-basics-training?c=3AM3U6

General

Title   URL
Office 2016 Office Training https://docs.com/OfficeTraining#collection
Excel Excel Training https://support.office.com/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
Outlook Outlook training https://support.office.com/en-us/article/Outlook-training-8a5b816d-9052-4190-a5eb-494512343cca

 

   
Office help and training https://support.office.com/
Excel Training https://support.office.com/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
What is Excel https://support.office.com/article/What-is-Excel-842fb550-07cb-42d1-9a9f-c55789efed57
Create a workbook https://support.office.com/article/Create-a-workbook-82e9eab2-2e4e-463a-baa5-669b6c8ac543
Add, delete, or rename sheets https://support.office.com/article/Add-delete-or-rename-sheets%e2%80%8b-861d97cb-3b33-4978-92e4-9446dc19b8da
Hide columns https://support.office.com/article/Hide-columns-95146525-ce4f-4ff6-a118-c0724deb1a98
Freeze top and left panes https://support.office.com/article/Freeze-top-and-left-panes-94708bae-df5c-4c3b-888c-621cf5d4bc94
Move or copy worksheets https://support.office.com/article/Move-or-copy-worksheets-48580e26-5b6d-48d3-afb5-317e18006dcb
Change the look of your workbook https://support.office.com/article/Change-the-look-of-your-workbook-51fb88ae-a7e9-455f-a79d-1ef2d7bd1bc7
Add and edit data https://support.office.com/article/Add-and-edit-data-2661a56a-196c-49c0-9dc3-ca785df9df9b
Align data in cells https://support.office.com/article/Align-data-in-cells-483730f9-7cdb-4d67-b9e6-ffabd6401e16
Format numbers in cells https://support.office.com/en-us/article/Format-numbers-in-cells-e6656c9b-a36a-4143-8fe4-5b6de0d9486b
Change the look of cells https://support.office.com/en-us/article/Change-the-look-of-cells-3e76ab4d-e39f-4feb-b3b8-0e09e27ffbaa
Copy cell formatting https://support.office.com/en-us/article/Copy-cell-formatting-6207db27-7981-4b83-bd29-cc68c333dcfa
Select cell contents https://support.office.com/en-us/article/Select-cell-contents-c5e3b5c7-89f9-4d4c-9ef5-1dffaebff52d
Move or copy cell contents https://support.office.com/en-us/article/Move-or-copy-cell-contents-59b01879-ea2a-4f76-b2e4-e437fc45c61d
Insert or delete rows or columns https://support.office.com/en-us/article/Insert-or-delete-rows-or-columns-7450f58a-517f-48ae-bace-248346e52275
Resize rows and columns https://support.office.com/en-us/article/Resize-rows-and-columns-2d73d527-2725-4bed-b199-9a981362b5f9
AutoFill time spans https://support.office.com/en-us/article/AutoFill-time-spans-11091064-f01e-4fe1-bc76-f975e386597c
Split and combine data https://support.office.com/en-us/article/Split-and-combine-data-0edb925e-2af7-47fb-895a-28a07d5b73d4
Build custom numeric formats https://support.office.com/en-us/article/Build-custom-numeric-formats-2e67d937-d5d5-46d1-b371-3192bafd0237
Validate cell data https://support.office.com/en-us/article/Validate-cell-data-82cfacc1-46ed-400f-863d-1ee0400f5fa7
Create reusable lists https://support.office.com/en-us/article/Create-reusable-lists-368959da-4ec8-43ea-9883-1615e582de01
Create formulas https://support.office.com/en-us/article/Create-formulas-23936c25-8fde-4ec3-a868-a8add99f884d
Name cells and ranges https://support.office.com/en-us/article/Name-cells-and-ranges-8ad05e62-bc18-49fc-937b-8f4144c256c2
Use Trace to fix formula errors https://support.office.com/en-us/article/Use-Trace-to-fix-formula-errors-689e22fc-9886-46c0-87ca-1fb626ec87e9
Locate functions https://support.office.com/en-us/article/Locate-functions-56bad091-a973-45ed-88f8-234f0cde0d24
Calculations using functions https://support.office.com/en-us/article/Calculations-using-functions-1aaa835d-8414-4194-873a-5a20183c6b98
Create tables https://support.office.com/en-us/article/Create-tables-bf0ce08b-d012-42ec-8ecf-a2259c9faf3f
Sort data in a table https://support.office.com/en-us/article/Sort-data-in-a-table-7f11ec7c-6c1b-4195-9fa5-b3bc8ea544d4
Filter data in a table https://support.office.com/en-us/article/Filter-data-in-a-table-7fbe34f4-8382-431d-942e-41e9a88f6a96
Add totals, subtotals, and slicers https://support.office.com/en-us/article/Add-totals-subtotals-and-slicers-9885a56c-51b5-487a-a168-054afd034631
Filter data with slicers https://support.office.com/en-us/article/Filter-data-with-slicers-3517fa12-353e-4907-b94d-b8e9b500ee33
Create charts https://support.office.com/en-us/article/Create-charts-231c42d2-5e58-40e1-99f0-cbe618cfee1d
Add sparkline charts https://support.office.com/en-us/article/Add-sparkline-charts-8d2399ed-748e-4fb5-95c9-eed8177f116d
Format charts https://support.office.com/en-us/article/Format-charts-92693043-1772-46a9-90e3-88c8c76084d8
Add trendlines and drop lines https://support.office.com/en-us/article/Add-trendlines-and-drop-lines-6b72b363-aa05-4c93-8c5b-22c480eb6e1f
Quick Analysis of Data https://support.office.com/en-us/article/Quick-Analysis-of-Data-343e775c-58ee-4a3d-8d52-f4e3f5240d79
Create PivotTables https://support.office.com/en-us/article/Create-PivotTables-74ce8afc-2446-4816-80ee-20ca7fb71793
Work with PivotTables https://support.office.com/en-us/article/Work-with-PivotTables-1404c8ee-ea47-4e4b-a6a0-9bd694eb8c7d
Group data in PivotTables https://support.office.com/en-us/article/Group-data-in-PivotTables-038055a0-9ba8-4f70-9a00-84bd41a48a3f
Slice data in PivotTables https://support.office.com/en-us/article/Slice-data-in-PivotTables-1f0532af-5e59-45e6-830f-0c058157d90c
Create PivotCharts https://support.office.com/en-us/article/Create-PivotCharts-d7fc5918-12a9-4f99-bd35-e80660468efd
Password-protect workbooks https://support.office.com/en-us/article/Password-protect-workbooks-707db3cb-e41e-495d-a592-464b9fbee17d
Create charts on a Mac https://support.office.com/en-us/article/Create-charts-on-a-Mac-0fbd860f-7dde-49b3-937a-ab9ac0aa7e31
Create reusable lists on a Mac https://support.office.com/en-us/article/Create-reusable-lists-on-a-Mac-2b94bb99-b304-41fd-a46e-0e739537db1d
Hide rows or columns on a Mac https://support.office.com/en-us/article/Hide-rows-or-columns-on-a-Mac-be4c1744-f603-4516-9aed-437b1ccdbeec
Office help and training https://support.office.com/

Outlook

 Outlook training  https://support.office.com/en-us/article/Outlook-training-8a5b816d-9052-4190-a5eb-494512343cca
What is Outlook https://support.office.com/en-us/article/What-is-Outlook-10f1fa35-f33a-4cb7-838c-a7f3e6228b20
Add remove email accounts https://support.office.com/en-us/article/Add-and-remove-email-accounts-7c031aff-0ceb-435a-ada9-a389cfc8ddca
Import gmail into outlook https://support.office.com/en-us/article/Import-Gmail-into-Outlook-46274497-95ea-4a7d-9651-d246aa63eb5e
View messages https://support.office.com/en-us/article/View-messages-9aa2285c-acee-41eb-89fc-b0630af0a886
Create and send messages https://support.office.com/en-us/article/Create-and-send-messages-400d4d45-8e2d-46a2-8cb5-ddabf12489ed
Send files with messages https://support.office.com/en-us/article/Send-files-with-messages-d32cd5ad-c7c5-49df-814d-4c17a5d3beb0
Forward or reply to messages https://support.office.com/en-us/article/Forward-or-reply-to-messages-72255538-5bcb-4be6-bede-c28014a5c951
Open or save attachments https://support.office.com/en-us/article/Open-or-save-attachments-fe720382-697f-4cf1-96d3-b466216d2956
Send automatic reply messages https://support.office.com/en-us/article/Send-automatic-reply-messages-cc0e480f-973e-4412-a27b-8a52108d6d51
Retract or replace a sent message https://support.office.com/en-us/article/Retract-or-replace-a-sent-message-8e564127-15a0-4cf6-b974-f2101f5e256e
Add signatures to messages https://support.office.com/en-us/article/Add-signatures-to-messages-31fb24f9-e698-4789-b92a-f0e777f774ca
Add attachments to messages https://support.office.com/en-us/article/Add-attachments-to-messages-80dc6d58-a00d-463b-8e94-1fedefa9cda9
Design personal stationery https://support.office.com/en-us/article/Design-personal-stationery-b059b1be-5875-40ca-8399-ad0fb7dd21cd
Reuse email content https://support.office.com/en-us/article/Reuse-email-content-d2b6e35c-1c63-49a7-9b7f-2631bb13c16a
Clean up your Inbox https://support.office.com/en-us/article/Clean-up-your-Inbox-2fb652e5-b387-4147-9fff-25f2e32dfda9
Block unwanted mail https://support.office.com/en-us/article/Block-unwanted-mail-a3cda7e7-03ab-4188-9a9c-0f05e6a41e75
Apply message attributes  https://support.office.com/en-us/article/Apply-message-attributes-Set-a-flag-reminder-and-color-a894348d-b308-4185-840f-aff63063d076
Organize messages using folders https://support.office.com/en-us/article/Organize-messages-using-folders-0616c259-4bc1-4f35-807d-61eb59ac79c1
Search and filter messages https://support.office.com/en-us/article/Search-and-filter-messages-3e32b06d-a2d9-4a66-922f-78b77c41b97f
Organize your Inbox with rules https://support.office.com/en-us/article/Organize-your-Inbox-with-rules-75ab719a-2ce8-49a7-a214-6d62b67cbd41
Manage contact lists https://support.office.com/en-us/article/Manage-contact-lists-1ef8f35b-04be-4bd0-ac9c-6d6a146887ce
Organize contacts into categories https://support.office.com/en-us/article/Organize-contacts-into-categories-94bb9b18-02d4-434f-81c3-cc267d388830
Add and manage contact groups https://support.office.com/en-us/article/Add-and-manage-contact-groups-3f73d218-52d6-4f88-a733-9ff37073ee4c
Manage multiple address books https://support.office.com/en-us/article/Manage-multiple-address-books-0ce18a10-5912-4127-95e3-cb268d92cb40
Set up calendars https://support.office.com/en-us/article/Set-up-calendars-946d27fa-7463-4cbb-8bef-ad4cbcc7a671
Search for calendar items https://support.office.com/en-us/article/Search-for-calendar-items-11f6c52d-9a72-4bfb-9cd2-c1857156dc5b
Email or print your calendar https://support.office.com/en-us/article/Email-or-print-your-calendar-c3bf704e-01e9-4e49-b0dc-ad1d6f9bf2e4
Use multiple calendars https://support.office.com/en-us/article/Use-multiple-calendars-506bf022-e4a3-4c30-876f-517505a79aef
Create calendar groups https://support.office.com/en-us/article/Create-calendar-groups-29206d7c-0d2b-4afc-8e8c-6ede150971fc
Import a Google calendar  https://support.office.com/en-us/article/Import-a-Google-calendar-8e8364e1-400e-4c0f-a573-fe76b5a2d379
Delegate calendar management https://support.office.com/en-us/article/Delegate-calendar-management-6b96f35d-3307-419e-ba72-16dcc47b79b3
Schedule appointments https://support.office.com/en-us/article/Schedule-appointments-6e6ddec6-5983-4c42-9652-b99e120206fb
Set up an online meeting  https://support.office.com/en-us/article/Set-up-an-online-meeting-4b87e762-c56b-4bcf-8b56-95fd8b6d241b
Manage recurring meetings https://support.office.com/en-us/article/Manage-recurring-meetings-106799ae-5ed0-4eeb-90b4-68668c6668fe
Attach a file to a meeting invitation https://support.office.com/en-us/article/Attach-a-file-to-a-meeting-invitation-48bd606a-2f74-4c57-9ac6-3a9010699eec
Take meeting notes https://support.office.com/en-us/article/Take-meeting-notes-9f90b4f4-e16c-415f-8e6d-d58a704d7e9b
Create and update tasks https://support.office.com/en-us/article/Create-and-update-tasks-6de6ee52-751b-4405-b389-850572b15306
View tasks https://support.office.com/en-us/article/View-tasks-9a2ef589-4308-4328-894b-5bac3e910ed5
Conduct polls https://support.office.com/en-us/article/Conduct-polls-5d179f38-ef78-4388-8da6-6d54ade65ce6
Organize meetings https://support.office.com/en-us/article/Organize-meetings-a7580b8f-3882-4037-b9be-c4a7df5eea99
Share calendars with others https://support.office.com/en-us/article/Share-calendars-with-others-2fcf4f4f-8d46-4d8b-ae79-5d94549e531b
Add an Exchange or Office 365 email account https://support.office.com/en-us/article/Add-an-Exchange-or-Office-365-email-account-cb6fa8c2-dfa9-4ab9-9af9-000ef5695da0
View messages https://support.office.com/en-us/article/View-messages-ebd1a173-0605-4bd8-9196-f7530d1ac581
Create messages https://support.office.com/en-us/article/Create-messages-b6f7a955-792e-4e46-99f7-948cb214a230
Forward or reply to messages https://support.office.com/en-us/article/Forward-or-reply-to-messages-9671823b-7155-4440-8bca-15340f2e0a96
Send automatic reply messages https://support.office.com/en-us/article/Send-automatic-reply-messages-19e0fc91-c59d-4614-942e-f8bda8fa7ab6
Add attachments to messages https://support.office.com/en-us/article/Add-attachments-to-messages-6e082eb4-979d-49f3-a6c6-75f039e2d4fc
Open or save attachments https://support.office.com/en-us/article/Open-or-save-attachments-378d30eb-c6bb-4236-9e22-9956eecba2fb
Add signatures to messages https://support.office.com/en-us/article/Add-signatures-to-messages-42c7242d-057d-43f9-8bb6-c35dac7d5349
Block unwanted mail https://support.office.com/en-us/article/Block-unwanted-mail-634f2cc6-72c8-4224-85ca-01756da25f24
Search and filter messages https://support.office.com/en-us/article/Search-and-filter-messages-d13ff6dd-ce50-4f9a-8562-5db94316c416
Organize messages by using folders https://support.office.com/en-us/article/Organize-messages-on-a-Mac-by-using-folders-ee28fbe0-264e-459f-b64c-809965009af0
Organize your Inbox with rules https://support.office.com/en-us/article/Organize-your-Inbox-with-rules-52998e2d-ac98-4198-b4ab-f37ca30a0edd
Schedule appointments https://support.office.com/en-us/article/Schedule-appointments-a200cb3d-5621-4246-aff0-7a77e7b29a01
Organize meetings https://support.office.com/en-us/article/Organize-meetings-494cd44c-3b58-4261-b35a-e234fa88af3c
Set up calendars https://support.office.com/en-us/article/Set-up-calendars-26d95811-7c96-436f-a0db-8d20e724f5c1
Print or email your schedule https://support.office.com/en-us/article/Print-or-email-your-schedule-1a0827e8-3233-49f5-8a06-410652b5a415
Create additional calendars https://support.office.com/en-us/article/Create-additional-calendars-24a7c5bb-f051-45f2-b37b-7328a1a89707
Delegate calendar management https://support.office.com/en-us/article/Delegate-calendar-management-e235cd59-85ff-400c-ab6f-776db3574df5
Manage contact lists https://support.office.com/en-us/article/Manage-contact-lists-acbd8449-fcb7-4f18-9a53-6ec4ecf86054
Add and manage contact groups https://support.office.com/en-us/article/Add-and-manage-contact-groups-09db18fd-fb5e-4bde-b6ff-c825df517158
Manage multiple address books https://support.office.com/en-us/article/Manage-multiple-address-books-c212f889-697e-40aa-8f68-26609dcbd32b
Create and update tasks https://support.office.com/en-us/article/Create-and-update-tasks-77a35c77-8fd2-45ff-91ec-18dd2e9ebd12
Search for tasks https://support.office.com/en-us/article/Search-for-tasks-27fbdd71-e8f9-4934-a097-adb209d0fe82
Add email accounts https://support.office.com/en-us/article/Add-email-accounts-1105a1d7-a808-4c38-b5b6-abf90e05c247
View messages https://support.office.com/en-us/article/View-messages-80088a9b-e413-4bdf-b4cf-e00740adbd29
Create messages https://support.office.com/en-us/article/Create-messages-8979dbf0-3f1d-4515-9254-fef297afa5eb
Manage contact lists https://support.office.com/en-us/article/Manage-contact-lists-105a486c-0d57-4b52-9891-011678fa66ce
Organize meetings https://support.office.com/en-us/article/Organize-meetings-63addfb7-e6a1-4c81-b783-2408d8fd0ce2
Schedule appointments https://support.office.com/en-us/article/Schedule-appointments-0b7de2a9-0202-474a-8068-e4ea48114bfd
Set up calendars https://support.office.com/en-us/article/Set-up-calendars-78cae3d2-bfb9-42b9-8dbf-1e1459092da5

Downloads

 You can also download the searchable Excel list from the Microsoft site.