Lookup and reference functions (reference) - Microsoft Support
Important: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.
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
Fix microphone problems - Microsoft Support
If you want to give access to desktop apps, make sure that Let desktop apps access your microphone is turned on.You can't turn off microphone access for individual apps. Others can't hear me. Try the following solutions:
Gaming Services Repair Tool for PC | Xbox Support
Download the Gaming Services Repair Tool for PC using the link below. Choose your save destination and then go to that destination to open the file after the download is complete.
View hidden files and folders in Windows - Microsoft Support
Select the View tab and, in Advanced settings, select Show hidden files, folders, and drives and OK.
Find my downloads in Windows 10 - Microsoft Support
To find downloads on your PC: Select File Explorer from the taskbar, or press the Windows logo key + E.
How to change your Xbox gamertag | Xbox Support
Press the Xbox button to open the guide, and then go to Profile & system.; Select your Xbox profile (or select Choose a profile and sign in to your account).; Select My profile > Customize profile, and then select your current gamertag.; Under Choose your new gamertag, enter the gamertag that you want in the available text box, and then select Check availability.
Check your device performance and health in Windows Security
The Health report starts off by showing you the last time a Device Health scan was run. The time displayed should be basically the current time, as Windows Security tries to run a Device Health scan when you open the Device performance & health page.. Beyond the time of last scan you'll see the status of the key areas that Device Health monitors:
Change your background in Microsoft Teams meetings
If you want to change what appears behind you in your video meeting or call, you can either blur your background, replace it entirely with any image you want, or use Teams virtual background template.And with a Teams Premium license, you can change your Teams meeting background to a branded logo or image specific to your company.
Applies To: Microsoft Teams
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
How to sign in to Hotmail - Microsoft Support
Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.
Applies To: Outlook.com