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
Browsing history on the privacy dashboard - Microsoft Support
Why am I not seeing all my data on the privacy dashboard? To learn more about why you might not be seeing all of your data, see View your data on the privacy dashboard.. Legacy version of Microsoft Edge
Upload and save files and folders to OneDrive - Microsoft Support
Upload files or folders to OneDrive. You can store over 300 types of files on OneDrive. With Microsoft Edge or Google Chrome: Select Add new > Files upload or Folder upload > Folder.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Import data from data sources (Power Query) - Microsoft Support
Note When you use a workbook connected to a SQL Server Analysis Services database, you may need additional information to answer specific product questions, such as reference information about multidimensional expressions (MDX), or configuration procedures for an online analytical processing (OLAP) server.. Select Data > Get External Data > From Database > From Analysis Services.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2019, Excel 2016, Excel 2013
See your Google Calendar in Outlook - Microsoft Support
By importing a snapshot of your Google calendar into Outlook, you can see it alongside other calendars in the Outlook Calendar View. To keep the imported calendar up-to-date, subscribe to the Google Calendar in Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Encrypt email messages - Microsoft Support
When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Change default programs in Windows - Microsoft Support
To change the default app, you can do either of the following: Set a default for a file type or link type In the search bar, enter the file type or link type you want, then select it from the list of results.
Request a refund for digital games | Xbox Support
Refunds are typically issued for requests meeting the following criteria: Requests are made within 14 days of the purchase date; Requests are for games in which you haven’t accumulated a significant amount of play time
Change your screen saver settings - Microsoft Support
Select the Start button, then go to Settings > Personalization > Lock screen, and select Screen saver settings.In the Screen Saver Settings window, choose a screen saver from the drop-down list. Change your screen saver settings
Create list relationships by using lookup columns
Select Save and fill out the target list.When you add a book to the target list (Reading list), there is now an option to add information from the source list. For the example, for The Future of Computing by Lovelace, select the Course Name "Machine Learning" and the Course ID will be automatically filled in (in this case, it's CS405).Since the columns are lookup columns, you only need to fill ...
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, SharePoint Foundation 2013, Microsoft Lists