Excel help & learning
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Use the Tasks app in Teams - Microsoft Support
List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.
Applies To:
Microsoft Planner, Microsoft Teams, Microsoft To Do
Aktivieren von Office - Microsoft-Support
Wenn Sie Office Professional Plus, Visio Professional oder Project Professional über das Microsoft Workplace Discount Program-Angebot (ehemals als Microsoft Home Use Program bekannt) Ihres Arbeitgebers erworben haben, wählen Sie Ich möchte mich nicht anmelden oder ein Konto erstellen (unten auf dem Bildschirm) aus, und geben Sie Ihren Product Key ein.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Office.com, Project for Office 365
Open and use a shared mailbox in Outlook Web App
Type the email address of the other mailbox that you want to open and then select Open.Or, start typing and then select Search contacts and directory to find the mailbox you want to open. Select the shared mailbox you want to open, and then select Open.Another Outlook Web App session opens in a separate window, allowing access to the other mailbox.
Applies To:
Outlook Web App
Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Troubleshoot print issues in Microsoft Edge
If Microsoft Edge still can't print after you try this step, go on to the next step. Step 2: Test printing from other applications. Knowing the extent of the printing issue will help you figure out the root cause.
Record a slide show with narration and slide timings
The slide show opens in the Recording window (which looks similar to Presenter view), with buttons at the top left for starting, pausing, and stopping the recording.Click the round, red button (or press R on your keyboard) when you are ready to start the recording. A three-second countdown ensues, then the recording begins.
Applies To:
PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016
Improved copy and paste of URLs in Microsoft Edge
In an app, press Ctrl + V to use the default paste, which adds a link with the title of the page as the link text. If you're pasting into an app or website in Microsoft Edge, you can also right-click, select Paste as on the context menu, and then select Link (Default) from the sub-menu.
PowerPoint for Windows training - Microsoft Support
Training: Watch and learn how to use PowerPoint in Windows. Explore PowerPoint training guides, articles, and how-to videos.
Applies To:
PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, Office for business