Saturday, July 5th, 2014

Lightroom – Hand Tint a Photo Effect

Create an Old Time Hand Tint Effect to a Photo in Lightroom

Learn how to apply an old time hand tint effect to a photo in Lightroom. You will see how to convert the image to black and white and then how to color it using the  Adjustment Brush. This technique can be applied to a range of images and the effect works well when you want a hand tinted look for your photo.

Helen Bradley

Tuesday, July 1st, 2014

Illustrator – Paint Vector Shapes with the Blob Brush

Paint Vector Shapes in Illustrator Using the Blob Brush

Harness the power of the Blob Brush in Illustrator

Learn how to paint vector shapes in Illustrator using the Blob brush new in Illustrator CS4. This cool tool lets you draw shapes as easily as painting them and doesn’t require you to use the Pen tool – which lots of Illustrator users hate!

This video also covers use of the Smooth and Pencil tools for reworking vector paths in Illustrator.

Thursday, March 20th, 2014

Photoshop – Recover an Unexposed Subject

Add an Artistic Effect to the Overall Image in Photoshop


Learn to recover an unexposed subject in your photos and how to add an artistic effect to the overall image in Photoshop.

Helen Bradley

Saturday, March 1st, 2014

Create a Graffiti Wall Effect in Photoshop

Learn to paint graffiti without a risk of being arrested

See how easy it is to create a graffiti effect on a wall in Photoshop. The video shows you how to use a graffiti font to create graffiti writing and how to use styles and colors to format the test to make it look like real graffiti. Then see how to use the Vanishing point filter to place the graffiti text onto a wall in a photo. Finish the effect by blending the text with brushes, blend modes and textures all created using layers and masks so that the effect can be edited in future.

Helen Bradley

Wednesday, February 26th, 2014

Excel – Replace charts with pictures

Enhance your Charts with Visuals

by Helen Bradley
Why have boring old column and bar charts when you can have picture charts instead?

Learn how to replace bars and columns in Excel charts with small images stacked up to show the values being compared.

Image charts like this are one of Excel’s secrets so let me show you how to make them.

In the video you will learn how to replace columns and bars in Excel charts with images. You will see how to find images to use and how to stack and resize the images to fit the chart’s columns and bars.

Helen Bradley

Wednesday, February 19th, 2014

Photoshop – Color Threshold Art Effect

Adjust Color and Contrast to make your Image Pop

by Helen Bradley

The threshold filter in Photoshop lets you turn an image into a black and white image where pixels are either black or white. It is a great tool when combined with some color for creating artistic effects with your photos.

The only issue with this filter is that you have no fine control over how the conversion takes place. This video solves the problem by showing you how to work with the image to give better results with the conversion.

Here you will learn how to use the threshold filter to adjust the image to make a black and white and how to pick out areas of the image to adjust them separately so you retain the details in it.

You will use masks and adjustment layers to lighten and darken those areas of the image that you wan to keep and highlight.

You will also learn how to create a reusable noise layer to give the final image a more grainy look.

You will also learn why using a fill layer makes better sense than filling a layer with color.

In all, this video is jammed full of handy Photoshop tips as well as showing you how to create a great color effect.

Helen Bradley

Helen Bradley

Friday, August 2nd, 2013

Photoshop – Create an Oval Frame Effect

Learn how to create an oval frame effect in Photoshop. This video includes how to use a clipping mask, sample a color from an image, make a leaf brush, paint multi-color leaves on an image, add a stroke border to the oval frame and even change its color. This is a jam packed tutorial suitable for a competent beginner or intermediate level Photoshop user.

Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can make an oval framed photo effect in Photoshop. Before we get started doing this effect let’s have a look and see what it is that we’re aiming for.

What I’m going to do is take this image here and frame it inside an oval frame. And we’re going to add a little border stroke around the frame and then add these decorative elements. The colors for each of these elements is going to be sampled from the image and this is just a single brush that paints in different colors. So if you’re ready let’s get started with this tutorial. So if you’re ready let’s get started with this tutorial.

I’m going to begin here with a new image so I’ll click File, New and I’m just going to do an 11 by 8-1/2 letter size image. But you can make yours whatever size that you like. And here’s my image.

I’m going to center the oval so I’m going to start with a couple of guides. I want a 50 percent guide horizontal and a 50 percent vertical. It’s just a little bit easier to do this with guides. Then I’m going to target my marquee tool. I want the elliptical marquee tool. It shares a toolbar position with the rectangular marquee. But it’s the elliptical marquee that you want. I’m going to hold my mouse pointer over the intersection of these two gridlines and then hold Alt down as I drag out to create my oval. This creates an oval that’s centered over those lines. Of course if I add a Shift key at this point I’ll have everything constrained to a perfect circle centered on this document. But I want an oval so I’m going to let go of the Shift key but make sure that I keep the Alt key held down until I’ve finish drawing my shape. I’ll let go the left mouse button and then let go of the Alt key. This is my shape.

I’ll need a new layer so I’ll click the New Layer icon here and I’m going to fill this with black. So I’m just going to set black as my foreground color and Alt Backspace, Option Delete on the Mac. You can fill it with any color at all but I’m just using black. Now I can get rid of my guide so I’m going to click View and I’m going to clear my guides. I’m going to bring in my image here so I’m just going to drag on the background layer and just add it to this image. Now I want it centered so I’m going to press the Shift key as I center it over this image. I can now close this because I don’t need it any longer. I have my oval still selected. You can probably just see the marching ants there. Now that’s going to get in the way when I start to resize and move this image so I’m going to press Ctrl or Command D to deselect the marching ants. Now I’m going to target my move tool, Ctrl T, Ctrl 0 so I can see my handles. I’m just going to drag everything into position. I’m going to use the Shift key with that corner handle because that will drag everything in proportion. I’m now going to create a clipping mask.

So with this layer selected, Layer, Create Clipping Mask. Now I need to select that checkmark before I can do that so let’s create the clipping mask. And now let’s just fine- tune this image. And I think that’s a pretty good position for it. Now I want to focus on the background layer because I want to sample one of the colors from this image for the background layer. Now the image that we saw had a background which was sampled from the image. So I’m going to target the eyedropper tool here and I’m just going to target this little girl’s dress to get a color from her dress. And when I do you can see that the color is in the top of the ring here. That’s the one I’m going to select. And I have a 3 by 3 average so I’m averaging out the colors under the cursor. So I could go for a slightly lighter blue if I wanted. Let’s select that. And now with the background layer selected I’m going to Alt Backspace, Option Delete to add that color. Now let’s go and add a border around this oval. And to do that I’m going to need to reselect the oval. So I’m going to target the oval shape here, click on the magic wand tool here, it shares a toolbar position with the quick selection tool, but we want the magic wand. We want to make sure that Contiguous is selected. And now I’m just going to click here on this underlying shape which is this black shape here and that gives me this selection.

I’m going to add a new layer so I’m just going to make sure that my new layer goes in at the top and it’s not part of this clipping group. If it were I would have to right click it and choose Release Clipping Mask but it’s now not part of that group. You could see that the marching ants are in position so what we need to do now is to select the color to use. So again I’m going to use the eyedropper and I’m going to select a greeny color from the grass in the background here. So we’ll select that, Edit, Stroke. And you’ll need to experiment a bit with the stroke to see what works best with your image. But I found that a 20 pixel stroke on this particular image is pretty good so I’m just going to settle for a 20 pixel stroke. And I’m doing it over the center and I’ll click Ok. And there’s my stroke. To deselect the marching ants Ctrl or Command D. Now we’re in a position to brush on some leaves around the edge of this image. But to do so we’re going to need to create a brush first up. So let’s go and create a brush. If you’ve already created a brush or you have a brush that you want to use you can skip this step but I’m just going to show you quickly how I created my brush.

