Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.

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.

To create the installation media, here's what you'll need: A PC with a reliable internet connection. The download time will vary, depending on your internet connection.

Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.

Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.

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.

Note: You might not be able to change the power mode when a custom power plan is selected.If you can’t set the power mode in Power & battery settings, open Control Panel, select System and Security > Power Options, then choose a Balanced power plan.

Find Teams on the web at https://teams.microsoft.com.. To use Teams, you need a Microsoft 365 account with a Business or Enterprise Microsoft 365 license plan. For more information, see How do I get access to Microsoft Teams?. For information about supported browsers for Teams on the web, see Web clients for Microsoft Teams.

Alternate command key. What it does. Help. Opens the Help system (if any) for the active window. Undo. Cancels the previous action. Redo. Cancels the previous Undo action.

To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. To count numbers or dates that fall within a range (such as greater than 9000 and at the same time less than 22500), you can use the COUNTIFS function. Alternately, you can use SUMPRODUCT too.