Format a PivotTable in Excel: Overview You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
Conditional Formatting in Excel: Overview Conditional formatting in Excel lets you define criteria for cells which change the way the cells look in the worksheet, but only if the cells’ values match the criteria. For example, you could create a conditional formatting criterion that makes a worksheet cell appear with a red fill color
Format Trendlines in Excel Charts: Overview You can easily format trendlines in Excel charts if you applied them to one or more chart series. To format trendlines in Excel, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then select a trendline to format from the “Chart Elements” drop-down in
Add an Identity Plate to a Slideshow in Lightroom Classic CC: Overview How to Add an Identity Plate to a Slideshow in Lightroom Classic CC You can easily add an identity plate to a slideshow in Lightroom Classic CC. The “Overlays” panel in Lightroom Classic CC’s Slideshow module lets you add an identity plate
Format Paragraphs in PowerPoint: Overview You can easily format paragraphs in PowerPoint. To format all paragraphs in a text-containing object in PowerPoint, click the border of the object to select it. Doing this turns the text-containing object into “object” mode. This mode applies your formatting to all text within the object. Note that some
Format Text in OneNote: Overview You can easily format text in OneNote to change its appearance. To format text in OneNote, first click into the text within the container on the page. Then select the text to which to apply text formatting. Alternatively, to select all the text in the container, click the container’s
Data Visualizations in Power View in Excel: Overview You can visualize report data in a Power View worksheet by adding data visualizations in Power View in Excel. To add data visualizations in Power View in Excel, drag a data field from the “Power View Field” task pane into the “Fields” section of the task
Format Page Backgrounds in OneNote: Overview You can format page backgrounds in OneNote to add visual interest and stay better organized. To change the settings of a selected page’s background, first click the “View” tab in the Ribbon. To change the background color, click the “Page Color” drop-down in the “Page Setup” button group.