I’ll choose File, New and just click Ok. I just need any old document here. I’m going to select the custom shape tool here. It shares a toolbar position with the rectangle tool and these other tools. But it’s custom shape that I want. From the options here on the toolbar I want to select Pixels and I’m going to select black and white as my colors. In earlier versions of Photoshop you’ll still have these three options but they’re going to be side by side here. You just want to make sure that you select the fill pixels or the pixels option. Here I’m going to select a shape which is a leaf shape.

Now last time I selected this shape so let’s make a different shape this time. I’m going to select this one here and then I’m going to drag to draw it on the image. And I’m going to hold the Shift key down as I did so it’s constrained to a nice proportion. Now all I need do is to select Edit and then Define Brush Preset. And I’m going to call this leaf and click Ok. And that is now that shape is now saved as a brush so I can just discard this image. I don’t need it any longer. Now I can go and select my brush. So I’m going to target the brush tool and from the brush dropdown list here I’m going to select my brush. And my brush is always going to be the very, very last one in this brushes palette if I’ve just created it. So this is my brush.

I’m just going to click to select it and then just click outside here to hide that window. Now you can see that the brush is huge and way, way too big right now. So I’m just going to press the square bracket key, the opening square bracket key, to just size it down to size. Now if I start painting I’m first of all going to add a new layer and I’m going to just sample a color from this image. So let’s sample this orange color and let’s just see what happens if I start to paint. Well it’s not looking anything like what it is that we want it to look like. So I’m just going to Ctrl Z to get out of there and let’s go and set up our brush so it paints a little bit more intelligently. I’m going to click here to open the brush panel.

Now in the brush panel here the first thing I want to do is go to brush tip shape, tap on it and I’m going to increase the spacing because I want this brush to be spaced out quite a bit. I could change the size at this point if I wanted to but I’ve already measured this and it’s a pretty good size so I’m going to leave that. I’m going to enable Shape Dynamics and click on Shape Dynamics. Now I want the size to vary a little bit so I’m going to adjust the size jitter. That will make it size in different size brushes as I paint. And I’m also going to adjust the angle jitter. Now I can adjust it to quite a high value here because I don’t mind if these leaves point in completely the opposite direction. In fact that’s going to look pretty good for my leaves. And then I’m going to tap Scattering to enable that and to go to get the Scattering controls. I’ve got Scattering enabled here on both axes and I can just pull it out or push it in to see what I’ve got. I think I want a little bit better control than adjusting count because this is going to give me way too many leaves so I think I’d rather paint more and have less of a count. So I think that’s going to be pretty good.

The last thing I need to do is to enable Color Dynamics. What I want with Color Dynamics is I’d really like this brush to do all the work for me and I want it to paint in color. So I’ve got orange as my background color. Now I’m going to tap here and I’m going to select a color from the image to be the foreground color. So I’m thinking sort of a lighter yellow, maybe I’ll just pick it up from the palette here. So this is my foreground color. This is my background color and I have Apply per Tip enabled and foreground, background jitter at 100 percent. I’ve got hue jitter, saturation jitter and brightness jitter all at zero percent and purity at zero percent as well. What this brush is going to do is it’s going to toggle its colors between these two and so I won’t have to do any of the work myself. I’m going to close this dialog, make sure that I’m painting on a brand new layer, and I’m just going to start to paint. And you can see that the colors are toggling between the foreground and background color. And that just lets me paint my autumn leaves without having to do really much work at all.

Now I can paint as much or as little of these leaves as I want. I’m painting over the edge a little bit here because I’d like some leaves to be eventually underneath this stroke border so I’m just going to add plenty of leaves in there. And I’ll add a couple of stray leaves in the bottom here as well. I can add them by just single tapping or I can paint. When I’m happy with that the last thing I need to do is to get rid of the leaves that are actually over the image here. So I’m going back to my magic wand tool and I’m going back to my stroke layer here and with Contiguous enabled I’m just going to click inside this stroke layer. And what that does is it selects everything inside that layer. And now I can come onto my paint layer and I could do one of two things. I could just press Delete to delete the leaves that are inside this shape but perhaps if I wanted to add some more leaves later on it would be a better idea if I actually added a mask. And that’s very easy to do.

