Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone
Use Excel as your calculator - Microsoft Support
Learn more about simple formulas. All formula entries begin with an equal sign (=).For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Connect to a VPN in Windows - Microsoft Support
Whether it's for work or personal use, you can connect to a virtual private network (VPN) on your Windows PC. A VPN connection can help provide a more secure connection and access to your company's network and the internet, for example, when you’re working from a coffee shop or similar public place.
October 5, 2021, update for Outlook 2016 (KB5001998)
This article describes update 5001998 for Microsoft Outlook 2016 that was released on October 5, 2021. Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016.
Office 2019 for Windows and Mac FAQ - Microsoft Support
Office 2019 (for both Windows and Mac) is a one-time purchase and does not receive feature updates after you purchase it. Office 2019 includes a meaningful subset of features that are found in Microsoft 365, but it's not part of Microsoft 365.
Applies To: Office 2019, Office 2016 for Mac
Import and export Outlook email, contacts, and calendar
Export contacts out of other email services. Export iCloud contacts. Export Gmail contacts – See Gmail help. Export Yahoo contacts – See Yahoo import and export help. Export Thunderbird contacts – See Mozilla support.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook 2013, Outlook.com
Free Excel for the web templates - Microsoft Support
Use create.microsoft.com to find and download free Excel for the web templates. Download free Excel templates for calendars, invoices, budgeting, and more.
Applies To: Excel for the web
Connect your Windows PC to an external display that supports Miracast ...
On right side of the taskbar, select the Network icon > Cast > pick your display or adapter.
Using product keys with Office - Microsoft Support
If you see a Let's get started screen with options to try, buy, or activate Office, this means that Office is installed on your new PC as a 1-month trial of Microsoft 365 Family. You won't receive a product key from your PC manufacturer unless you paid for an Office product key card. Instead, you can start a trial of Microsoft 365 Family, or buy Office.
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 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Microsoft 365 for home, InfoPath 2013
Upload and save files and folders to OneDrive - Microsoft Support
Upload files or folders to OneDrive. You can store over 300 types of files on OneDrive. With Microsoft Edge or Google Chrome: Select Add new > Files upload or Folder upload > Folder.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows