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
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.
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.
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…
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.