Saturday, February 10th, 2007

My Photoshop Articles

In the past few month’s I’ve written some cool articles for InformIT on Photoshop, here are a few of them:

Misunderstood Photoshop: Blend If
Here I explore Blend If, a smart Photoshop blending tool that can be used to knock out an object from its background or to blend two images. The article also includes a video tutorial so you can easily follow along.

Misunderstood Photoshop: The History Brush
Photoshop’s History Brush is great for fixing those little “oops” moments when you’ve messed up an image, but it also lets you use previous states of the image to create new effects. Helen Bradley shows why the History Brush should be a valued member of your Photoshop toolkit in this article and video tutorial.

Create Art: Make Your Own Photo Background
If the background of your picture is getting more attention than the subjects in the foreground, try Helen Bradley’s Photoshop trick for making the background more attractive and a lot less distracting.

Enjoy!

Helen Bradley

Friday, February 9th, 2007

Display an Excel Workbook’s path

Sometimes it’s handy to show the path of an Excel workbook on the screen. Here’s a workaround using a toolbar to do this.

  1. Right click on the menu bar and choose Customize and then the Commands tab.
  2. From the Categories list choose Web and, from the Commands list drag the Address option onto a toolbar or into the menu bar.
  3. Click Close and voila! the file’s full path will appear in the box.

Helen Bradley

Thursday, February 8th, 2007

Posting to an Outlook folder

Try this scenario: you’re working in Outlook and you want to add a note to your inbox – perhaps instead of emailing your work address someone emails your home email address and you want to keep your work emails up to date so you want to note the conversation in your inbox. Here’s how to do it, using a Post:

  1. Click the folder to post into so you have it open.
  2. Choose File, New, Post in this folder and type your note – in my scenario it would be details from the email but it could, conceivably, be anything.
  3. Click the Post button on the toolbar and the note will be saved into the folder – you’ll know it isn’t an email because it has a special icon but it behaves like one so you can open and view it.

I love Posts. They’re are a handy way of recording information in an email folder when it’s there that you’d expect to find it.

Helen Bradley

Thursday, February 8th, 2007

Excel 2007 goes total color!

It’s always been confusing to me and my readers why you have an unlimited number of colors to choose from in Word but only a handful of really ugly colors to use in Excel. It doesn’t make sense – do Word users have better design skills than Excel uses – do they think that those of us who create worksheets somehow won’t be blindsided by how ugly the color combinations we’re being served up are?

Well, if you’ve been hankering after a rich color palette for your worksheets, you need do so no more. Excel 2007 gives you access to a full range of 16 million colors from the colors dialog so that you can use these colors, for example, for formatting text, charts or drawn objects. You can also select a Theme which gives you instant access to colors that are selected from the same monochromatic group and guaranteed to look great together. The new and very colorful options in Excel 2007 are guaranteed to wow you!

Helen Bradley

Wednesday, February 7th, 2007

Calculating elapsed time in Excel

It’s a common enough scenario – you want to know how old you are in months or days or the number of days left in the year. There appears to be no Excel function for calculating the difference between two dates. Not so! there is a function and it’s called Datedif.

The Excel Datedif function isn’t well known because it is largely undocumented in the Excel help files. Its purpose is to calculate the difference between two dates and it can do this by measure the distance using one of these attributes: “m” for months, “d” for days, “y” for years.

So this formula calculates the difference in months between FirstDate and SecondDate:

=Datedif(FirstDate,SecondDate,”m”)

Replace “m” with “y” to get the result in years etc..

Always ensure that the first date occurs earlier than the second or you’ll get an error.

Helen Bradley

Tuesday, February 6th, 2007

More colours in Excel 2003 and earlier

I don’t know why, but there are heaps of colors available in Word for formatting text and lines but only a small subset of colors are available in Excel. Does Microsoft think we don’t like color in Excel?

Unfortunately we can’t specify additional colours for use in Excel workbooks either but we can change the colours that are displayed in the color palette to a mix of what we do like. So, if pink isn’t your thing, you can replace all the pinks with colors you do like and will use.

To do this, in Excel, choose Tools, Options, Color tab and select a color to change. Click Modify to choose a new color in its place. Repeat as desired.

Helen Bradley

Monday, February 5th, 2007

Using special characters in Word documents

I write for UK magazines so I often have to use pounds symbols and my mum’s and brother’s surnames have an ‘e’ with an accute accent – unfortunately neither is on my keyboard. So, to make things easier to write, I use a macro to convert a word to a typed character.

Here’s a sample you can use and adapt. It converts the words cents, pounds, degrees and division to their character equivalents and you can use it to replace almost any word or character with another single character, word or phrase of your choosing:

Sub ConvertText()
FindAndReplace “cents”, “¢”
FindAndReplace “pounds”, “£”
FindAndReplace “degrees”, “º”
FindAndReplace “division”, “÷”
End Sub

Sub FindAndReplace(FindThisWord, ReplaceWithWord)
Set EditRange = ActiveDocument.Content
EditRange.Find.ClearFormatting
EditRange.Find.Execute FindText:=FindThisWord, ReplaceWith:=ReplaceWithWord, MatchCase:=0, Replace:=wdReplaceAll
End Sub

Helen Bradley

Sunday, February 4th, 2007

Avoiding that "oops!" moment in Outlook

I think we’ve all had that sinking “Oh no!” feeling when we’ve sent an Outlook email. Either you’ve forgotten to include an attachment or you’ve thought twice about what you said and you want to recall the email. In most cases an email can’t be recalled, but you can delay it being sent.

