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
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
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.
First things to know about teams in Microsoft Teams
A team is a group of people gathered to get something big done in your organization. Sometimes it’s your whole organization.. Teams are made up of channels, which are the conversations you have with your teammates.Each channel is dedicated to a specific topic, department, or project. For example, the Mark 8 Project team has General, Design, Digital Assets Web, Go to Market Plan, and Research ...
Applies To: Microsoft Teams
What's the difference between the OneNote versions?
No matter where you live, work, or roam, there’s a version of Microsoft OneNote to fit your needs. Whether you’re on a PC, a Mac, in a browser, or on a mobile device, each version of OneNote lets you reliably access your cloud-connected notebooks to capture your thoughts and ideas.
Applies To: OneNote for Microsoft 365, OneNote for Microsoft 365 for Mac, OneNote for the web, OneNote 2021, OneNote 2021 for Mac, OneNote for Windows 10, OneNote 2019 for Mac, OneNote 2016, OneNote for Mac, OneNote for iOS, OneNote for Android
Get help with clipboard - Microsoft Support
Using clipboard. When you copy content on your PC, it’s automatically copied to your clipboard for you to paste. You can paste multiple items from your clipboard history, and you can also pin the items you tend to use all the time and sync your clipboard history to the cloud.
Sync your account in Outlook to the Microsoft Cloud
To enhance your Microsoft 365 experience in new Outlook for Windows, Outlook.com, Outlook for iOS, Outlook for Android, and new Outlook for Mac, you can now sync your non-Microsoft accounts (including their emails, contacts, and events) to the Microsoft Cloud.
Applies To: Outlook 2021 for Mac, Outlook 2019 for Mac, Outlook.com, New Outlook for Windows, Outlook for Android, Outlook for iOS
About Microsoft Authenticator - Microsoft Support
Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.
Applies To: Microsoft account dashboard
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use mail merge to send bulk email messages - Microsoft Support
To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. The following process assumes that you already have the message you intend to send created and open in Microsoft Word.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016