LINEST function - Microsoft Support
The accuracy of the line calculated by the LINEST function depends on the degree of scatter in your data. The more linear the data, the more accurate the LINEST model.LINEST uses the method of least squares for determining the best fit for the data. When you have only one independent x-variable, the calculations for m and b are based on the following formulas:
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
Mailbox storage limits in Outlook - Microsoft Support
Clean up Mailbox. From the Settings > Storage page you should see a breakdown of how much space each folder in your mailbox is taking. Below, you should see a list of the folders represented in the breakdown with the option to permanently delete all items (or those older than 3, 6, or 12 months) in these folders to free up space.
Applies To: Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
How to redeem gift cards and codes | Xbox Support
Press the Start button , and then enter store into the search bar.; Choose Microsoft Store from the results to open the app.; Select your account in the top-right corner of the screen, and then select Redeem code or gift cards.; Enter the 25-character code, select Next, and then follow the prompts.
SharePoint video training - Microsoft Support
Learn common SharePoint Online tasks with these videos and tutorials, and get links to more training for SharePoint and Office 365.
Applies To: SharePoint in Microsoft 365
Excel not responding, hangs, freezes or stops working
Important: The Assistant will, in most cases, modify the registry and move files from startup folders used by Excel. Before you run the Assistant, make sure that you back up the registry and all files in startup folders used by Excel so that you can restore the registry and backed-up files if a problem occurs.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
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
Download and install Microsoft 365 Access Runtime
The Access 365 Runtime is like previous runtimes in that all design-related UI is either removed or disabled. The Access 365 Runtime includes the Access Database Engine which contains a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb ...
Applies To: Access for Microsoft 365, Access 2021, Office 2021, Access 2019, Office 2019
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
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Microsoft 365 for business If your business subscription plan includes the desktop version of the Microsoft 365 apps you won't see an option to install it unless someone in your organization assigned a license to you.. Learn how to check this in What Microsoft 365 business product or license do I have? or if you're a Microsoft 365 admin responsible for assigning licenses to people in your ...
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Change your app recommendation settings in Windows
Next to Choose where to get apps, select one of the available options.To see recommendations, select Anywhere, but let me know if there's a comparable app in the Microsoft Store.. To stop seeing app recommendations, select Anywhere.