Create, load, or edit a query in Excel (Power Query) - Microsoft Support
Know which environment you're in Power Query is well-integrated into the Excel user interface, especially when you import data, work with connections, and edit Pivot Tables, Excel tables, and named ranges. To avoid confusion, it’s important to know which environment you are currently in, Excel or Power Query, at any point in time.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Reduce the size of your mailbox and Outlook Data Files (.pst and .ost)
Learn how to find out the size of your mailbox and its folders and how to compact Outlook Data Files (.pst and .ost), which might help improve performance.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Set your work hours and location in Outlook - Microsoft Support
Microsoft 365 helps you manage and share your work schedule. New features allow you to specify more details about your work schedule: from where you’re working (remotely or in office) and whether you work different hours on different days. In addition, you’ll be able to schedule meetings with others based on their work location and view work location on people’s contact cards.
Applies To: Outlook on the web, Microsoft Teams, New Outlook for Windows
Choose between the 64-bit, 32-bit, and ARM version of OneDrive
If you're not sure which OneDrive version is better for you, you can review the reasons to choose the 64-bit version, the 32-bit version, ARM64 version for Windows, or the Apple silicon version for Mac. If you know what version you want, you can learn how to install it.. If you already have OneDrive, but you're not sure which version you have, check out Which version of OneDrive am I using?
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Create workbook links - Microsoft Support
You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
UNIQUE function - Microsoft Support
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Change or reset Internet Explorer settings - Microsoft Support
Learn how to change Internet Explorer settings, or reset browser settings when there's a problem.
Mark a message as important or urgent in Microsoft Teams
To mark a message as important or urgent in Microsoft Teams, select Set Delivery Options ! beneath the compose box and then click Important or Urgent.
Applies To: Microsoft Teams
INDEX function - Microsoft Support
How to use the INDEX function in Excel to return a value or reference to a value within a table or range.
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 2019 for Mac, Excel 2016
Windows Media Player - Microsoft Support
Learn how to download and customize Windows Media Player. Get troubleshooting help and how-to information for Windows Media Player 12.