When you have “divergent” data, i.e. # of sales reps and the total $ of sales, a chart with a trendline going across is more usful than displaying two bars. It works differently in 2010 and 2013. I have a video on each method posted.
In this example, the video shows you how to crop a photo, get rid of extraneous items in the photo. Video produced with Elements 13 and works with earlier versions and with Photoshop. Discover how to sharpen a photo.
Sometimes you are working on a spreadsheet with lots of text in it and sometimes too much spaces as shown below.
David Smith Jr.
The TRIM function will get rid of the excess spaces.
There may be a time when you want the ROUNDED values to add up correctly, for example, 7.7 rounds to 8, 4.5 to 5, 6.5 to 7. You want the rounded values to add up. This video will show you how to do it.
This tutorial will work with earlier versions of Photoshop Elements that has adjustment layer feature. In this tutorial, use the guided mode to adjust color in a photo taken with a mobile phone (with no flash). We go over to the expert mode, create a new layer and add an adjustment layer to it. Most of it is fairly easy. To erase/add to the adjustment layer, you must first click in the white box shown in the layers box. Select the brush tool, it becomes black/white.
For those of you who use Excel, this video on The Theory of Relativity may help you determine how to create a constant in a formula either by cell, row, column, or completely relative.
The more you practice with this, the easier it gets. The bottom line is that if you have columns or rows of formulas, they should drag down or across so that you don’t have to redo the formulas countless times.
Many of us are still using Windows 7 – probably the best Windows system. This tutorial shows you how to choose a program to open a file in. In addition, discover how to view files as thumbnails, details, and to preview.