Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Change from a 32-bit version to a 64-bit version or vice versa. Activate Windows. Fix Bluetooth problems in Windows. Learn how to install, reinstall, or activate Microsoft 365 or Office 2019 on a PC or Mac.
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
Download and install or reinstall Office 2019, Office 2016, or Office ...
From the Overview page, select Office apps and on that page, find the Microsoft 365 product you want to install and select Install. To install Microsoft 365 in a different language, or to install the 64-bit version, use the dropdown to find more options.
Applies To: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
View, manage, and install add-ins for Excel, PowerPoint, and Word
If you're looking for Help on specific Excel Add-ins, such as Solver or Inquire, see Help for Excel for Windows add-ins. If you're looking for additional help with Excel add-ins using the COM Add-ins dialog box, see Add or remove add-ins in Excel. Get a Microsoft 365 Add-in for Excel.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, InfoPath 2013
Where to enter your Office product key - Microsoft Support
If your purchase of Office or Microsoft 365 came with a product key, you enter your product key on one of the websites listed below for your product. After you enter your key, you can download and install Office, or you can renew your Microsoft 365 subscription. Tip: Get tech expertise with Business Assist.
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business
Add, turn off, or remove extensions in Microsoft Edge
Here's how to add, turn off, and remove them in Microsoft Edge . Find and add an extension to Microsoft Edge. In Microsoft Edge, select Extensions , located to the right of your browser address bar. Note: If you don't see Extensions to the right of your browser address bar, select Settings and more > Extensions.
Screen mirroring and projecting to your PC or wireless display
You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Contact Us - Microsoft Support
Get help and support, whether you're shopping now or need help with a past purchase. Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.
AVERAGEIFS function - Microsoft Support
The AVERAGEIFS function syntax has the following arguments: Average_range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers. Criteria_range1, criteria_range2, …
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
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