Wednesday, April 4th, 2007
Monday, April 2nd, 2007
Sunday, April 1st, 2007
Saturday, March 31st, 2007
Friday, March 30th, 2007
Ok, so this post is seriously off topic but I just had to write it. I subscribe to a great email newsletter written by horseman Doug Emerson and which you can find here: www.profitablehorseman.com.
He writes great stuff, common sense, smart and very business oriented. I don’t know anyone who couldn’t benefit from his ‘pearls of wisdom’ whether or not you know what end of a horse the food goes in.
Ok so what about the Make My Day bit. Well, I took the time to write to Doug today to say hi and thanks for his stuff. It was just a short email, a few lines but very soon a reply came back and in it he said “you made my day!” – that’s exactly what I feel when someone who has read an article I wrote writes to say “Hi and Thanks”. When the “Hi and Thanks” comes without strings, no questions attached, just an out of the blue pat on the back it really does just that, it makes your day, whoever you are.
So, my challenge to you? Go ahead and make someone’s day. Next time you read something and think “that was good/cool/interesting/well written…” email them. Say hi and thanks. Pass the good word feelings around, curiously, I think (in the process), you’ll find it makes your day too!
Labels: Unshamedly Off Topic
Thursday, March 29th, 2007
Wednesday, March 28th, 2007
Tuesday, March 27th, 2007
Friday, March 23rd, 2007
When you’re working on a very big spreadsheet it can get confusing as to what the headings are for the various rows and columns when you move away from the top most cells.
A simple way to solve this problem is to freeze panes – it’s a funny term for something that actually is very handy. Move so that cell A1 is located in the top left corner of your worksheet area and then position your cell pointer just below the set of headings that you want to see and just to the right of the column headings if they’re important too.
Choose Window, Freeze Panes and Excel will freeze the area above and to the left of where you are working. Now if you move around the worksheet wherever you happen to go the cells on the left and top of the worksheet will always be there.
If you need to undo the effect choose Window, Unfreeze Panes and it will all be back to rights. My guess is that you’ll like it so much that you won’t want to change it anyway.
Thursday, March 22nd, 2007
In a previous tip of the day, I showed you how to create shaped comments in Excel but today I’m going to go one step further and create pictures inside the comment.
As you might expect, start off in Excel and add a comment to a cell. Right-click the cell and choose Show comment and then click the border of the comment to select it. Choose Format, Comment and, from the Colors & Lines tab’s Color dropdown list choose Fill Effects and then the Picture tab and click Select Picture.
Find a picture to add to your comment from those in your My Pictures folder, enable the Lock Picture Aspect Ratio checkbox and click OK twice. You’ll now have the image inside your comment.
Depending on the image that you have used you may want to change the format of the text, for example coloring it a different color and sizing it large enough so that it can be easily seen.
Wednesday, March 21st, 2007
New to Microsoft Office 2007 PowerPoint, Excel and Word is the SmartArt feature which is one you’re just going to love.
To test it out add a new slide to a PowerPoint presentation, for example, and select the blank layout. From the Insert tab on the Ribbon, select SmartArt and then one of the SmartArt objects.
I like the one called Staggered Process which I’ve shown here as it makes a great display for a simple step-by-step process. Select your choice of design and then you’ll see text brackets appear on the screen. Click in them or click the double-pointing arrows at the left of the SmartArt object and type your text in the special dialog.
Once you’ve got your bullet points in – and you can add more than the default three if you need more – you have a simple step-by-step graphic. But – this is only the beginning.
There are lots of different looks for your graphic including beveled edges and 3D effects, and you can choose these from the SmartArt styles dropdown list in front of you. You can also change the colors used in the design which, of course, are based on the current document Theme colors. Change the Design Ttheme and the look of the project changes with it.
It’s about as simple as it’s ever going to be to add great looking step-by-step graphics to a PowerPoint slide. They are, seriously, way cool…
Tuesday, March 20th, 2007
When you’re working with different areas on an Excel worksheet it sometimes helps to name the area or range as Excel calls it.
You might do this so that you can easily select a print area from a number of different printing areas on the worksheet or where you want to move very quickly to a named area which is in an out of the way place on the worksheet.
To name a range, select the cell or range of cells to name and choose Insert, Name, Define and give the cell or range a name. You can use whatever name you like, it just must be a single word name with no spaces and it can’t start with a number. When you’re done, click OK.
Now look up to the top left corner of the screen to the left of the formula bar you will see a small Name dropdown list. You can dropdown the list and select the named cell from the list and you will automatically go to it and, if it is a range, it will be automatically selected ready, for example, for printing.
Tuesday, March 20th, 2007
In what was to become a classic “snooze and you lose” scenario I planned to return later that day to get the code.
Yeah! right. Like the planets were all in some sort of weird cosmic alignment on that one. By nightfall, the site was gone. Seems like the owner probably didn’t pay their domain name registration and it expired – the very day I was planning to download their utility. So, the site is gone and because you could only download the tool from that site, I now can’t have it.
I’m off to check the registration expiry dates on all my sites, this one, http-design, my namesake, helenbradley.com and my ecommerce site backgroundartz.com. It’s a salutary lesson on the importance of making sure you pay your registration fees on time or there are squatters out there who will move in within seconds of the time expiring – there’s no late fee payable, when you’re over time, you’re out.
If anyone knows where BoxOut can be downloaded from, I’d love to hear from you!
In the meantime – check your domain name expiry dates. Mark your calendars and pay up well in advance or the next person who loses years of good will could be you.
UPDATE: BoxOver is back! Well, sort of.. read on..
Actually, on reflection, I think BoxOver never really left. You see, it comes and goes… it’s there one time you visit and not the next. So, first off, snaffle a copy while you can… it’s the neatest utility around – if it’s there when you visit the site, grab it and don’t think twice!
I think the site probably has a daily download limit and when it exceeds this it closes down and you get a funky portal view which is useless. The solution is to get up really early (or, my preference, stay up really late!) and snag it when a new day begins and the site is up.
Anyway, short answer is – it’s there, you just have to be lucky and if you miss it once, try again later.
Monday, March 19th, 2007
When you’re working on a very big worksheet in Excel sometimes it happens that when you print it out you get a stray row or column on a single sheet of paper. It’s not only a nuisance but it’s also a waste of paper.
To ensure that this doesn’t happen choose File, Page Setup and click the Page tab. The Fit To option lets you specify the number of pages wide or tall that a worksheet is. Select the measurements that you want to fit, for example fitting to one page wide by one page tall will print everything on a single page.
What if you don’t know both measurements? Don’t worry, if you know you want it one page wide but don’t know how tall that will be, select Fit to 1 Page Wide and leave the Tall box empty – that means delete anything that’s in it.
This works the same if you know how tall you want it to be but not how wide. It’s a smart way of saving trees and frustration and it looks much neater than handing someone something with a skerrick of info on the last page.