I’m just going to click here the Add Layer Mask icon. Now when I add my layer mask it’s working the wrong way around. You can see what it’s done is it’s clipped and hidden all the leaves around the outside and just left the ones in the middle. We want the exact opposite to be the case so I’ll click on my mask and press Ctrl and I and that just inverts the mask. So you can see now we’ve got the leaves on our image and they’re all around the edge of the image. It’s just that the stroke is underneath the leaves. There’s a very, very easy solution to that. I’m going to select the layer that contains the stroke and just move it up above the leaves and now the stroke is over the leaves. Before we leave this tutorial let’s have a look and see what would happen if we decided that instead of this green edge we would like a pink edge perhaps sampling the pink from this little girl’s headband. Well let’s go first of all and sample the pink. And this is the pink that I’m going to use so I have it selected as the foreground color. I want to make this stroke which is now green into pink.

Now if I press Alt Backspace I’m just going to make the whole layer pink and that’s not what I want to do. I just want to fill the pixels that are already filled on that layer. So I can click here to lock the transparent pixels on this layer, looking for this lock icon to appear. Now if I press Alt Backspace I’m just going to change the color of that stroke. And it’s picked up the foreground color in the image. And now I would just either drag this lock icon into the trash can here or I can just click this icon again. That would unlock it. So there you have an oval framed effect with some autumn leaves that you’ve created using a brush of your own in Photoshop.

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 projectwoman.com for more tips, tricks and tutorials on Illustrator, Photoshop, Photoshop Elements, Lightroom and a whole lot more.

Helen Bradley

Friday, July 26th, 2013

Photoshop – Create Art from Photos using Textures

Here I show you how to create works of art using your images in Photoshop. Included is how to find and select texture images to use, how to blend these into the image and, how to add a lightening effect to highlight areas of the image to draw attention. Also, included is one method of adding a vignette to an image.

Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can make art from your photos using textures in Photoshop. Before we get started with this video tutorial let’s have a look and see what we’re aiming for. This is the image that we’re aiming for. And quite often when I’m doing these tutorials I’ll play around with a few images before I come up with something that I really want to share. But today it was just this one image, this one texture and the whole thing just blew my mind. So here it is in video form.

To start off with I’m going to show you where I got my textures because these textures are totally awesome and I love this guy’s work and I want to introduce it to you. So this is a Flickr photo stream and the guy is called Skeletal Mess. And he has a whole lot of textures that you can download. Now I downloaded this one. It’s very big but I just want to show you his set that he has on Flickr so you can see the sort of potential for what there is available. Now with this particular image I was having a look through his sets and just having a look to see what I might use. And this one really spoke to me and I’m going to show you why because we’ll go back to the image that I have and we’ll see why blue worked particularly well for this image. So let’s just wind back what I’ve done.

So I’m just going to the layers palette for this image and let’s go and create a brand new image. Okay, so here’s our duplicate image that we’re going to work with. That was what we were aiming for so now I’m going to take away the pieces that went to make up this image. Now you’ll see why I thought that that blue texture would work particularly well here because this image has no sky and if we can borrow the blue from this texture then that would give us an awesome result. We could have used this one too or this one and perhaps just rotated them. But this one really spoke to me so I downloaded that. So I’m just going to grab it now because whenever I download an image even though I can just drag and drop it into Photoshop I’ll also save it just in case I want to use it again later on.

So I’m just going to bring it in here. It’s a whole lot smaller than my image but because it’s a texture that doesn’t really matter. So now I’m going to grab the move tool and just size it to fit all the way across my image. And again because it’s a texture it doesn’t matter that it’s pulled a little bit out of square. So it’s been pulled a little bit wider than it was tall. The next thing I’ll do is just run down these blend modes and just see what it gives me because this is like totally the most exciting thing that you get to do. So I’ll just select Dissolve and then we’ll just run down these blend modes until we get what we’re looking at. And Multiply I think is probably the one I’m going to come back and use but let’s just see what there is in this list. And it was at the point at which I got to that Multiply blend mode that I thought I actually had something I really wanted to work with but you might find other things here that are speaking to you. There’s a whole lot of potential. I usually run down the list and then come back up and by then I’ve pretty much made my choice as to what is working for me. This one possibly but it’s not nearly as good as the Multiply one. So here’s the Multiply blend mode applied to this image.

