Import data from data sources (Power Query) - Microsoft Support
Note When you use a workbook connected to a SQL Server Analysis Services database, you may need additional information to answer specific product questions, such as reference information about multidimensional expressions (MDX), or configuration procedures for an online analytical processing (OLAP) server.. Select Data > Get External Data > From Database > From Analysis Services.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Create or edit a hyperlink - Microsoft Support
Optional: To customize the ScreenTip that appears when you rest the pointer over the hyperlink, click ScreenTip in the top-right corner of the Insert Hyperlink dialog box and enter the text you want. You can also create a hyperlink to a blank email message by simply typing the address in the document. For example, type someone@example.com, and Microsoft 365 creates the hyperlink for you ...
Applies To:
Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013
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
Fixes or workarounds for recent issues in OneDrive
ISSUE. Videos recorded in slo-mo and uploaded either through automatic Camera roll backup or manually in the app do not play in slo-mo as it is recorded.
Applies To:
Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Tutorial: Import Data into Excel, and Create a Data Model
Note: Notice the checkbox at the bottom of the window that allows you to Add this data to the Data Model, shown in the following screen.A Data Model is created automatically when you import or work with two or more tables simultaneously. A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Get help with your Microsoft account - Microsoft Support
Billing & payments. Your dashboard is also where you can: Buy, renew, or cancel a subscription.
Applies To:
Microsoft account dashboard
Calculate the difference between two times - Microsoft Support
On the Home tab, in the Number group, click the arrow next to the General box, and then click More Number Formats.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Hide or show rows or columns - Microsoft Support
Insert or delete rows, and columns Article; Select cell contents in Excel Article; Freeze panes to lock rows and columns Article; Hide or show rows or columns
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
Welcome to your email - Microsoft Support
Change the appearance of your email. Select View.. From here, you can: Change the size of the Folder Pane.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Give your PC a Fresh Start - Microsoft Support
To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings