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
Custom Color Schemes in Publisher: Overview You create custom color schemes in Publisher to apply colors you select to publication elements in a consistent way. To create custom color schemes in Publisher, click the “Page Design” tab in the Ribbon. Then click the “More” button in the lower right corner of the “Schemes” list.
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
Workbook Protection in Excel: Overview When you apply workbook protection in Excel, users cannot add, delete, hide, rename, or move workbook worksheets. You can also provide an optional password that must be entered before the workbook can be unprotected. This option is also a bit risky, because if you forget the password, you cannot
Use a Top 10 AutoFilter in Excel: Overview You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
Freeze Panes in Excel: Overview You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. Then you can then scroll the unfrozen section of the worksheet to view
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,