To add a delay to outgoing emails, use a rule:

  1. Choose Tools, Rules and Alerts and click on New Rule.
  2. Choose the Start from blank rule option and then select Check messages after sending and click Next.
  3. Click Next as all messages will be delayed (but you can set an exception shortly) and click Next and Ok again to confirm the rule will apply to all sent messages.
  4. Choose Defer delivery by a number of minutes and set this to the number to wait – say 2 minutes and click Next.
  5. Now, set an exception for messages that just have to be sent immediately, for example, select Except if it is marked as importance and set this to High.
  6. Click Next, type a name for the rule such as Delayed Send, enable the Turn on this rule checkbox and click Finish.

Now, when you click Send, your messages will be held for 2 minutes before being sent except if you make them High importance.

Helen Bradley

Saturday, February 3rd, 2007

Automatic Excel cell entries

We all love to save time and here’s a great tip to make repetitive cell entries in Excel just so much easier to complete.

You do this by making a drop-down list in a cell so you can select your entry from it rather than having to type it fresh each time.

To do this:

  1. Type the list of items to use in a single column in a spare sheet in the workbook.
  2. Select these cells and choose Insert, Name, Define and type DataForList and click Ok.
  3. Move to the sheet where the data goes, select the cells for the drop-down list and choose Data, Validation, Settings tab. From the Allow list choose List and, in the Source area, type =DataForList and click Ok.

Now, whenever you click a cell in this range you’ll see a list box indicator appear and you can choose the cell entry from the list.

Helen Bradley

Saturday, February 3rd, 2007

Sorting a Word list

While it looks like Word has no tool for sorting a list – only for sorting data in a table, this is not the case and the Table sort tool works just fine for sorting data in a list.

To sort a list, such as a list of names, where each name appears on a new line and the last name is separated from the first by a comma and a space, choose Table, Sort. From the Sort by list, choose Field 1 and then, from the Then by list choose Field 2 and click Ok. This sorts the data into order by last name and then by first name where there are two or more people with the same last name.

If the names appear with the first name then a space and then last name you’ll have to tell Word to differentiate between the two names. To do this, select your list and choose Table, Sort, Options and click the Other option and press the Space bar and click Ok. From the Sort by list, choose Word 2 and then, from the Then by list choose Word 1 and click Ok. This sorts the data into order by last name and then by first name where there are two or more people with the same last name.

If you find that Word 2 doesn’t appear as an option in the Sort by list, click Ok to exit the Table Sort dialog and select the option again.

Helen Bradley

Friday, February 2nd, 2007

Save an Outlook message as a file

When you need to save a copy of an Outlook message simply hold the Control key as you drag it out of your Inbox and drop it into a folder in an open Windows Explorer window or onto the desktop.

The message is saved as a .msg format file that you can open again at any time by double clicking it in Windows Explorer. When you do this, the email itself opens and can be read, even if Outlook is not open.

To save a message as an .html file, open it and choose File, Save As and type a name for it and choose a location for it.

Helen Bradley

Thursday, February 1st, 2007

Align anything in Word

When you want to make sure everything on a Word page lines up properly, display the gridlines.

To do this, first display the Drawing toolbar then choose Draw, Grid and choose the Display gridlines on screen checkbox. Set the Use Margins option to start the grid aligned on the left and top margins. Set the value to 1 for small squares and to 2 or 3 for a larger grid.

If you select the Snap Objects to Grid checkbox all objects will automatically line up against the grid.

If you don’t want this to be the case, press the Alt key as you drag an object and it will be freed from snapping to align to the grid.

Helen Bradley

Wednesday, January 31st, 2007

Snap an Excel range

Take a picture of a range in Excel to insert into Word as a picture or to place as an image in another area on a workbook. To do this, first select the area to snap and hold Shift as you open the Edit menu. Choose Copy Picture, select As shown on screen or As shown when printed and click Ok.

You can now paste the image wherever you desire. This Shift + Edit menu option also works for copying a clip art or other type of image inserted into an Excel workbook.

Helen Bradley

Tuesday, January 30th, 2007

Random numbers in Excel

When you’re testing a workbook it is handy to be able to fill a set of cells with a sample value. The Randbetween function included in the Analysis Tookpak does this for you.

To enable this, choose Tools, Add-Ins and enable the checkbox for the Analysis Toolpak. Now write the function, for example, this provides a random number between 1 and 100 (including both numbers):

=randbetween(1,100)

Copy it to all the cells to fill. To fix the values so they don’t change each time something in the worksheet changes, select the cells with the formula, choose Edit, Copy then Edit, Paste Special, Values.

Helen Bradley

Sunday, January 28th, 2007

Quick Calculations in Word
Older versions of Word included a Calculate option on the Tools menu which let you make quick calculations.

You can add it back into later versions of Word by right clicking any toolbar and choose Customize. Select the Commands tab and, from the Categories list choose All Commands and scroll the Commands list to locate ToolsCalculate. Drag this onto the Tools menu and hold your mouse there until the menu opens and then drop the option into place. If desired, right click it and remove the word Tools from its name so it simply reads Calculate.

Now test it by typing some values eg 24, 25 & 26 and select them. Choose Tools, Calculate and the status bar will display “The result of the calculation is 75”.

If you later click Control + V you will paste the result of the calculation (75) into your document.

To sum a column of numbers, hold Alt as you drag over the column with your mouse then choose Tools, Calculate. It also works inside tables and you can type a more detailed calculations such as 25*25 and it will calculate the result for you (answer: 625)

Helen Bradley