IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
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
Surface power supplies and charging requirements
For info on how to properly care for the power cord and power supply, see Clean and care for your Surface.. Safety and regulatory information. To view the safety and regulatory information for Surface and Surface power supplies, including shipping information and AC power cord safety, see Product safety warnings and instructions.. Where to find a power supply
Remove specific prevalent malware with Windows Malicious Software ...
Microsoft generally releases the MSRT on a monthly cadence as part of Windows Update or as a standalone tool. (For exceptions, see Skipped releases.)Use this tool to find and remove specific prevalent threats and reverse the changes that they made (see Covered malware families).For comprehensive malware detection and removal, consider using Windows Defender Offline or Microsoft Safety Scanner.
Convert numbers stored as text to numbers - Microsoft Support
Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:
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 Web App
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
Change settings in Microsoft Teams - Microsoft Support
Change Teams settings. Teams will reflect the same date and time format as your device's language, date, and time settings. For example, if your device's display language is set to English (United States), the date and time in Teams will display the regional format used in the United States.. Change your language settings
Applies To: Microsoft Teams
First things to know about teams in Microsoft Teams
A team is a group of people gathered to get something big done in your organization. Sometimes it’s your whole organization.. Teams are made up of channels, which are the conversations you have with your teammates.Each channel is dedicated to a specific topic, department, or project. For example, the Mark 8 Project team has General, Design, Digital Assets Web, Go to Market Plan, and Research ...
Applies To: Microsoft Teams
Customize the navigation on your SharePoint site
The following communication site shows a footer that's been added. Labels and links appear on the right side of the footer. When you add labels and links to your footer, they follow the Edit link and appear to the right.. On your site, select Edit on the right side of the footer (Edit appears on your footer after you've turned the footer control on).
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint in Microsoft 365, Microsoft 365 admin
How do I reassign hot keys for my keyboard? - Microsoft Support
Note: The options listed in this wizard vary depending on the key selected.For example, since you cannot reassign the Windows key, the only option available is to disable it.
What's new in Word 2021 for Windows - Microsoft Support
Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.
Applies To: Word 2021