Banner

Archive for the ‘Level 200 - Regular User’ Category



Add a background image in Excel 2007

Icon Written by The New Paperclip on April 19, 2008 – 1:51 pm

Do you want to pretty up your spreadsheets just a little?  Why not add a picture in the background!  It could be a company logo, a nice relaxing beach landscape or a picture of your kids… whatever it is… it is really simple to add a background image to your spreadsheets in Excel 2007

Open up […]



How to wrap text in Excel 2007

Icon Written by The New Paperclip on April 19, 2008 – 1:42 pm

Are you like me and tend to write lots and lots in your cells in Excel 2007?  It might be a good idea to make the text wrap.
What does wrapping text mean?  Basically it is where you take one long line of text, and make it "wrap" around onto a number of lines instead.  That […]



Change the default reminder time in Outlook 2007

Icon Written by The New Paperclip on April 15, 2008 – 9:51 pm

It has happened to the best of us.  Your day is going along great, and then all of a sudden you get an Outlook reminder… a reminder for that meeting you totally forgot about.
Now you just have 15 minutes to salvage something out of nothing and impress the boss/wife/colleague/all of the above.
Don’t want to get […]



Merge and Center in Excel 2007

Icon Written by The New Paperclip on April 14, 2008 – 9:24 pm

Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?
Chances are they are using a great feature of Excel 2007 called "Merge and Center".  What does merge and center do?  Exactly that - it merges all the cells you have selected, and then centres the […]



Reduce your carbon footprint with Microsoft Office 2007

Icon Written by The New Paperclip on April 14, 2008 – 8:38 pm

Want to be a desktop publishing great, spreadsheeting wiz or PowerPoint guru and help the environment at the same time?
Guess what - you might be already!
Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.
Obviously they left one tip for reducing your impact on the […]



Print background colors and images in Word 2007

Icon Written by The New Paperclip on April 14, 2008 – 8:20 pm

Have you ever poured your heart and soul into absolutely awesome background in your word doc?  Maybe you coloured it bright yellow, or purple, or ‘mother of pearl’? 
It looks great on the screen, but when you print it… you can’t see it!
Did you know by default Microsoft Word 2007 that background colors and images […]



Add some colour to your documents… Paragraph Shading in Word 2007

Icon Written by The New Paperclip on August 19, 2007 – 6:52 pm

Ever wanted to put some colour behind your text in a word document?  Not just highlight something, but add color to the entire paragraph?  It’s pretty easy in Word 2007.
1) Type your text into your document.  Generally it is easier to work with all your text, rather than formatting it as you go
2) Look on […]



Automatically Check Spelling when Sending an Email in Outlook 2007

Icon Written by The New Paperclip on June 8, 2007 – 9:22 pm

If you are like me… you always click send… and then realise just before the email disappears that there is a huge spelling mistake right in the middle of your email.  Don’t you just hate that!  I have been caught out so many times… if only there was a way to automatically spell check all […]



Change Line Spacing in Word 2007

Icon Written by The New Paperclip on May 20, 2007 – 4:48 pm

Everyone has their favourite line spacing!  Some like as much information as possible crammed into a page and go for single line spacing, whilst others like their white space and go for double (or even TRIPLE!) line spacing.  Line spacing can make a document easy to read, or can make it an absolute nightmare to […]



Number Formatting in Excel 2007

Icon Written by The New Paperclip on May 3, 2007 – 6:27 pm

So you have a worksheet with some numbers, but they are not your standard type of number… maybe they are a dollar figure, maybe they are a date or time, percentage or fraction.  To make sure Excel 2007 interprets them the way you interpret them, you need to format the number properties the cell.
How to […]