Change the Tone Curve to allow it to behave as a draggable Point Curve
In Lightroom, you can make the Tone Curve behave as a Point Curve clicking the Click to edit the Point Curve indicator at the foot of the Tone Curve panel.
When a tone curve is set to be a point curve you can drag on any point on the curve to adjust the tones in the image at that correspond to that point on the curve.
With the point curve selected, click on the Targeted Adjustment Tool in the top of the Point Curve dialog and drag on the image to lighten or darken the image at that point. Drag upwards to lighten, down to darken.
To delete a point on the curve, hold your mouse over the point, right click (Command + Click on the Mac), and select Delete Control Point.
Learn how to use a spin button (also called a spinner) form of control in Excel to aid in data entry. Using a spin button, a user can click the button to increase or decrease a value in a worksheet cell.
This video explains how to access the Developer tab, then, how to add the spin button form control and, finally, how to set up the control. It also explains how to scale the value that the control provides so it can provide percentages and very large or very small values. This feature is in Excel 97, 2000, 2002, Excel 2007, Excel 2010 and Excel 2013.
Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial we’re going to have a look at creating spin buttons in Excel to make data entry just about as much fun as data entry can be. Before we get started with spinner controls let’s have a look and see what we’re talking about.
Here is a copy of the worksheet that we’re going to be working on and this is the spin button control. It’s been set to work between 20 and 30 so it will take a value between 20 and 30 years and every time I click the down arrow it decrements this cell by one so that the overall payment per month on the mortgage is increased because the term is much shorter. When we increase the term on the mortgage by clicking on the up arrow the overall payment is reduced. And it stops at 30.
So let’s see how we would add the spinner control to this particular worksheet.
Well first of all you have to have the Developer tab available. It it’s not choose File and then Options and in Excel 2013 and 2010 you’ll go to the Customize Ribbon button here and you’ll check this Developer tab here so that turns it on. In Excel 2007 you’ll go here because there will be an option here for Show the Developer Toolbar in the Ribbon.
So once you’ve got the Developer toolbar available click it and then take this Insert option and you want the form controls. Now the Active X controls look pretty much the same thing but they work very, very differently. And what we want are the simple form controls because they’re the easiest to use. I’m going to click here on the spin button control and then I’m going to click and drag to create the control on my worksheet. Now I can resize it later on but I’m going to start by drawing this size.
I’m now going to right click it and choose Format Control. And this gives me my options for formatting the control. To start off with I can set its current value. So I can start it at for example 25 and then I can set its minimum value which I had previously set to 20 so all our mortgages are going to tested between 20 and 30 years in length. And then I’m going to make the maximum value the 30. So we’re going to move between 20 and 30. And the incremental changes how big a change do I want to happen with each click of the button. Now these have to be integers so one is the smallest value. And cell link is a pointer to the cell that I want the value to be inserted in so I’m going to click in here and then click in this cell because this is going to be my link cell and click Ok.
You can see that the cell value changed to 25. That’s because that was the starting value. Now if I click on the spin button right now nothing is going to happen because it’s still active. So I’m just going to click outside it and now I can test it. You can see I can click up but when I get to 30 I can’t click it any more and then it will click down. And when I get to 20 it won’t go any lower.
So that’s a spin button control that you can use to control this sort of value. But there are some limits to spin buttons that we’re going to have to get around. One of them is that they only return integer values and the maximum value is 30,000. So right now that would cause us some problems in trying to add the mortgage amount which is in the region of 200,000 or more when the maximum value is 30,000. And here the interest rate is 5 percent. That’s .05. That’s not even an integer. It’s not even a one. So we’re going to have problems controlling that. And we’re going to have to find a way around it which of course can be done easily.
To see how we would deal with the situation where the amount borrowed is a much larger figure than we can use in the spin button control let’s have a look at this worksheet. In this worksheet we’re looking at how we could possibly scale a range of 0 to 30,000 to actually work for us. Let’s say that the minimum amount that we want this mortgage calculator to work for is 100,000 and the maximum is one million. Well let’s look and see what 100,000 is. Well 100,000 is 10 times 10,000 and a million is 100 times 10,000. So we could have our spinner work between 10 and 100 if we could scale it up by 10,000 each time. I’m going to replace the formula with a value and it’s going to multiply the contents of cell D2 by 10,000. Now there’s nothing in cell D2 right now but we know that we can put a value in there using a spin button.
So again Developer, I’m going to Insert and I’m going to select the Spin Button Form Control. I’m going to drag to create it on the worksheet, right click it and choose Format Control. This time I want my minimum value to be 10 because I’m going to use a 10 to 100 scale here. The maximum value is going to be 100 and I’ll have it increment by one digit at a time which is going to be 10,000. I’m going to set my current value to, for argument sake, 20 so that we’ll get back our 200,000 in this cell. And the cell link cell is going to be the cell that has the value in it that this formula is using. When I click Ok let’s see how it’s working.
As you can see the spin button here is giving us this value here of 20 and in this cell we’re just taking the value of 20 and scaling it up. So now if I click on this button it’s going up by 10,000 every click of the button and it’s going to max out at one million. And if I were to come down then it would max out in the bottom direction at 100,000. And each time as I click on the button, well I’m sitting on the button right now, but as I click on the button the amount that we’re paying each month is being recalculated accordingly. So scaling up like this is a way of getting larger values than the 30,000 that we’re allowed in the spin button control. Of course that’s preempting the solution for this value here. All we need to do now is to scale this downwards. So let’s see how we do that.
To reduce a value using a spinner we’ll work the opposite direction. Let’s say that we want an interest value between 2 and 10 percent. That’s between .02 and .1.
.02 can be represented by 2 times .01 and 10 by 10 by .01. Now that’s only going to give us whole interest values so I don’t think it’s going to be quite big enough. Let’s go down a scale and let’s say it’s 20 multiplied by .001 and 100 multiplied by .001. That’s going to give us additional percentages in the range so instead of going 2 percent, 3 percent, 4 percent we can go 2.1, 2.2, 2.3 and so on. So let’s take this scaling back to our worksheet. Again we’re going to add a spin button here so from the Developer toolbar Insert make sure that you’re using this form control and drag a spinner into position. We’ll right click it and choose Format Control and we’re going to use cell D3 as our intermediate cell. The minimum value is going to be 20. The maximum value from our previous calculations on the other worksheet is 100. We’ll use an incremental change of one for now and the cell link will be this cell here D3 and press Ok.
Now nothing is actually happening because we haven’t put our formula in here yet. The formula multiplies this value here by .001. And here is our smallest value 2 percent. We’ll need to reformat this cell so I’m going to the Home tab of the Ribbon and I’m going to increase the decimal places here so that we can see exactly what values we’re getting and not rounded values. Here everything is now going up in .1 of a percent. And it will max out at 10 percent because that’s where we set it to max out at. It won’t be able to go any larger than that.
Now all we need to do to make this worksheet a little bit neater is just to hide the column that contains those intermediary values. And now somebody can use this calculator to calculate a loan and instead of having to put value in here manually they can just click on the spin button controls to do it automatically.
I’m Helen Bradley. Thank you for joining me for this video tutorial. Look out for more of my video tutorials on this YouTube channel and visit my website at projectwoman.com for more tips, tricks and tutorials on a range of Office programs including Excel, Word, Outlook, PowerPoint and Publisher.
Using the Tone Curve, you have the choice of preset settings: Linear, Medium Contrast or Strong Contrast. Use these as a starting point for adjusting the image.
Select the starting point then drag the Highlights and Lights sliders to the right to lighten these areas. Drag to the left on the Darks slider to darken the Darks. To bring detail out of the shadows, drag to the right on the Shadows slider.
Fall in love with silky water photography – it’s so easy when you know how
You have probably seen images like the one above that feature impossibly smooth water.
You might have even asked yourself how it was done? Or perhaps you think it is something that can’t be done without expensive equipment and lots of know how.
Well that’s not true. I shot this image with no extra equipment and I’m going to tell you how.
The secret is to shoot really slow. This image took 10 seconds to shoot.
Now I can’t stand still for 2 secs, much less 10 and neither can you so start by finding somewhere to put the camera. I found a place for it at ground level and took a test shot to see it would work, which it did. I backed off the zoom and the composition was pretty good.
So, I had a sturdy place to shoot from. Now, how to easily slow everything down?
You see, slow shooting is what you need for this image. In this night shot the only thing that will be moving a lot is the water. If you can capture the image over a long enough time the movement of the water will blur deliciously and the buildings will remain sharp. That’s the secret to the shot – a long exposure that blurs the water but leaves everything else nicely exposed and sharp.
One option for a long exposure is to use Tv mode on the camera – fancy speak for controlling the speed of the camera. I opted not to do this as I really wanted to use a small aperture and I didn’t want to let the camera choose the aperture size – it would have chosen too large a size resulting in a smaller depth of field – I wanted a deep depth of field so everything would be in focus.
I could have used Manual mode but then I’d have had to make calculations for the shutter speed – too much time and effort to get this right.
So, I selected Av or Aperture Priority mode and set the aperture to f/11. That is a very small aperture so the shot is going to take some time to capture – especially after dark. So far so good. But I wanted it to be slower still and I didn’t want a lot of noise messing up the image.
The next setting was for ISO which is sensitivity. You use small values like 100 in the daylight and 6400 at night. I set it to 100 – totally the wrong setting for shooting at night because it makes for long shutter speeds but remember we want silky water so it works here. Also a small ISO like ISO100 means less noise than higher ISO values. Don’t get me wrong, I love noise in my images but in its place – I didn’t want it for this image.
So ISO100 both slows down the shot and reduces noise.
So, now the camera is set up, it is nearly time to shoot.
The final camera setting is to set it up for continuous shooting. Ideally you need to take a few shots at once so you want to press the shutter down and hold it and have the camera take a few shots in a row without you having to repeatedly press the shutter. The problem with pressing the shutter is that it moves the camera and movement = blur which is so not what you want.
Continuous capture means you sit with your finger on the shutter so you don’t move much except on the first and last shot – that’s why you take a few – the first and the last will probably have movement because of the shutter press and release – the shots in the middle should rock!
Now place the camera in the place you already determined it is secure and steady. Steady yourself – I sat down beside it – press the shutter and hold it.
Wait through at least 3 shots (remember the first and last in the sequence are probably ruined so you need at least 3 and preferably more).
When the sequence is complete, review the shots, correct any issues and try again. I took about 4 series of 4+ images to get a couple that were great.
When you’re printing, you’ll want a good range of tones across your image from the blackest of blacks to the lightest of lights. Use the Blacks adjustment slider to ensure that you will have some black tones.
To see the blacks in the image, hold the Alt key (Option on the Mac) as you drag on the Blacks slider and stop when you see the first few colored pixels appear on the screen
Learn how to create a layered image effect that can be reused any time. The process can be done in most versions of Photoshop and it uses smart objects, simple to create clipping masks and some layer blending. It is pretty easy to create and can be used over and over again.
Transcript:
Hello, I’m Helen Bradley.
Welcome to this video tutorial. In this tutorial I’m going to show you how you can create a quick cut and layer image effect that’s sure to turn any image into something that looks just a little bit more spectacular.
Before we get started with this project let’s look and see what it is that we’re aiming at. Here is my original image and this is the effect we’re going to create. We’re going to create a number of layers or what look like layers of the image and we’re going to blend them together. Now this effect is customizable.
It’s really easy to select one of the shapes and to move it so that everything gets rearranged and it’s also really easy to replace the base image. So let’s get started. And I have a new image to work with here. I’m going to start by converting the image to a Smart Object.
So I’m going to right click the background layer and choose Convert to Smart Object. And now we’re going to start adding our layers of shapes. So I’m going to click to add a new layer. Let’s get my tool bin. I’m going to select the Rectangular Marquee tool. And let’s create a shape. I’m going to create this big rectangle here.
With this layer selected I’m going to make white my foreground color and Alt Backspace, Option Delete to fill the shape with white. Now in each case I need the layer and the image so I need multiples of this pair of image. So I’m going to right click and choose Duplicate Layers and click Ok. Now I’ve got my second shape up here.
I’m just going to turn off my images so that we can see the shapes alone. And I’m going to move this shape out of the way and I’m just going to resize it to a different size shape here. I’m going to select these two layers, right click and duplicate them again. And now I’m going to this top version and I’m going to again alter it a little bit.
You don’t have to alter it. You can leave it exactly the same shape if you want to. Select the two layers, right click, Duplicate Layers, click Ok, again selecting this top one and just moving the shape into position and resizing it to suit. Now that we’ve done this we can start to create the effect.
And what we’re going to do is we’re going to crop these images. So I need one more of this Smart Object layer so I’m just going to duplicate this layer once more and drop it on the top. Now I’m going to create a clipping mask. So with these layers all visible and all selected first of all I’m going to select the topmost layer and I’m going to choose Layer > Create Clipping Mask. And what that does, let’s just have a look, is it clips the top layer to the shape and size of the layer below.
So when we turn these two on and create a clipping mask here, Layer > Create Clipping Mask, we’re going to get a built up effect. Let’s do that again here and create a clipping mask. First of all we need to turn these two layers on and then with the picture layer selected we can choose Layer > Create Clipping Mask or you can do it using the keys.
What I do is hold down Ctrl and Alt, which is Command and Option on the Mac, and just hold my mouse over the intersection between these two layers until I get this icon and then click once. Now I find that a whole lot easier and you may too if you create a lot of clipping masks. It’s really important that the clipping masks are filled with white.
Now in normal circumstances it doesn’t matter too much what you fill your clipping mask layer with but in this case it’s going to because we want to reduce the opacity of the layers a little bit so that we can see some of the background through. And so when we add two layers together, when we overlap two layers, we’re going to get a darkening in the area where they overlap.
So first of all I’m going to adjust the opacity down a little bit and now I’m going to select all of these layers by Ctrl or Command clicking on each of them in turn and set their blend mode to multiply. And what that does is it multiplies the fill layers so that the layers are built up so that we get some overlap between these layers so we can start seeing where they’re overlapped.
And from here you can just tweak the effect to darken or lighten the individual layers as you want to so that you get the effect that you’re looking for. And you can also fill in the background. So we can add a new layer, drag it to the very bottom of the layer stack and then fill it with whatever we like. I’m actually going to sample some of the yellow color from this leaf and with the layer selected I’ll Alt Backspace on the background layer to fill it with that.
But I could also fill it with a gradient. I could do all sorts of things. Now the important thing to know is that once you’ve created this effect it is fully customizable. So it’s very easy to replace this image with another image. All we need to do is to right click the layer, one of these layers that is a Smart Object, any one of them will do, and choose Replace Contents. So now what I’m looking for is an image to replace the contents with.
The image doesn’t have to be in the exact same proportions. We were using a landscape image but these are square images. But they do need to be good size images. So I had a really large image that I was working with so I want this image to be nice and big. And this one is 3,100 pixels so it’s pretty big. So I’ll select it and click Place and when I do it’s replacing the original image.
And I may want to adjust the opacity of these so that I get the effect that I’m looking for. For example, I mightn’t get enough of a layering effect without adjusting the opacity. And I may also want to adjust the background of this image to give it a darker background in these circumstances.
But it’s very easy to just reuse all of the basic work that you’ve done with this image and just replace it with another image. So I’m just sampling a color to use, Alt Backspace to fill the background. And there we have our effect. You could also use a color for these clipping mask layers but be aware that any color that you use is going to come through the images.
So let’s just make black our foreground color. Let’s just target this particular layer here and I’m going to Alt Backspace to fill it with black. Well you can see that the multiply effect has totally blackened that out. But if I use a sort of fairly light color here, well this is sort of a pale blue, but you’ll get the same effect, and fill it here you’ll see that we get a slightly darker look.
So we can darken this and have an effect on the image. The darker the color we use we’re going to not only see the color itself or example if we use pink we’re going to see the color through the image but we’re also going to darken up the effect.
Now it would be possible for example to choose different colors. So I’ve got some pastel colors that I’m filling these with. Let’s go for a sort of pastel blue here. And you can see the effect that it’s having, well I chose the wrong layer there. Let’s just undo that. Let’s go to this one and actually select the layer and fill it with a pastel blue.
So you could do that as well. And of course any time you choose to replace the image these color layers are going to stay in place so that you’ll get the effect on the new image that you’re replacing this one with. So there’s plenty of creative possibilities here in creating a layer image effect in Photoshop.
I’m Helen Bradley.
Thank you for joining me for this video tutorial. Subscribe to my YouTube channel so you’ll be advised when new videos are released.
And visit my website at projectwoman.com for more tips, tricks and tutorials on Photoshop, Lightroom, Illustrator, Photoshop Elements and a whole lot more.
See your document as a web page and keep it looking that way
To see how any of your Word 2010 and 2013 documents will look when they are saved as web pages, select the View tab on the Ribbon, then click Web Layout.
Now, to save a document as a web page, select File > Save As. In the Save As dialog, under click the Save as type: dropdown list and choose Web Page (*.htm;*.html).
Make sure to choose a location to save the document in, give it a name (it should have the .htm extension), and click Save.
Understand the differences between Vibrance and Saturation
The difference between Vibrance and Saturation is often misunderstood. If you drag the Vibrance slider to the right, you increase the saturation in under-saturated colors in the image. Fully saturated colors are adjusted less and skin tones are protected.
In contrast, increasing the Saturation boosts the saturation across the entire image which can destroy skin tones and which can oversaturate already saturated colors.
Typically you’ll use Saturation if your image needs an overall boost to all colors and use Vibrance to boost under-saturated colors.
Many of the fixes we commonly apply to images come from darkroom processes. Contrast masking is one of those fixes and it can be used to fix an image which is under or over exposed.
Contrast masking is a relatively simple process and it can work wonders with your images. I like it because it generally doesn’t require you to make selections and there is a lot to like about fixes that don’t involve selections.
Here’s how to use Contrast Masking to fix an under exposed image:
Open your image and duplicate the background layer. Target this duplicate layer in the Layers palette.
Desaturate this layer by choosing Image > Adjustments > Desaturate. Right now the default convert to black and white is just fine.
Alter the blend mode of this layer to Overlay.
To invert this black and white layer choose Image > Adjustments > Invert – this gives a negative of the image.
Adjust the layer opacity to suit.
Convert the top layer to a Smart Object by choosing Filter > Convert for Smart Filters.
Now blur this layer by choosing Filter > Blur > Gaussian Blur. Adjust the Radius to adds some sharpening back to the image. Check the preview to get the best result for the image.
Learn to recolor clip art using theme colors so it is not only the color that you want it to be but it also matches the theme and it changes color when the theme changes.
This works with pretty much all versions of Office and all apps including Word 2013, PowerPoint 2013, Excel 2013, Publisher 2013 and older versions of Office including 2010, 2007, 2003 and earlier.
Transcript:
Hello, I’m Helen Bradley.
Welcome to this video tutorial. In this tutorial I’m going to show you how you can easily recolor clipart in Microsoft Office and how you can use theme colors so that your clipart changes when your theme changes.
Before we get started with this tutorial let’s have a look and see what it is that we are trying to achieve. This is the same piece of clipart and I just made a duplicate of that clipart image and I recolored it in the way that I’m going to show you how you can recolor your clipart. But let’s have a look and see the impact of the recoloring.
I’m going to choose the Colors tool here and watch as I arrow over all of these colors in turn. And you’ll see that the clipart image that I have recolored I have recolored this time with theme colors. And the beauty of this is that the clipart image is going to change colors in accordance with the theme that is in use.
The only thing that hasn’t been recolored is the black and the little yellow light in the candle. Everything else is a theme color and it’s going to change color using the new theme colors whenever the theme or the design of this PowerPoint presentation changes. So this is the concept that we’re going for here.
Now I have a slightly simpler image here. All I did to find these images was I chose Insert and then Online Pictures and I went looking for cake. And I particularly wanted wmf files as that’s Windows metafile and that is an illustrative file most of which can be recolored inside of PowerPoint or Word or Excel or any of the Microsoft applications.
And you don’t have to be using Microsoft Office 2013. You can choose any version of Microsoft Office. I’ve been doing this for years in Microsoft Office. It’s just that the way that you add images is a little bit different in this new version. Now before I start let’s just take a copy of this image and let’s paste it so that we’re working on a duplicate.
We can see then how far we’ve come later on. I’m just going to get rid of these images. Now with the image that I’m working on selected I’m going to choose Picture Tools, Format tab and I’m going to choose Group and then Ungroup.
Now you’ll see that the group option sometimes is not available from this dropdown menu but it will always be available from the Picture Tools, Format tab if the image is able to be ungrouped. You’ll get a message showing that this is an imported picture and not a group and asking you if you want to convert it to a Microsoft Office drawing object.
The answer to that is yes. And then you’ll go and repeat the process. You’ll right click and choose Group, Ungroup or from the Drawing Tools, Format tab you’ll choose the Group button here and choose Ungroup.
That ungroups the object so it’s now a whole lot of smaller objects. I’m just going to click outside it and then we’re going to start selecting individual pieces of this object. And I suggest that you start with a nice color scheme. So I’m just going to go to the color schemes and let’s choose something relatively colorful.
I found slip stream was a good option to use but any of these such as red violet that is fairly colorful is a good choice. Drawing Tools, Format tab and now from the shape filled dropdown list we’re going to make sure that we recolor all of the shapes using the fill colors that are theme colors.
So, again, I’m going to select here, this is on this sort of turquoise bit, and I’m going to color it a darker version of that same blue. I’m going to click on the candle light and see if I’ve got something I can use for candle light. I think I’m going to choose one of these colors because I would really like my candle light this time to be a theme color.
To select multiple colors or multiple shapes at a time I’m just selecting the first and then Ctrl clicking on the last. And again, I want these to be colored the same color as the candle light. Now I’m going to click here. There’s a shape here.
If you ever want to see what the shape is that you’re working on just press the Delete key and it will disappear and then you can undo it to be able to work on it. Or of course you can just fill it and see what it is that you are actually filling.
So I’m going to select that color. And now we’re going for this shape over here and I want a slightly darker or lighter version here. I think I’m going for a darker version. And here we have the shadows. Again, I’ll want a darker color for the shadow. I think I’ll go back for these blues. I’m going to stick to the turquoises and this sort of purple color.
So I’m going to now select these smaller items here and when I’ve got them selected I’m going to fill them as well. And when I’m pretty happy with my shape that has been recolored I’m going to select over the entire shape because now what I want to do is to stick it all back together again because I don’t want lots of little pieces.
Drawing Tools, Format tab, Group and this time I want to Regroup. And I’ll just test this by moving the object and it should all move as one. And now let’s look and see that this object is going to recolor unlike the original object if we change the color of this particular design that we’re using in PowerPoint.
So I’m going to choose the colors dropdown list here and as I choose a different color scheme you can see that my clipart shape is changing color. And as I said this works exactly the same way in any of the Office applications and in pretty near any version of these. You can do this in Word 2003.
You can do it in PowerPoint, Excel, Publisher, any of the applications and you can create clipart so that it not only matches the current theme but also looks the colors that you want it to look but which will change colors as the theme colors change.
I’m Helen Bradley.
Thank you for joining me for this video tutorial. Look out for more of my PowerPoint and Microsoft Office tutorials on this YouTube channel.
And visit my website at projectwoman.com for more tips, tricks and tutorials on a range of Microsoft Office applications as well as Photoshop, Lightroom, Illustrator and a whole lot more.
