SUMIF function - Microsoft Support
Tips: If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John.". To sum cells based on multiple criteria, see SUMIFS function.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Keyboard shortcuts for Microsoft Teams - Microsoft Support
Note: If you're using the default app bar configuration in the Microsoft Teams desktop app, use the commands in the table below.If you've changed the order of your apps or added additional apps, the command depends on the app's sequential order on the app bar. For example, if you've moved Calendar to the top of the app bar, press Ctrl+1 to open it, not Ctrl+4.
Applies To:
Microsoft Teams
Organize your ideas with Collections in Microsoft Edge
Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you left off the last time you were browsing the internet.
Enable TPM 2.0 on your PC - Microsoft Support
How to enable TPM. If you need to enable TPM, these settings are managed via the UEFI BIOS (PC firmware) and vary based on your device. You can access these settings by choosing: Settings > Update & Security > Recovery > Restart now. From the next screen, choose Troubleshoot > Advanced options > UEFI Firmware Settings > Restart to make the changes.
How do I get Microsoft Teams? - Microsoft Support
There are several ways to get Microsoft Teams. First, look at the plans and pricing for Microsoft Teams to decide which version is the best fit for you. Then you can get Microsoft Teams or sign in.To learn more about how to get the different versions of Microsoft Teams, keep reading.
Applies To:
Microsoft Teams
Get started with Microsoft Teams - Microsoft Support
Training: Microsoft Teams is a collaboration app built for hybrid work to help you and your team stay informed, organized, and connected. Learn how in this video.
Applies To:
Microsoft Teams
Usar a Ferramenta de Captura para obter capturas de tela
Para capturar um recorte de vídeo, abra a Ferramenta de Recorte, selecione o botão Gravar e, em seguida, selecione Nova gravação ou prima a tecla do logótipo do Windows + Shift + R.Selecione a área do ecrã que pretende gravar e, em seguida, selecione Iniciar.Quando terminar, selecione Parar.Neste momento, pode guardar a gravação tal como está ou selecionar Editar no Clipchamp para ...
Support Microsoft
Le support Microsoft est là pour vous aider avec les produits Microsoft. Trouvez des articles pratiques, des vidéos et des formations pour Microsoft Copilot, Microsoft 365, Windows, Surface, etc.
Zip and unzip files - Microsoft Support
To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.
Update Office with Microsoft Update - Microsoft Support
Under Important Updates, choose Install updates automatically, and under Microsoft Update check the Give me updates for Microsoft products and check for new optional Microsoft software when I update Windows box to get the Office updates.. Your IT department might set automatic updates for you. If they do, you'll see the message in the yellow bar, and you won't be able to use the Important ...
Applies To:
Office 2016, Microsoft 365 for home