With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.

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?

If you're having trouble using the Outlook for Android mobile app, Open an in-app Outlook support ticket. If you have a work or school account that uses Microsoft 365 for business or Exchange-based accounts, there may be additional requirements set by your IT admin.

To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

Why does my reading pane have a dark background? When dark mode is turned on, the reading pane has a dark background to reduce eye strain. You can make the reading pane brighter by selecting at the top of the reading pane. If you don't see the button, select .

The following are some ways you can work with lists to help you to manage information for your group. Track versions and detailed history Track versions of list items, so that you can see which items have changed from version to version, as well as who changed the list items.If mistakes are made in a newer version, you can restore a previous version of an item.

Find everything you need to manage your Xbox account, profile, and more.

This article is for Outlook Web App, which is used by organizations that manage email servers running Exchange Server 2013 or 2010. If you're using Microsoft 365, or Exchange Server 2016 or 2019, your email program is Outlook on the web.

There are several ways to reduce your mailbox size. You can use the Mailbox Cleanup tool to view the size of your mailbox and individual folders. This tool can also help you search for older or very large messages that you might want to delete or move to an Outlook Data File (.pst).

Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.