Use a link or code to join a team in Microsoft Teams
Use a code. Select Teams on the left side of the app, then select Create and join teams and channels at the top of your teams list.
Applies To: Microsoft Teams
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
Windows で Bluetooth デバイスをペアリングする - Microsoft サポート
開始する前に、Windows 11 PC が Bluetooth をサポートしていることを確認します。 確認方法の詳細については、「Windows の Bluetooth の問題を解決する」を参照してください。 Bluetooth 機能を備えていないデバイスの追加についてのヘルプは、「Windows PC にデバイスを追加する」を参照してください。
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
Basic tasks in Excel - Microsoft Support
Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Global Customer Service phone numbers - Microsoft Support
Country/Region. Country/Region code. Phone number. Language. Australia. N/A. 13 20 58. English. New Zealand. N/A +64. 0800 800 004 9 368 5680. English
Microsoft .NET Framework Repair Tool is available
The tool may make one or more changes to the installed version of .NET Framework. For example, it may correct the state of Windows Installer on the computer, reset the discretionary access control lists (DACLs) on certain folders, or resolve issues that are related to an invalid or corrupted update registration.
Undo, redo, or repeat an action - Microsoft Support
Undo an action. Press + Z, or select Undo in the upper-left corner of the ribbon, until you've fixed the issue.. You can't undo some actions, such as selecting commands on the File menu or saving a file. If you can't undo an action, the Undo command changes to Can't Undo.. To undo several actions at the same time, select the arrow next to Undo, select the actions in the list that you want to ...
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
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
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
CONCAT function - Microsoft Support
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.
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