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
Accessing Credential Manager - Microsoft Support
Credential Manager lets you view and delete your saved credentials for signing in to websites, connected applications, and networks. To open Credential Manager, type credential manager in the search box on the taskbar and select Credential Manager Control panel.
Create an email message template - Microsoft Support
Note: To create an email message using a keyboard shortcut, press Ctrl + Shift + M.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
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
SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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
Manage drive space with Storage Sense - Microsoft Support
Cloud files can exist locally on the disk or be available online only. To choose the conditions for when inactive files are made online only, under Content will become online-only if not opened for more than: choose your preferred amount of time. Note that starting in Windows 11, version 22H2, the default for OneDrive cloud files is to make files online-only if not opened for more than 30 days.
Troubleshoot issues with the Xbox app for Windows
Press the Start button on the taskbar, type settings, and then select Settings.; On Windows 10, select Update & Security.On Windows 11, select Windows Update.; On the Windows Update page, select Check for updates to see if any updates are available for your device.; Once the updates have downloaded, select Install now to start the installation.; Following installation, we recommend that you ...
Ändern der Browser-Startseite - Microsoft-Support
Geben Sie auf der Registerkarte Allgemein unter Startseite die URL der Website ein, die Sie als Startseite festlegen möchten. Sie können mehrere URLs hinzufügen. Für die aktuell angezeigte Website wählen Sie Aktuelle verwenden.Wenn Sie mehr als eine URL verwenden, fügen Sie jede URL in eine eigene Zeile ein.
How to add an account in OneDrive - Microsoft Support
To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.
Applies To: OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Customize keyboard shortcuts - Microsoft Support
Important: Reassigning a combination of keys means that you can no longer use the combination for its original purpose.For example, pressing CTRL+B changes selected text to bold. If you reassign CTRL+B to a new command or other item, you will not be able to make text bold by pressing CTRL+B unless you restore the keyboard shortcut assignments to their original settings by selecting Reset All ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016