Add or delete boxes in your flow chart. Add a box. Click the SmartArt graphic that you want to add a box to. Click the existing box that is located closest to where you want to add the new box. On the Design tab, in the Create Graphic group, click the arrow next to Add Shape. If you don't see the Design tab, make sure that you've selected the ...

But you might want separate columns for each. So, you can split the Sales Rep first name and last name into two columns. Select the "Sales Rep" column, and then select Home > Transform > Split Column. Select Choose the By Delimiter. Select the default Each occurrence of the delimiter option, and then select OK. Power Query splits the Sales Rep ...

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Reading preferences in Immersive Reader In Reading preferences, you can turn on tools like Line focus to focus on reading one, three or five lines at a time, Picture dictionary to see a visual representation of a word, or Translate to change the language of the text.. Find these tools in Reading preferences on the Immersive Reader toolbar. Line focus: Line focus narrows the focus of your ...

Select a single cell anywhere in the range that you want to sort. On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window. In the Sort by dropdown list, select the first column on which you want to sort. In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon. In the Order list, choose the order ...

Copy the address of the web page from the Address bar of your browser. Switch to PowerPoint for the web and select the slide where you want to place the video. On the Insert tab of the ribbon, in the Media group, select Online Video. In the Online Video dialog box, paste the address you copied in step 2. Select Insert.

Your table of contents will still be there. To customize your existing table of contents: Go to References > Table of Contents. Select Custom table of contents. Use the settings to show, hide, and align page numbers, add or change the tab leader, set formats, and specify how many levels of headings to show. For more info, see Custom table of ...

Add page numbers to a header or footer. Double-click in the header or footer where you want the page numbers to go. Go to Insert > Page Numbering. Select Current Position. Choose a style.

Insert page numbers. On the Insert tab, select Page Number, and then choose the location and style you want. If you don't want a page number to appear on the first page, select Different First Page. If you want numbering to start with 1 on the second page, go to Page Number > Format Page Numbers, and set Start at to 0. When you're done, select ...

Turn Focused Inbox on or off in new Outlook. Open Outlook. Select View > View Settings . In Mail > Layout, select the account you want to apply the settings to. To turn it on - Select the option Sort messages into Focused and Other. To turn it off - Select the option Don't sort my messages. Select Save if you made any changes.