Find operating system info in Windows 8.1 or Windows RT 8.1. To find out which version of Windows your device is running, press the Windows logo key key + R, type winver in the Open box, and then select OK.. If your device is running Windows 8.1 or Windows RT 8.1, here’s how to learn more:

Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..

Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...

Take a closer look at the macro . You can learn a little about the Visual Basic programming language by editing a macro. To edit a macro, in the Code group on the Developer tab, click Macros, select the name of the macro, and click Edit.This starts the Visual Basic Editor.

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form.It allows you to split across columns or down by rows.

When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.

Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

Click a template to see a preview. Click the arrows on the side of the preview to see more templates.

Under Ways to sign in , you have three choices to sign in with Windows Hello:. Select Facial recognition (Windows Hello) to set up facial recognition sign-in with your PC's infrared camera or an external infrared camera

You'll see the logo screen on your screen. Continue to hold the Volume Up button. Release the button when the UEFI screen appears. If you have a Windows Pro/Enterprise device (not a Windows Home device), you can then toggle off Type Cover port from the Devices menu and exit UEFI. Re-enter UEFI (press power + Volume Up) and toggle Type Cover port back on, then check if the Keyboard works in UEFI.