Format a PivotTable in Excel – Instructions and Video

Format a PivotTable in Excel: A picture showing the “Design” tab of the “PivotTable Tools” contextual tab in the Ribbon of Excel.
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
Read more
No Comments

Timeline Options in Excel – Instructions

Timeline Options in Excel - Instructions: A picture of a user modifying the appearance of a timeline in Excel.
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
Read more
No Comments

Forecast Sheets in Excel – Instructions

Forecast Sheets in Excel - Instructions: A picture of a forecast sheet created in Excel.
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.
Read more
No Comments

Format Trendlines in Excel Charts – Instructions

Format Trendlines in Excel Charts - Instructions: A picture of a user formatting a trendline in an Excel chart using the “Trendline Options” section of the “Format Trendline” task pane.
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
Read more
No Comments

The Eraser Tool in Photoshop Elements – Instructions

The Eraser Tool in Photoshop Elements - Instructions: A picture of a user applying the background color by using the Eraser Tool in Photoshop Elements.
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,
Read more
No Comments

The Lasso Tool in Photoshop Elements – Instructions

The Lasso Tool in Photoshop Elements - Instructions: A picture of a user making a selection with the Lasso Tool in Photoshop Elements.
The Lasso Tool in Photoshop Elements: Overview             The Lasso Tool in Photoshop Elements lets you draw free-form selections to make curved selections. It shares the same button in the Toolbox with the Polygonal Lasso Tool and the Magnetic Lasso Tool. Because each tool behaves differently, you will have to look at how to use each
Read more
No Comments

The Smudge Tool in Photoshop Elements- Instructions

The Smudge Tool in Photoshop Elements- Instructions: A picture of a user applying the Smudge Tool in Photoshop Elements.
The Smudge Tool in Photoshop Elements: Overview             When you select the Smudge Tool in Photoshop Elements and click and drag it in an image, it produces an effect similar to the effect of dragging your finger through wet paint. The Smudge Tool in Photoshop Elements picks up the color of the place at which
Read more
No Comments

Import Preferences in Lightroom Classic CC- Instructions

Import Preferences in Lightroom Classic CC- Instructions: A picture of the “General” tab in the “Preferences” dialog box in Lightroom Classic CC.
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
Read more
No Comments