Now having achieved that I thought in actual fact the middle of the image could be a bit lighter. So what I did was I added a brand new layer and from my tools palette which has gone walkabout here I just grabbed the elliptical marquee tool and just dragged out an oval on that image. I switched so that white and black would be my colors and I also added a feather to this. So I’ll choose Select and then Modify Feather. This is not a very sophisticated feather option but I’ll just add a 100 pixel feather radius to it. That just really softens this edge so now when I fill it by pressing Ctrl Backspace, Command Backspace on the Mac, it’s going to have this feathered soft edge. So now Command or Ctrl D to deselect the selection.

Now I have a big white splat right in the middle of image. That’s obviously not going to work but what I’d want to do then is to blend it in so again I’ll just select the first blend mode in the list and then just run down until I find something that works for me. And here’s Overlay blend mode. That’s lightening that image really well in the area where the lightening effect was. I’m thinking that’s probably the blend mode of choice. But let’s just go and check these others particularly in this lighter area with soft light, hard light, vivid light and pin light. You’re never really sure that they’re not going to give you something so I always run through those just in case one is better than the other. So we’re pretty much to the end and Overlay is going to be our choice. So I’m going back up to pick up Overlay. Now this is too white for me so I’m just going to drag down on the opacity of that layer just to make it a little less opaque. I’m also going to test around this area. I’m thinking that some of this lightness is coming through from this layer and it’s probably a bit more than I want.

So again I’m going to add a layer mask to this layer, go and grab a paintbrush and just paint with black with a very small opacity brush, you can see it’s only 26 percent opacity, just to knock out the bits where I think the lightening effect is too much. I really just want it on the front part of this boat. So once I’ve neatened that effect up now I’m thinking a vignette around the edge. Now there’s umpteen ways of adding vignettes. I’m just going to show you one of them. So a brand new layer, I’m going to go back to my marquee tool, this time the rectangular marquee, I’m just going to drag in around about probably an inch into the image and then I’m going to invert the selection, select Inverse so everything that was selected is now not selected.

So I’ve got this outside edge selected. Now I’m going to sample a color from the image by clicking the eyedropper. I’m thinking one of the colors around here is kind of pretty good. It’s sort of dark but not really, really dark. I’m thinking that color was pretty good. And now I’ll Alt Backspace, Option Delete on the Mac, to create that as my fill color. Now I can deselect my selection with Ctrl or Command D. Now this is not looking like a vignette but that’s fine because we’re going to again run down our blend modes and look for something that is going to give us a darkening effect at the edge. Things you would look for are going to be in this light field. Obviously Overlay is going to do it. Multiply will do it as wells. That will always darken everything up a little bit.

So they’re the ones to look out for but also look out for any surprises as you run down. You might see something that gives you an effect that makes you go oh, wow, that is just too amazing. So I’m headed towards probably Overlay. So now it’s still not the vignette effect that I want but I’m going to blur this. So with that layer selected I’m going to go Filter > Blur > Gaussian Blur. Gaussian Blur is an awesome blur for just blurring things to almost oblivion. So here it is at zero radius effectively and now we’re just going to wind it up to soften this edge and pretty much just blend it into the image. And at some point it just becomes a really, really nice soft vignette effect for our image. So I’m just going to click Ok.

So there we have the effect. It’s very, very simple. This is a throwaway image. It’s just the sky is gone. It’s Hong Kong. It’s smoggy. It’s an overcast day. The sky is just nonexistent and I really wouldn’t have given this image a second look except that I was looking for a challenge. Add a really nice texture from Skeleton Mess free online textures from Flickr, add a bit of a highlight in the middle and then add this vignette effect and we’ve got an image that is now a keeper.

I’m Helen Bradley. Thank you for joining me for this video tutorial. Look out for more of my tutorials on this YouTube channel. Please subscribe and also visit my website at projectwoman.com for more tips, tricks and tutorials on Illustrator, Photoshop, Lightroom, iPad and a whole lot more.

Helen Bradley

Friday, July 19th, 2013

Excel Tip – Spin Buttons for Data Entry

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.

Helen Bradley

Friday, June 28th, 2013

Photoshop – Adding Images to your Reusable Layout Template

Learn how to populate the layout template that we created in an earlier post with images of your own.

Click Here for Part 1


Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can actually make use of your reusable layout template that we made in an earlier video. In the previous video I showed you how to create this template.

It has a background color of white but that could be any color. It has space for two images. And then it has two copyright symbols here. One is black and one is white depending on which we want to use for any particular layout.

Now I’m going to show you how you can take this particular template and make it into this by adding images to it. I’m just going to hide this one away and we’ll focus on the one that we created.

I haven’t saved that yet but that doesn’t matter too much. Now I’m going to open some images that I want to use in it. So I’m going to go and select the images that I’d used previously. That’s winter7. And I want bird7 as well. So I’m just going to move these images into position. This is the main template and these are the individual images.

So to start off with I’m going to just drag and drop the background layers from each of these images into my main template. So this is this image first. I’m going to drag and drop it into position and I’m going to drag and drop this one in. Now you can see that the images that I’ve dragged and dropped in are way, way bigger than the template is. But that doesn’t matter because we know how to make them smaller. I’m going to click on the layer thumbnail, Ctrl T and then Ctrl Zero. You can see how much bigger these images are than the actual template itself. I’m going to size the image down quite small, click on this link here so I make sure that I don’t destroy its ratio of width and height, and I’m just going to move it roughly into position as to where it’s going to be in the final template. Now I’ll click the checkmark here and let’s go ahead and resize this one.

Click on the layer thumbnail, Ctrl T, Ctrl Zero. And now I’m going to scale it small, place it roughly in position, make sure that the width and height are scaled correctly in exactly the same proportion, finish off the positioning of it and then click the checkmark here. Now let’s zoom into the image. To make sure that this now works as we expect it to we need to bring back this line down here and we probably need to crop these images. Now the template has those crops already built into it.

The first thing I’m going to do is to drop this particular layer immediately above the layer that’s going to control its size. And then I’m going to drop this one immediately above the layer that’s going to control its size. And we’re going to use a simple feature called Clipping Path. With the topmost of this pair of layers selected, I’ll choose Layer and then Create Clipping Mask. And what that does is it clips this image to the exact size of the rectangle below. And now let’s do that with this one, click on the layer, Layer, Create Clipping Mask. And you can see that that’s clipped this particular image here to the exact size of the black box below.

The black has disappeared. It has nothing to do with it. These colors could be any color you like. But you can see that in doing so we’ve brought back the color from this layer here. And we can prove that that’s where the color is coming from. So I’m just going to select a blue color here and I’ll just fill this layer with blue. And you can see now that the space between those two images is the exact same blue as I just filled the background layer with. I’ll just undo that because I don’t really want blue.

To finish off I’m just going to decide which of these two copyright symbols is going to work better in this instance. Well I think the white one is. So I’m going to click its eyeball or its visibility icon and turn off the black one. So that’s how we would fill that template that we created in an earlier video.

Now your templates don’t have to be as simple as this one. They can be quite complex. And you may be aware that I have templates available on projectwoman.com. This is a free set of templates that you can download and use exactly as you’ve seen here. There are some triptychs and there are also some layouts with 9, 4 and 6 images in them.

I’m Helen Bradley. Thank you for joining me for this video tutorial. If you liked this tutorial place click the thumbs up to give it a like. Think about subscribing to my YouTube channel and visit my website at projectwoman.com for more tips, tricks and tutorials on Illustrator, Photoshop, Lightroom, Photoshop Elements, iPad and a whole lot more.

Helen Bradley