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
How to set up and test microphones in Windows - Microsoft Support
In Sound settings, go to Input to see your connected microphones. If it's a Bluetooth microphone, select Add device.
Troubleshoot problems updating Windows - Microsoft Support
Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.
Pin, remove, and customize in Quick access - Microsoft Support
By default, File Explorer opens to Quick Access. You can set a folder to show up in Quick access so it'll be easy to find. Just right-click (or long-press) it and select Pin to Quick access. Unpin it when you don’t need it there anymore by right-clicking (or long-pressing) it and selecting Unpin from Quick access.. If you want to see only your pinned folders, you can turn off recent files or ...
Where to enter your Office product key - Microsoft Support
These steps apply only to Office Professional Plus, Visio Professional, or Project Professional. Step 1: Start an Office app, like Word, Project, or Visio, depending on your purchase.. Step 2: In the Sign in to set up Office window, select I don't want to sign in or create an account (it's a small link at the bottom of the window).. Step 3: Enter your Office product key, without hyphens.
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business
Office 2021 and Office LTSC for Windows and Mac FAQ
Microsoft 365 is a subscription that comes with premium apps like Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access (Publisher and Access available on PC only). The apps can be installed on multiple devices, including PCs, Macs, iPads, iPhones, Android tablets, and Android phones. Microsoft 365 also comes with services like 1 TB of OneDrive storage, 60 Skype minutes per month ...
Applies To: Office 2021, Office 2021 for Mac
Windows 10 and Windows 11 in S mode FAQ - Microsoft Support
To increase security and performance, Windows 11 in S mode only runs apps from the Microsoft Store. If you want to install an app that isn't available in the Microsoft Store, or if you have Windows 10 Pro, Enterprise, or Education and want to upgrade to Windows 11, you'll need to permanently switch out of S mode.
Move your files to a new Windows PC - Microsoft Support
The above options will help you move files to your new PC. To access your favorite Microsoft apps and services from any device, be sure to sign in with your Microsoft account.It will connect you to your tools and subscriptions, plus help you manage your digital life, privacy settings, and the health and safety of your devices.
Reinstall Windows - Microsoft Support
Notes: Reinstalling Windows 11 using installation media while choosing to ‘Keep nothing’ (a clean install) will automatically enable reserved storage if the partition you reinstall Windows to is 20GB or larger. Reserved storage sets aside disk space to be used by updates, apps, temporary files, and system caches, thus improving the day-to-day function of your PC by ensuring that critical ...
Microsoft Teams () - Microsoft
為您的群組聊天命名,以協助釐清交談的主題。 視訊通話. 開啟或關閉視訊通話。 音訊通話 開啟或關閉音訊通話的音訊。 共用螢幕 與群組聊天中的參與者共用您的螢幕。 檢視及新增參與者 檢視參與者清單,並將人員新增至群組。
Applies To: Microsoft Teams, Microsoft Teams personal