Office Lens is an app for all of your Windows devices. It's a great way to capture notes and info from whiteboards, menus, signs or anything with a lot of text--and even images without text.

Group items manually or create a custom group. On the View menu, in the Current View group, select Change View, and then select Save Current View As a New View.

Organization news. News can come from many different sites. but there might be "official" or "authoritative" sites for organization news. News from these sites are distinguished by a color block on the title as a visual cue, and are interleaved throughout all news posts displayed for users on the SharePoint start page.

Turn the feature on or off while presenting. If you're in the middle of giving a presentation and want to turn the feature on or off, click the Toggle Subtitles button from Slide Show View or Presenter View, on the toolbar below the main slide:. In Slide Show View:. In Presenter View:. You can also toggle subtitles from the right-click menu, or with the shortcut key J.

C1 is the upper left cells of the range (also called the starting cell).. MATCH("Oranges",C2:C7,0) looks for Oranges in the C2:C7 range. You should not include the starting cell in the range. 1 is the number of columns to the right of the starting cell where the return value should be from. In our example, the return value is from column D, Sales. Top of Page

Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with "entered values" (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list.

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. ...

You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them. Data in an Excel workbook can come from two different locations.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Dimensions. 11.5” x 7.9” x 0.33” (292 mm x 201 mm x 8.5 mm) Display. Screen: 12.3” PixelSense™ Display Resolution: 2736 x 1824 (267 PPI) Aspect Ratio: 3:2