Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
IF function – nested formulas and avoiding pitfalls
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis of many spreadsheet models, but they are also the root cause of many spreadsheet issues.
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
Change the font or font size in the message list - Microsoft Support
Change the font size in your new Outlook message list. From the menu, select View > View settings.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Dictate your documents in Word - Microsoft Support
Dictation lets you use speech-to-text to author content in Microsoft 365 with a microphone and reliable internet connection. It's a quick and easy way to get your thoughts out, create drafts or outlines, and capture notes.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Turn on device encryption - Microsoft Support
In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.
Add a list box or combo box to a worksheet in Excel
To set this property. Do this. Fill color. Click BackColor > the down arrow > Pallet, and then pick a color.. Font type, style or size. Click Font > the... button and pick font type, size, or style.. Font color. Click ForeColor > the down arrow > Pallet, and then pick a color.. Link a cell to display selected list value. Click LinkedCell. Link Combo Box to a list
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.
Ways to count values in a worksheet - Microsoft Support
Use AutoSum. Use AutoSum by selecting a range of cells that contains at least one numeric value. Then on the Formulas tab, click AutoSum > Count Numbers.. Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected. Generally, this result is displayed in a cell to the right for a horizontal range or in a cell below for a vertical range.
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
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
Microsoft Edge update settings - Microsoft Support
If either of the categories above apply to you, use the following procedures to update your browser: Update once. In the browser, go to Settings and more > Help and feedback > About Microsoft Edge (edge://settings/help).. If the About page shows Microsoft Edge is up to date., you don't need to do anything.
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.