SUMPRODUCT function - Microsoft Support
The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:
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
INDEX function - Microsoft Support
Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.
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
How to earn Microsoft Rewards points - Microsoft Support
Open Rewards dashboard. To earn points by searching with Bing on your mobile device, set Bing as your default search engine, use the Bing app, or use the Microsoft Launcher for Android app.
Applies To: Microsoft account dashboard
Obtener la actualización más reciente de Windows
Los dispositivos Windows pueden obtener nuevas funciones en diferentes momentos, ya que Microsoft ofrece actualizaciones no relacionadas con la seguridad, correcciones, mejoras y mejoras a través de varias tecnologías de mantenimiento, incluida la implementación controlada de funciones (CFR). Windows te avisará si necesitas reiniciar el dispositivo para completar una actualización y ...
Configure headers and footers for different sections of a document
Click Link to Previous to turn it off and unlink the header or footer from the previous section.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Add a Gmail account to Outlook for Windows - Microsoft Support
If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Create a form with Microsoft Forms - Microsoft Support
Tip: You can also format your text.Highlight a word or words in your title or questions, and then choose any of the following: Bold (keyboard shortcut - CTRL/Cmd+B), Italic (keyboard shortcut - CTRL/Cmd+I), Underline (keyboard shortcut - CTRL/Cmd+U), Font color, Font size, Numbering, or Bullets.
Applies To: Excel for the web, OneNote for the web, OneDrive (work or school), Microsoft Forms
Keyboard shortcuts for Outlook - Microsoft Support
Top of Page. Contacts (People) keyboard shortcuts. The People view is your address book in Outlook where your personal contacts are stored and where you can open any address book that has been set up for your organization. The People, Mail, and Calendar views work together so you can easily send mail to and schedule appointments with your most important people.
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 on the web, Outlook.com, New Outlook for Windows, Outlook for iOS, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Can't sign in to OneDrive - Microsoft Support
Select the Start button, search for "OneDrive", and then open it:
Applies To: OneDrive for Business, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Tastenkombinationen in Windows - Microsoft-Support
Erfahren Sie, wie Sie Windows mithilfe von Tastenkombinationen navigieren. Hier finden Sie eine vollständige Liste der Taskleisten-, Eingabeaufforderungs- und allgemeinen Windows-Tastenkombinationen.