IF function - Microsoft Support
In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...
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
Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
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
Manage photos and videos with Microsoft Photos app
Select Settings, and under the About section, select About Photos. Photos: Says Updated in the About section of Settings—you are running the new version of the Photos app.This version includes features like iCloud integration in left navigation bar. This version of Microsoft Photos app offers a convenient and user-friendly way to view, import, organize, edit, and share photos and videos on ...
Create, edit, or delete a contact list or contact group in Outlook
You can right-click the contact group and select Delete from the menu or click the group, then select Delete from the Ribbon.. Contacts are not deleted, only the contact list.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Change your keyboard layout - Microsoft Support
Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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
Fix your Outlook email connection by repairing your profile
On the Email tab, choose your account (profile), and then choose Repair.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
How to set your time and time zone - Microsoft Support
In Date & time, you can choose to let Windows 10 set your time and time zone automatically, or you can set them manually.. To set your time and time zone in Windows 10, go to Start > Settings > Time & language > Date & time.. Open Date & time settings
Welcome to your email - Microsoft Support
Change the appearance of your email. Select View.. From here, you can: Change the size of the Folder Pane.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
How to download and install the latest printer drivers
If Windows Update finds an updated driver, it will download and install it, and your printer will automatically use it. If a device driver couldn’t be installed automatically, there may be an optional driver available that your printer can use.