Use mail merge for bulk email, letters, labels, and envelopes
Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016, Word 2016 for Mac
Set up rules in Outlook - Microsoft Support
Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Manage your call settings in Microsoft Teams
Adjust your voicemail settings. To change your voicemail settings, select Settings and more next to your profile picture at the top of Teams and then choose Settings > Calls. You will find all voicemail settings under Manage voicemail.. Voicemail greeting. To record a new voicemail greeting, select Record a greeting and follow the instructions to record your message.
Applies To: Microsoft Teams
Turn airplane mode on or off - Microsoft Support
Note: Airplane mode retains the settings you used last time.When you turn on airplane mode, Windows remembers if you had Wi-Fi or Bluetooth on last time, and keeps that setting so your Wi-Fi or Bluetooth will be on again.
Free Excel for the web templates - Microsoft Support
Tip: If you don’t like the name of the template (usually Book 1), click the name in the Excel for the web title bar at the top of the page and type a different name.
Applies To: Excel for the web
Customize the ribbon in Office - Microsoft Support
What you can customize: You can personalize your ribbon to arrange tabs and commands in the order you want them, hide or unhide your ribbon, and hide those commands you use less often.Also, you can export or import a customized ribbon. What you can't customize: You can't reduce the size of your ribbon, or the size of the text or the icons on the ribbon.
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, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, InfoPath 2013, InfoPath Filler 2013
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Change notification and quick settings in Windows
In Windows 10, action center is where you'll find your app notifications and quick actions—which give you quick access to commonly used settings and apps.