There has been some discussion on the forums of DPReview.com about opinions written by someone who calls themselves “Blue Water”. They purport to be me.
Just to clarify the situation, I am not Blue Water. Until today I didn’t know DPReveiw.com even existed and I had never posted there. The opinions and comments of Blue Water are not mine.
Helen Bradley (the real one!)
Labels: DPReview, forum, Helen Bradley, postings
Categories:Uncategorized
Picasa is a great free photo organiser and editor and you can find and download it from picasa.google.com. Here are some of the key editing features in Picasa. If you already use Picasa, I suggest you update your version now. In past versions, edits you make in Picasa were only visible in Picasa and were not saved with the image unless you exported it. The new version avoids these problems.
Labels: digital photo organization, free software, photo editing, Picasa
Categories:Uncategorized
Word does not contain any option for automatically numbering a series of documents with a consecutive number – the type of thing you might want to do if you are using Word to create invoices or numbered purchase orders. The solution is to create a macro to do the work for you.
Start with a template that has a macro that runs when ever the template is used for a new document. The macro should read a number stored in a file on your drive, add it to your document and then, to prepare the number for the next time it’s required, the number should be incremented by one and be written back into the file.
To create the solution, create a new document (or open an existing one to use as a template) and click where you want the sequential number to appear, and choose Insert, Bookmark, type docNum in the Bookmark name area and click Add.
Save this file as a template by choosing File, Save As, from the Files as type list choose Document Template (*.dot), give the file a name and click Save. With the file still open, choose Tools, Macro, Macros and type the name of the macro docNum and, from the Macros In list choose the template file name for the file you just saved and choose Create.
Type this macro as shown, the sub and end sub lines should be there already:
Sub docNum()
Dim MyString, docNumber
FileToOpen = “c:\windows\docNumfile.txt”
Open FileToOpen For Input As #1
Input #1, docNumber
Close #1 ‘ Close file
ActiveDocument.Bookmarks(“docNum”).Select
Selection.InsertAfter Text:=docNumber
docNumber = docNumber + 1
Open FileToOpen For Output As #1
Write #1, docNumber
Close #1 ‘ Close file.
End Sub
Now choose File, Close and Return to Microsoft Word. With the template on the screen, choose File, Close and answer Yes when prompted to save your changes.
Now open Notepad and type a number 4 or 5 numbers less than the number of the first quote you want to use. So, if you want to start numbering at 200, type 195 so you have a few numbers to use to test the process. Choose File, Save As and save the file as a text file, calling it docNumfile.txt and save it to this folder: C:\windows. Close Notepad
To test the process, choose File, New, choose the template file and click OK. Now run the macro by choosing Tools, Macro, Macros, docnumb, Run. If you have everything right the document number will be inserted in the document.
When this is working fine, alter the macro so this process of inserting the document number happens automatically whenever you create a new document based on this template. To do this, choose Tools, Macro, Macros, click on docnumb and click Edit. Change this macro’s procedure name by altering this line of code:
Sub docnumb()
to read
Sub AutoNew()
Choose File, Close and Return to Microsoft Word. With the template on the screen, choose File, Close. Say No to saving your changes to this file but answer Yes to save the changes to your template file.
Now test again by creating a new file using File, New, choose your template and click OK. The document number should be added automatically to the new document.
If, in the process of testing you find you go past your starting document number, open Notepad and open the file docnumfile.txt, type a new starting number and save it again.
Labels: AutoNew, autonumber, document numbering, Macro, Microsoft Word, Word
Categories:Uncategorized
When Excel starts a default new workbook displays. This workbook contains many of the default settings for Excel and it can be customized so it looks the way you want it to look.
You can configure the defaults for your starter Excel worksheet if you place your settings in one of the two Excel templates; Book.xlt and Sheet.xlt. Neither file is required but, if you have one or other, or both, stored in your XLStart folder then Excel opens them whenever it opens and uses the data you have stored in them as its own default settings.
When you’re creating either or both of the files make sure to put the relevant settings in the right file. Book.xlt should contain the defaults for all new workbooks such as styles and toolbars.
Use Sheet.xlt for options appropriate for all new sheets in a workbook which are added when you choose Insert, Worksheet. A word of warning, when you save a workbook as sheet.xlt make sure it contains only one Sheet.
Labels: book.xlt, defaults, Excel 2007, sheet.xlt
Categories:Uncategorized
My latest article in the Misunderstood Photoshop series is out today.
The Photoshop clipping mask feature is a quick way to create effects such as text filled with a photograph. Helen Bradley points out more handy uses for clipping masks, such as limiting the effect of adjustment layers, or simplifying the process of editing a portion of an image. You can follow along with the accompanying video tutorial to see exactly how it’s done.
Find it here: Misunderstood Photoshop – Clipping Masks
There are more articles to come!
Helen
Labels: clipping masks, Misunderstood Photoshop
Categories:Uncategorized
Ok, so it’s not exactly a tip of the day, but I already did today’s so I feel it’s justified.
I have lots of cool Photoshop tutorials around my site, check these out:
Photoshop Brushes tutorial
Learn how to create your own Photoshop Brushes
How to use Adjustment Layers
Make photoediting a simple and undoable process using Adjustment layers
Photoshop Gradients
Fix images and create colorful effects using Photoshop Gradients
Straighten an image in Photoshop, Elements and Paintshop Pro
Straighten your images with this simple to follow tutorial that covers the popular photoediting programs
Photoshop Shapes -New!
Helen Bradley explains how to use Photoshop Shapes to edit your photos and create fun shape overlays.
Create and use Photoshop Masks
Masks aren’t as hard as you think they are and this tutorial makes them simple to use.
Create seamless patterns in Photoshop
Whether you need them for the web or for a background for an Excel worksheet, here’s how to create great seamless patterns and we’ve included a mini tutorial on TV scan lines.
Color match photos in Photoshop
Even if your photos were taken in totally different lighting
Color Swatches in Photoshop
Create your own custom color swatches and use them in your photo editing work.
Ok, so that’s done, now back to the tips..
Labels: adjustment layers, articles, brushes, color, Color match, gradients, how-tos, masks, Photoshop, shapes, straightening, swatches, tutorials
Categories:Uncategorized
When you’re photographing a person in front of a snow scene on a sunny day the lightness of the snow in the background of the shot will fool the camera’s automatic sensors into exposing incorrectly for the person who is standing in front of you. In a similar manner to taking photographs on the beach in the height of summer use the camera’s fill or force flash when shooting in these circumstances. The flash will light the person in the foreground and you’ll have both the person and their background nicely exposed.
Labels: Uncategorized
Categories:Uncategorized
You’re already used to using Lookup lists in many of the programs you use. You use a lookup or dropdown list to select from a series of entries that the programmer has provided for you to choose from. When you create a database in Access, you get to be the programmer and you can create your own lists.
So, whenever you have a list of options that can be used to fill a field in an Access database you can create a lookup field to manage it. Then, whenever data is entered into the table all the user has to do is to select an option from a dropdown list – this makes the dataentry process much faster and more accuate too. Here’s how to create one:
Labels: Access, database, field, lookup list
Categories:Uncategorized
There are lots of differnt ways to convert a photo into a grayscale image and each of them offers different benefits such as speed or the ability to customise the results.
Here are five great ways (and one cool extra tip) for making a grayscale image in Photoshop:
(Hot tip) Before you convert an image to black and white, adjust it to ensure there is a good tonal range in the image. Choose Image, Adjustments, Levels and make sure the markers are under the ends of the chart. Adjust the midtones slider (the middle one), until you have a good result. An image with good contrast and a pleasing tonal range will give better results in the steps that follow.
Grayscale – Version 1
The simplest method of converting to Grayscale is to choose Image, Mode, Grayscale. When you do this, you create a grayscale image and color cannot be added back into it unless you convert it back to a color mode. To do this, choose Image, Mode, RGB Color if you plan to do more work with the image. Convert to CMYK color mode only if you intend to send the image for commercial printing.
Grayscale – Version 2
A RGB color image is made up of three color channels Red, Green and Blue. These channels are grayscale images displaying the relative amount of that color in the image at any point. To see the channels, display the Channels palette and click on the channel to view, hiding the others. If you like the grayscale representation of a particular channel display it, hide the rest, and choose Image, Mode, Grayscale and you’ll be asked if you want to discard the remainder of the channels – this turns the current channel into the grayscale image. Answer Yes to do so. To work on the image again in color, choose Image, Mode, RGB Color.
Grayscale – Version 3
Another method of converting an image into grayscale image but which retains the RGB color mode is to choose Image, Adjustments, Hue/Saturation. If you select the Master channel and then drag the Saturation slider to the far left, you’ll remove the color from the image by desaturating it. However, because it is still RGB Color you can add color back without needing to alter the mode.
Grayscale – Version 4
The Channel mixer gives you the opportunity to tweak the final grayscale representation by using more or less of the colors from the image. Choose Image, Adjustments, Channel Mixer and click the Monochrome checkbox. Now adjust the Red, Green and Blue sliders until you get a result you like. Ideally, you should ensure that your percentages add up to 100% although this isn’t a hard and fast rule.
Grayscale – Version 5
One situation you may encounter is where you want to convert a single layer into grayscale but leave the other layers in the image in color. In this case, choose the layer to convert to black and white and choose Layer, New Adjustment Layer, Hue/Saturation and enable the Use previous layer to create clipping mask checkbox and click Ok. Move the Saturation slider to the far left and click Ok.
So, there you have it – more ways to convert an image to black and white than you ever thought possible?
Labels: black and white, channel mixer, channels, color modes, Hue/Saturation, Photoshop
Categories:Uncategorized
