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.
Manage your Microsoft 365 subscription or Office product
Follow the prompts to install or reinstall the desktop apps. For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a prepaid code or card.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
IF function – nested formulas and avoiding pitfalls
The IF function 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. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis ...
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
Use Smart charging in Windows - Microsoft Support
When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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
Obtain a digital certificate and create a digital signature
Windows 10. Windows 8. Windows 7, Windows Vista, or Windows XP. To view the certificate in the Personal Certificates store, do the following: Open Internet Explorer. On the Tools menu, click Internet Options, and then click the Content tab. Click Certificates, and then click the Personal tab. Important: If you digitally sign a document by using ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Word 2021, Word 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Office 2013
Find your Windows product key - Microsoft Support
Generally, if you bought a physical copy of Windows, the product key should be on a label or card inside the box that Windows came in. If Windows came preinstalled on your PC, the product key should appear on a sticker on your device. If you’ve lost or can’t find the product key, contact the manufacturer. To ensure your product key is ...
Applies To: Microsoft account dashboard
Use the Office offline installer - Microsoft Support
Step 2. Install Office. Select the Microsoft 365 folder from the virtual drive and then double-click either the Setup32.exe to install the 32-bit version of Microsoft 365, or Setup64.exe to install the 64-bit version to begin the offline installation. If you're not sure which version is right for you, see Choose the 64-bit or 32-bit version of Office. ...
Applies To: Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
View and delete browser history in Microsoft Edge
Types of info. What will be deleted. Where it's stored. Browsing history. The URLs of sites you've visited, and the dates and times of each visit. On your device (or, if sync is turned on, across your synced devices)
Create, edit, or delete a contact list or contact group in Outlook
Edit a contact list. On the side panel, select People. Select All contact lists, then select Edit by either right-clicking the contact list or selecting it from the Ribbon. You'll have the option to rename the contact list, add additional contacts to the list, or add a Description to the list. When you are finished, select Save.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Add or manage a Yahoo! email account in Outlook
Add a new Yahoo email account. On the View tab, select View settings. Select Accounts, then Email accounts. Tip: If your Settings window doesn't look like this, you might be using classic Outlook. Select + Add Account. Enter the Yahoo! account you want to add and select Continue. On Sync your Yahoo account, select Continue.
Applies To: Outlook for Microsoft 365, New Outlook for Windows