Create, load, or edit a query in Excel (Power Query) - Microsoft Support
A Data Model typically contains several tables arranged in a relationship. You load a query to a Data Model by using the Load To command to display the Import Data dialog box, and then selecting the Add this data to the Data Model check box.For more information about Data Models, see Find out which data sources are used in a workbook data model, Create a Data Model in Excel, and Use multiple ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create workbook links - Microsoft Support
Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Write an equation or formula - Microsoft Support
The Professional option displays the equation in a professional format optimized for display. The Linear option displays the equation as source text, which can be used to make changes to the equation if needed. The linear option will display the equation in either UnicodeMath format, or LaTeX format, which can be set in the Conversions chunk.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016
Find the serial number on your Microsoft or Surface device
If you have this Surface. Find it here. Surface Laptop, any Surface Laptop Go, and Surface Laptop SE. Look under your keyboard near the hinge. Any Surface Laptop Studio. Starting in Laptop mode, gently rotate the top of the display backwards 180 degrees.
Account & profile | Xbox Support
Find everything you need to manage your Xbox account, profile, and more.
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.
Microsoft Teams video training - Microsoft Support
Training: Watch these videos to help your school, work, or organization use Microsoft Teams to video conference, work remotely, and become proficient using Teams.
Applies To: Microsoft Teams
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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, Excel Web App, Excel for Windows Phone 10
INDIRECT function - Microsoft Support
Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
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
Manage audio settings in Microsoft Teams meetings
Audio source. When you choose this... Computer audio Your computer's default speaker and mic will be used during the meeting. To adjust your PC mic and speaker settings, select Open device settings .. In Audio settings, select the audio devices you want to use from the Speaker and Microphone dropdown menus.You can alsoturn on spatial audio and adjust noise suppression.
Applies To: Microsoft Teams