SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
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
Using the new Bing on the Windows taskbar - Microsoft Support
The new Bing is now available to everybody directly from the Windows taskbar, making more ways to interact with your PC across search, answers, chat, and creation available anytime, right on your desktop.
Filter websites and searches using Microsoft Family Safety
Establishing internet boundaries is an important way to protect yourself and your family from inappropriate web content. Microsoft Family Safety web and search filters work across any Windows, Xbox and mobile device that has the Microsoft Edge browser and Family Safety apps installed.
Applies To: Microsoft Family Safety
Create an Outlook Data File (.pst) to save your information
When you add an email account to Outlook, a local copy of your information is stored on your computer. This feature allows you to access your previously downloaded or synchronized email messages, calendar information, contacts, and tasks without an internet connection.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business
Automatically number rows - Microsoft Support
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),"000-000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range. ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Set up an authenticator app as a two-step verification method
Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.
Add, find, edit, or delete a contact in Outlook - Microsoft Support
Add a contact from someone's profile card. If you're using Outlook in an organization and you click someone's name or picture in Outlook or other Office apps and services, you might see a profile card with additional information.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013, Outlook on the web, Outlook.com, New Outlook for Windows
Repair Outlook Data Files (.pst and .ost) - Microsoft Support
Note: The scan creates a backup file during the repair process.To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or choose Browse to select the file you want to use. You may need to run the tool several times in order to repair your Outlook Data File.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Command Prompt and Windows Powershell for Windows 11
Solution 2: Windows Terminal settings. Open Windows Terminal, then select the Startup tab > Default terminal application > Windows Console Host.. Solution 3: Windows Console settings. If you already have a command line app open in a Windows Console Host and want to change the default setting: