You have probably played around with the styles in Photoshop Elements and added things like a drop shadow to an image. But did you know that these can be edited once they are created? Doing this gives you the ability to customize the shadow to suit your needs.
To adjust an effect such as a drop shadow, with the layer that you have applied the shadow to selected in the Layers palette, choose Layer > Layer Style > Style Settings. Alternately you can double click the fx icon in the layer to open this dialog.
This dialog has the tools you need to adjust the shadow or other effect you have applied. Note that when you are working with shadows the Size is really a feather type effect and Distance is more what you might consider to be size and it positions the shadow at a distance from the original shape or object.
Here too you can change the shadow color and the direction it comes from by altering the Lighting Angle. You can also click and drag on the shadow on the image itself to move it into position. Click OK when you are done.
Try this quick Excel formula to sum a cell in all the sheets except the current one
In Excel sometimes you’ll want to sum a cell value in all the sheets except the one that you’re currently working on. You might do this if you have a series of quarterly results that you want to add together to create a yearly total in the total sheet.
You can do this by typing the sheet name and cell for each cell to add but that would be very cumbersome. It will be a nuisance too if you try to select each cell in turn. Luckily Excel has a special feature that will help you do this. So, to sum all the values in, for example, cell C3 of every sheet in the current workbook except for the sheet you are currently working on, use this formula:
=SUM(‘*’!C3)
The ‘*’! part of the formula tells Excel that it should total all the sheets in the workbook except the current worksheet. When you press Enter Excel expands the formula so it will refer to the first and last sheets in the workbook. So, if you are summing that cell in a workbook that has sheets called YearTotal, Quarter1, Quarter2, Quarter3, and Quarter4 the formula will be expanded automatically so it reads:
=SUM(Quarter1:Quarter4!C3)
Be aware that if you add additional sheets to the workbook which appear inside the range of the sheets that are refered to in the formula then those additional worksheet cells will be included in the total.
If you don’t want this to be the case then make sure that any new sheets that you add appear outside the range of sheets that are included in the formula.
Learn how to recolor line art in Photoshop and how to change the colors very easily.
This video shows the use of the Lock Transparent Pixels option in the Layers Palette in Photoshop and also a Hue/Saturation adjustment layer.
Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can recolor your art in Photoshop. In this video tutorial we’re going to have a look and see how we could recolor this car and how we can do it in a way that would allow us to perhaps change the colors later on.
I’ve got the car on one layer here and the background which is white on another layer. So I’m going to add a layer between these two layers where I can start painting my colors. I’m going to select one of these color schemes that in an earlier video I created from Kuler and I’m going to just grab my toolbar here so that I can grab a paintbrush and a relatively hard paintbrush, not totally hard but relatively hard. I think I’ll just back it off a little bit here to about 84 percent. And on this layer I’m going to start laying down paint. I’ve got my opacity right down from another job that I was doing so let’s just kick that up.
Now I’m just going to paint over the areas where I want the paint to be. And how detailed you are with this and how accurate you are with it depends on just what sort of effect you want. Now I don’t want it to be quite so accurate so while I am going to erase a little bit of this I’m not going to erase all of it because I do want some over-painting. Now I could leave this layer underneath but you’ll see that there is a little bit of white there that’s showing through. I can get rid of this by going to this layer here and setting its blend mode to darken and that will darken the areas but will let the white pixels blend in with the layer below. I think that gives me a better result.
So let’s go now and let’s get another color in this color palette and let’s just go and paint here. And I’m just going to pick the paintbrush up rather than the eraser and let’s Just paint in these areas. Again depending on what sort of effect I want I may be more or less accurate and I can always come back with the eraser and just tidy up if I want to. Most of these areas of the image are also trapped so if I wanted to I could just make a selection from the original image and pour paint into them. But I don’t really want that effect for this image. I just want it to be a little bit more organic than that. And I’m going to add the orange to various portions of the image but I’m going to do it all on this one layer. So that means that later on I can come back and replace the orange with another color and every element that was orange will be replaced accordingly. So let’s just go here. I think I’ve got a slight problem with my green. So I’m just going to continue until I have my car painted to my satisfaction and then we’ll come back and see how we would recolor it.
Now I’ve finished painting the car and I’m ready to go ahead now and have a look at my options for recoloring it. One of the ways I can change the color of this image is to click on the topmost layer and choose Layer, New Adjustment Layer, Hue/Saturation. And this allows me to recolor the entire image just using a single adjustment layer. So I’m just going to drag here and then if I drag around on this color selector here you can see that all of the colors bar that sort of gray color are now changing. And they’re changing in the same relationship to each other. So that’s one of the options I have for recoloring this vehicle is to just adjust the hue/saturation of the entire image using a hue/saturation adjustment
layer and just stopping when I get to the color scheme that I want to use for example.
Now another alternative is if I want to just selectively recolor areas because I put each of these colors on a different layer I can then just change those layers. So for example let’s go and pick up another Kuler color scheme. I’m in beach ball but that doesn’t really matter too much. Let’s go and get this beach combo color scheme from Kuler. And if you haven’t yet watched my Kuler video and if you want to know how to do this then I suggest that you go and have a look at it.
Now my mouse and my video tool aren’t running very well together right now so I’m having a bit of trouble selecting this. Ok, it’s now in the Swatches panel. So I’m going to go ahead and select this blue color as my foreground color. And I want to replace this color green with the blue. Now what I’m going to do is because there’s a lot of detail on this layer and I want to replace the whole lot, I’m just going to lock the pixels on that layer. And what happens when I lock the pixels is if now I press Alt and Backspace, Option Delete on the Mac, what I’m doing is flooding just the filled pixels on this layer with that Color and so now that layer has been recolored. I’m going to select this layer and lock the pixels on it and pick up a color to use for it and then I’ll Alt Backspace, Option Delete on the Mac, to change its color.
And finally I’m going to lock the pixels on this layer and let’s go and get a color to use for that. We’ll choose this darker blue, Alt Backspace, Option Delete. Of course these layers are now locked so if I want to be able to edit them for example erasing any excess paint or making any changes to them, I’ll need to unlock them. But this Lock Transparent Pixels tool allows you to quickly isolate the contents of a layer, select a color to use for it and just Alt Backspace, Option Delete on the Mac, to immediately select and refill all the pixels on that layer.
I’m Helen Bradley. Thank you for joining me for this video tutorial. If you liked this tutorial please give it a thumbs up and feel free to comment on it. Please consider subscribing to my YouTube channel and visit me at projectwoman.com for more tips, tricks and tutorials on Photoshop, Photoshop Elements, Lightroom, Illustrator, GIMP and a whole lot more.
Learn how you can improve your photography with handy apps
Among the thousands of new apps and programs we’ve seen in the last couple of years, there are many that are ideal for photographers, both amateur and professional. Whether you’re a professional looking for a way to edit and share your photos, or someone who simply wants to do more with photos with your phone or tablet, there are dozens, if not hundreds of apps and programs designed to help you out. What you choose to use will depend to some extent on how serious a photographer you are, but ultimately there is something for everyone.
Here is a look at how to improve your photo taking and editing through 5 simple apps and programs.
Photoshop Express
This is a fairly self-explanatory app – from the makers of Photoshop and Photoshop Elements which most photographers will be familiar with. This app is by no means as complete or effective as the full version program, but the interface is simple and easy to use, and for basic effects on the go it is a handy app. It is free in its basic form, but has additional features available for purchase.
Camera+
If you’re looking for an app that improves the quality of your photos without any complicated editing, this is the one for you. Basically, Camera+ is a better version of the basic camera in your smart phone, and has the ability to take clearer, more sharply focused photos. You can apply basic effects such as contrast, color schemes and retro effects as well as crop and rotate the photo to improve the quality of photos that your phone’s camera captures.
Dynamic Light
This is a great app for manipulating the lighting in your photos. The end result can look more artistic than natural, so if that’s something that interests you as a photographer, this is definitely an app for you. You can select a photo and an effect, then adjust the “dynamic light” dial to control how the effect is applied to the image or you can shoot the image using the app. It’s a great way to turn an ordinary image into a striking one.
Filterstorm
A great app for photo editing, Filterstorm essentially takes the best features of Adobe Photoshop Lightroom and puts them in a simple app. It’s more about adjustments than filtering, but does allow you some simple effects for manipulating lighting, colour, and brightness among other things.
This is a guest post by Dylan Bailey. Dylan is a freelance writer and keen amateur photographer.
Learn how to use Kuler color schemes in Photoshop via the Kuler Extension.
This video includes details of how to add color schemes to swatches and how to edit, customize, and create Kuler color schemes inside Photoshop CS4, CS5 & CS6.
Transcript:
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial I’m going to show you how you can use Kuler colors in Photoshop. In this video tutorial we’re going to have a look at Kuler which is a way that you can find custom color schemes from inside Photoshop.
Now Kuler is also available online but we’re going to work with the Photoshop extension. And that’s been there since CS4. To see it choose Window and then Extensions and then Kuler. And when Kuler launches you get to see some of the color schemes.
Now I last looked for vintage car and that’s in actual fact what we’re going to look for now. So I’ve typed in vintage car and clicked the Search button and here are color schemes that are related to vintage cars. And if I can’t see anything I like there I can click the View Next Set of Themes option and we can go forward to see other themes. Now these themes have been designed by other people and they’re available online. And people put them up online when they create them and then they are accessible for us to use if we want to use them.
So I’m looking for a theme to use for my car. And let’s say that I find one, so let’s just go and find one that we sort of like. I’m thinking this one here. And if I like it I can just click on this arrow icon here and I can add it to my swatches panel. And when I do that it becomes the last five colors in my swatches panel and I can click on any of these colors to add it as my new foreground color. And that allows me to paint on it for example to recolor my car.
Now if I sort of like it but think I like to edit a color for example maybe the red in this, then I can click here and choose Edit this theme. And this opens the Kuler panel but this time in the edit mode. And this is where I can change some of these colors.
For example I can take the red and walk it around to maybe make it an orange. And if I like that then I can use this particular color scheme. If I want to save this theme to my swatches panel I can do so by clicking here, Add this theme to swatches panel, again this time all five colors go into the swatches panel. I could upload it to Kuler if I wanted to and I can name and save the theme.
You can also create your own custom themes here so for example if you wanted to create an analogous color scheme you could do that. So you could just click there and then you can drag around on these sliders to make the color scheme that you want to use. If you want to use a complementary one you can do that and just drag in and out on these colors to create your own complementary color scheme. And if you like it then you can add it to your swatches panel. You can upload it to Kuler.
Kuler is a really handy tool for finding color schemes if you’re not sure what you want to use and so you can quickly and easily find color schemes and add them to your swatches panel. So it can help you get inspiration when you want to use a limited color palette on your images and you’re just not really inspired to find it yourself.
I’m Helen Bradley. Thank you for joining me for this video tutorial. Look out for more tutorials on this YouTube channel. Also visit my website at projectwoman.com for more tips, tricks and tutorials on Photoshop, Photoshop Elements, Lightroom, Illustrator and a whole lot more.
See how to upload images from your Mac to your iPad or iPhone
Sometimes you will get images on your Mac that you want to share with your devices such as your iPad or iPhone. To do this you can add them to your photo stream and they will be synced automatically next time you are connected using a wifi connection.
To do this, from inside iPhoto, click the image(s) to add to the photo stream then click the Share option on the toolbar, click Photo Stream > My Photo Stream. The images will be uploaded to your photo stream and then downloaded to other devices when they next update via a wifi connection.
Of course, for this to work the images have to be in iPhoto. If an image is not, for example, it is on the desktop – you can add it to iPhoto by dragging and dropping it into iPhoto and then add it to your photo stream.
Of course if you have your iPhoto set up to automatically send all new images to your photo stream the very process of adding images to iPhoto will add them to your Photo Stream. To do this in iPhoto, choose iPhoto > Edit Preferences > Photo Stream and, under My Photo Stream (which should already be enabled), check Automatic Import.
Gadgets allow you to do things with Google Docs that would be time consuming if not beyond most people’s skills to create in a program like Excel. In this article I’ll demonstrate how to create a motion chart in Google Docs spreadsheet.
Prepare the data
In the first column of a new worksheet type the name of the item you’re charting such as office locations – we’ll use City and Bayside. In the next column, type the period that the data is for – this needs to be a time field such as year, week or quarter. The data needs to conform to ISO8601 so use 2011 for a year, 2011W08 to enter week eight of 2011 or 2011Q2 for second quarter 2011.
In the next column, type the data to plot such as Profit. The next columns are optional but we’ll add one which records units sold. To have some data to work with, add at least five years of data for the two offices.
Add the Gadget
Select over the entire range (including headings), and choose Insert > Gadget > Charts and scroll to find the Motion Chart and click Add to Spreadsheet. In the dialog which appears, the range should already cover the selected range, leave the Default State empty for now and type a title for your chart such as 5 Year Office Comparison and click Apply & Close.
The chart appears on the screen but requires some customisation to work. From the fly out menu of Y axis options on the left select Profit and then from the X axis dropdown list select Time so you plot Profit against Time.
From the Color dropdown list, select Unique Colors and from the Size dropdown list, select Units Sold.
Click the Play button and the chart will play showing the change in your data over time. The Y axis movement shows movement in Profit and the size of the bubble shows change in Units Sold.
The tabs change the chart from a Bubble to a Column or Line (this is not a motion chart).
If you click the office checkboxes and Trails you will see additional labels on your data and to the right of the Play button is a slider which controls playback speed.
Save the default
Wind the play button back to the beginning. Click the Settings button and click Advanced and Advanced again. Double click the state string to select it, right click and choose Copy. Click the chart title to display the chart menu, click Edit Gadget and paste the string into the Default State textbox. Save the worksheet and the chart will appear whenever the worksheet is viewed and it will be configured as you set it up to look.
Learn how to make a collage or montage in Photoshop using fractal trees, a texture image and some masks.
The images used in this video are free to download and an earlier video shows you how to make fractal trees so you can make the collage yourself. The tutorial covers beginner level masking to help make the collage and two pieces are created from the same basic elements.
Hello, I’m Helen Bradley. Welcome to this video tutorial. In this tutorial we’re going to look at using masks, textures and some fractal trees to create composite images in Photoshop. In this video tutorial I’m going to show you how you can create a couple of interesting effects just using images that you can find online.
The background image here is from Flickr and details are in the end of the video. And the house image is actually from sxc.hu, and again I’ve got details at the end of the video. The tree is a fractal tree and you can see one of my other video tutorials for how to create fractal trees. And this is just done with my masking so that’s one of the images we’re going to create. We’re just going to reverse the mask here to create this image. So let’s see how we would do that and I’m going to start by showing you the two images we’re going to use. This is the one from sxc.hu which is free for download online and this is the background from Flickr.
The first thing I’m going to do is just to bring this image in so I’m just dragging on the background layer and just bringing the image into my sort of collage area. Now what I wanted to do was actually line up this background and it actually worked perfectly. These images haven’t as far as I’m aware actually been adjusted from their downloaded original. But the horizon line just works perfectly on the back of this texture image so I’m just going to do that and then we’re going to mask the house. Now the easiest way to mask this house is probably to grab the quick selection tool. And with the quick selection tool you can select over those areas of the image that you want to select. And if it’s not perfect you can just go back with the Alt key and just drag over the areas that you want to take out of the selection. But it does a reasonably good job. And because we’re doing masking anyway it’s a little bit forgiving. So having done that we can choose Select and then Refine Edge. And Refine Edge will allow us to refine the edge of this and we can do this with marching ants or on black or whatever.
Now I’m going to ask Photoshop to have another look at some of these edges here because it hasn’t done the world’s best job of getting them right and particularly these edges around the bottom here. And once we’re happy with that if we are happy with it we can just make this into a selection or a new layer with layer mask. So I’m going to choose New Layer with Layer Mask and just click Ok. And that has created the image here this house image as a new layer with its own layer mask. And I can determine how much of this inside that I want to bring in.
So I’d actually thought in the past that actually bringing these windows in would be attractive and perhaps a little bit more worked on the door. And now I want to fill these areas with black in the mask. So I’m going to select or target the mask layer, black is my foreground color so I’ll do Alt Backspace and that allows me to see through the building to what’s behind. And then I’ll just go and open one of my trees. And I have some trees here and I’ll just grab one of my fractal trees, drag it into the image here.
I’ll make sure I’ve got the tree layer selected and drag it into position here. And when we were looking at these fractal trees we determined that actually using the darker blend mode or darken blend mode blended the trees into their background a little bit better because that meant that any residual white in the tree that was left over from the process of bringing it into Photoshop would be eliminated that way. So there’s the first of our images.
So having completed our first image the second one is done in a very similar way. In fact we can borrow the first to make the second. So I’m just going to make a duplicate of the image layer here. And what I’m going to do is just invert the mask so I’m just going to press Ctrl I on the mask and effectively that was pretty much the beginnings of this image. I then brought in the tree so it would be a little bit over the edge and then we’re going to create a shadow for the tree. So the first thing I’m going to do with that is on the tree layer once it’s already set, I’m going to add a drop shadow. And I’m just going to go with whatever I get here because I’m actually not going to use it exactly as it is here so I’m just going to click Ok.
And now I want to take the drop shadow layer off onto its own layer so I’m just going to click Create Layer and click Ok. And that takes the drop shadow back onto its own layer which means I can do things with it such as sizing it down, putting it in position and then rotating it so it becomes more like the kind of drop shadow that it should be. And I want it to come over the background there so I’m just going to click Ok and actually position it a little closer and perhaps even kill down its opacity a bit, multiply blend mode is what I wanted there.
Now on this layer too I had a drop shadow so let’s just go and add a drop shadow to this. Yes, it was a drop shadow but it was a lot smaller than that. So I just gave it a little bit of a softening effect that I wanted, not quite as harsh as it had been. And we could change the color of that if we want to. But I’ll just click Ok.
So there are the two possible effects that we can create using this particular image. It’s just done through layer masks and you can create all sorts of fun collage effects using layer masks in Photoshop. And I’ve combined these with nice textures and these fractal trees. And the beauty of all of this is that these images can be grabbed online. So you can go and create these image effects if you want to yourself by grabbing the images and playing around with these effects.
I’m Helen Bradley. Thank you for joining me for this video tutorial. Look out for more tutorials on my YouTube channel and visit projectwoman.com for more tips, tricks and tutorials for Photoshop, Lightroom, Illustrator, Photoshop Elements and more. And if you liked this please click Like and comment on it and think about subscribing to my YouTube channel.
I’ve been revisiting some of the apps I’ve previously reviewed to see what changes have been made to them recently and how they have developed. One of these apps is Adobe Photoshop Express for the iPad. This app is free but it does have some in app purchases – one of which – the Camera pack that includes Noise removal – you can safely ignore. I think it is expensive and not worth the $4.99 that Adobe charges for it. However, ymmv.
The free Effects in Photoshop Express are pretty limited and there are just nine of them so unless you buy the add on Effect Pack ($2.99) you won’t have a lot of creative options. That said, the Effect Pack has a lot of fun effects in it. You could get access to similar effects for free in other apps, but if you want everything in one place you might consider this pack worth shelling out for. There is also a Border pack for 99¢.
Like many free apps the add on borders and effects are shown in the app so you can see them but not use them unless you buy them. You can’t hide them either so this might be a bit off putting – personally I’d rather not see what I don’t own, but that’s my take on it.
One change to the app that I like is the on screen prompts showing you how to use the app. This was a huge complaint that I had initially with the app as it had no indication as to how you made your adjustments. I thought at the time that this made it very hard for inexperienced users to use the app as it wasn’t clear how to do so. In a free tool aimed at beginner users I thought this was inexcusable.
Now the first time you choose an option like Brightness and Contrast an overlay appears showing you how to adjust these options. It’s much less confusing and a whole lot easier to work with. So much so that I’d wholeheartedly recommend this app for beginner to intermediate users.
In Photoshop Express you can edit images from your Camera Roll or capture images using the app. What you cannot do is upload images to Adobe Revel – the new online replacement for photoshop.com (and which was previously called Adobe Carousel – have I confused you yet?). You can also not download images from Adobe Revel to edit them in the app. Since Adobe owns all these sites and apps it would be nice if all its apps and storage locations talked to each other instead of operating in isolation.
Other changes I noticed is that the feature for adding effects and borders has been revamped allowing you to see the full range of effects and borders in one large screen already in place on a small version of your images. Those that are not enabled have a blue mark on the corner and there is a shopping cart link in the bottom right of the screen that you can use to buy add on packs, if desired.
So far as sharing is concerned, Photoshop Express is light on options when compared with some other apps. You can share to Facebook, Twitter, Tumblr and email images but that is all. You can also save images to your Camera Roll.
In all, the changes to Adobe Photoshop Express are welcome and make the app a lot more usable for its target audience. I now actually like this app and would heartily recommend it particularly for beginner to intermediate users looking for a simple and easy to use photo fixing tool.
Change your Windows 8 Lock screen and other personal settings
It isn’t easy to find but you can change the images you see on your Lock screen and start screen in Windows 8 by pressing the Windows logo key and I and choose Change PC Settings.
Click Personalize and you can view different options for your Lock screen, Start screen and account picture.
