Conditional Formatting in Excel – Instructions

Conditional Formatting in Excel - Instructions: A picture of a user selecting a custom conditional formatting choice from the “Conditional Formatting” button’s drop-down menu.
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
Read more
No Comments

Workbook Protection in Excel- Instructions

Workbook Protection in Excel- Instructions: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.
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
Read more
No Comments

Change Worksheet Tab Color in Excel – Instructions

Change Worksheet Tab Color in Excel - Instructions: A picture of a user changing the worksheet tab color in Excel.
Change Worksheet Tab Color in Excel: Overview             You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse
Read more
No Comments

Freeze Panes in Excel – Instructions and Video Lesson

Freeze Panes in Excel - Instructions: A picture of a user selecting the Freeze Panes button in Excel.
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
Read more
No Comments

Remove a Color Cast in Photoshop Elements – Instructions

Remove a Color Cast in Photoshop Elements - Instructions: A picture of a user removing a color cast from an image in Photoshop Elements.
Remove a Color Cast in Photoshop Elements: Overview             You can easily remove a color cast in Photoshop Elements from an image. A color cast occurs when the color channels in an image are not in balance. The undesired effect is often an unusual tint of color and is a common result of improper lighting
Read more
No Comments

Change the Color Saturation in Lightroom Classic CC – Instructions

Change the Color Saturation in Lightroom Classic CC - Instructions: A picture of a user changing the color saturation of an image in Lightroom Classic CC by using the sliders at the bottom of the “Basic” panel in the Develop module.
Change the Color Saturation in Lightroom Classic CC: Overview             You can change the color saturation in Lightroom Classic CC to adjust a photo’s overall color saturation. Color saturation in photography describes the intensity of a color. It is expressed as the degree to which the color differs from white.             To change the color
Read more
No Comments

Remove a Background Using Photoshop Elements

Remove a Background Using Photoshop Elements: A picture of a user removing a background using the Background Eraser Tool in Photoshop Elements.
Remove a Background Using Photoshop Elements: Overview             You can easily remove a background using Photoshop Elements. The Background Eraser Tool lets you erase pixels on a layer to transparency as you drag. This lets you remove a background using Photoshop Elements while maintaining the edges of a foreground object. You use the tool’s settings
Read more
No Comments

Watch Folders in Photoshop Elements – Instructions

Watch Folders in Photoshop Elements - Instructions: A picture of the “Watch Folders” dialog box in Photoshop Elements.
Watch Folders in Photoshop Elements: Overview             If using Windows, you can specify watch folders in Photoshop Elements. Watch folders are folders the Organizer watches to look for new media you add to the folders. By default, the “My Pictures” folder is the default watch folder in Photoshop Elements. You can also specify additional folders
Read more
No Comments