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
Timeline Options in Excel: Overview This lesson shows you how to set timeline options in Excel. After inserting a timeline, an “Options” tab within a new “Timeline Tools” contextual tab then appears in the Ribbon. This tab appears in the Ribbon any time you select the timeline within the worksheet. You use the buttons
Forecast Sheets in Excel: Overview You can insert forecast sheets in Excel into a workbook to predict future trends from existing time-based data. To create forecast sheets in Excel, you must have a series of date or time entries for the timeline. You must also have corresponding values for those time or date entries.
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
The Eraser Tool in Photoshop Elements: Overview The Eraser tool in Photoshop Elements applies the background color to an image. Contrary to what its name implies, this tool does not make pixels transparent in an image. Instead, it applies the background color, versus the foreground color. To use the Eraser Tool in Photoshop Elements,
Import Preferences in Lightroom Classic CC: Overview In addition to providing many importing options, you can also set many import preferences in Lightroom Classic CC. You set import preferences in Lightroom Classic CC within the “Preferences” dialog box. To open the “Preferences” dialog box, select “Edit| Preferences” from the Menu Bar. You can
Save a Word Document as a PDF File: Overview You may want to save a Word document as a PDF file. You can also save a Word document as an XPS file. Both file formats keep your document formatting but make it difficult for anyone else to change the file’s content. Both file formats
Catalog Settings in Lightroom Classic CC: Overview You can customize the catalog settings in Lightroom Classic CC by using the “Catalog Settings” dialog box. To change the catalog settings in Lightroom Classic CC, select “Edit| Catalog Settings…” from the Menu Bar. Doing this then opens the “Catalog Settings” dialog box. The “General” tab