So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…
I hope you enjoy!
’till next time!
TNP đ
Oh My! Hasnât Christmas snuck up on us this year! Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!
Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing! There are over 100 pages of Christmas Clipart available at
This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations. It is about 30 minutes long â but will be a great investment of your time this Christmas to help you spread the holiday cheer!
3) Create your own Holiday Greeting Cards!
Another great resource to help you great special greeting cards to share with your family and friends â from the traditional, to the new age multimedia greeting cards with PowerPoint.
So there you have it, three great resources to help you make the most of Christmas this year!
âtill next time!
TNP đ
With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.
It is a lot simpler than you think! Here is how you do it.
1) Make sure you are connected to the internet
2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)
3) Click on âNewâ
4) In the âNew Documentâ dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online. click on âCalendarsâ
5) Click on â2010 calendarsâ
6) Pick your favourite design from the dozens that appear! Once you have selected the one you like, just click âDownloadâ in the bottom right hand corner
7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.
How easy is that! Happy New Year!
âtill next time!
TNP đ
Did you know in Word you can automatically select all the text in a document that shares the same formatting?
For example, read
you can select all text that is Arial, click 12pt. Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.
To select text with similar formatting in Word 2007:
1) Select some of the text you want to select
2) Make sure you are on the home tab of the ribbon
3) Look for the âEditingâ group on the right hand side of the ribbon
4) Click on âSelectâ
5) Click on âSelect Text with Similar Formattingâ
âtill next time!
TNP đ
Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?
It is really simple in Word 2007!
1) Select the text you want to change to UPPERCASE
2) Make sure you are on the âHomeâ tab in the ribbon
3) Look for the âFontâ group
4) Click on the âChange Caseâ button â which you will find directly below where you select the font size
5) From the menu that appears, decease
click on âUPPERCASEâ
Whilst you are there, check out some of the other case options you can have⌠like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.
âtill next time!
TNP đ
You know there are just some times when you really need to make a point! And using a double underline is a great way of making sure your readers know exactly what you mean!
Doing a normal, women’s health
single underline in Word 2007 is easy⌠but what about a double underline? Well it is just as easy.
1) Select the text you want to double underline
2) Make sure you are on the âHomeâ tab of the ribbon
3) Look for the âFontâ group"
4) Click on the little down arrow beside the âUnderlineâ button â that is the one that looks like a U with a underline below it
5) Select the underline that you would like to use.
âtill next time!
TNP đ
Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use âDouble Line Spacingâ
In Word 2007, visit this
is is fairly simple to do just that.
1) Select the text in your document that you want to apply double line spacing to
2) Make sure you are on the âHomeâ tab in the ribbon
3) Look for the âParagraphâ group
4) Look for the button that has an up arrow and a down arrow, with lines beside them â that is the âLine Spacingâ button. Click on that, and select â2.0â â that is double line spacing.
To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.
âtill next time!
TNP đ
Do you want to produce a document that uses a different paper size than Letter or A4? What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?
Well Word 2007 is very accommodating when it comes to paper size â and it is very easy to change.
1) Make sure you are on the âPage Layoutâ tab of the ribbon
2) Look for the âPage Setupâ group
3) Click on âSizeâ
4) Select your preferred paper size
You can also create a custom paper size if you want â just select âMore Paper SizesâŚâ and then âCustomâ
Is there a section of text in your document (or your whole document!) that isnât âEnglish (United States)â or another language. Well to make sure that your spelling and grammar checks in Word 2007 work well, ampoule you need to make sure that text is marked as the right language.
So how do you mark a section of text as a different language?
1) Select the text
2) Make sure you are on the âReviewâ tab of the ribbon
3) Look for the âProofingâ groupâ
4) Click âSet Languageâ
5) Select your preferred language
Now you can be confident that spell check is doing the right thing!
âtill next time!
TNP đ
Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.
By using the âTranslation ScreenTipâ you can see the translation of most words simply by moving the mouse over them!
Translation ScreenTip works for the following languages:
- Arabic (Saudi Arabia)
- English (United States)
- French (France)
- Spanish (Spain, here International Sort)
To turn on Translation ScreenTip:
1) Make sure you are on the âReviewâ tab of the ribbon
2) Look for the âProofingâ group
3) Click on âTranslation ScreenTipâ
4) Select the language you want to see the translation for, meningitis
or click on âTurn Off Translation ScreenTipâ to turn the translation off.
âtill next time!
TNP đ
Are you bored of bullets that just look like⌠well⌠bullets? Did you know you can change the look of the bullets in your bulleted lists in Word 2007?
To do soâŚ
1) Make sure you are on the âHomeâ tab of the Ribbonâ
2) Look for the âParagraphâ group
3) Click on the little arrow beside the âBulletâ button
4) Select a bullet design from the âBullet Libraryâ, diabetes and Pregnancy
or click on âDefine New Bulletâ
If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want! You could literally use a mug shot of yourself as a bullet if you really wanted to!
That could be too much fun!
âtill next time!
TNP đ
Are you bored of bullets that just look like⌠well⌠bullets? Did you know you can change the look of the bullets in your bulleted lists in Word 2007?
To do soâŚ
1) Make sure you are on the âHomeâ tab of the Ribbonâ
2) Look for the âParagraphâ group
3) Click on the little arrow beside the âBulletâ button
4) Select a bullet design from the âBullet Libraryâ, story
or click on âDefine New Bulletâ
If you are defining a new bullet, you will see that you can select any symbol or picture that you want! You could literally use a mug shot of yourself as a bullet if you really wanted to!
That could be too much fun!
âtill next time!
TNP đ
Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007. You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.
To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:
1) Make sure you are on the âInsertâ tab of the ribbon
2) Look for the âTextâ group â it will be on the right hand side of the ribbon
3) Click on âHeader & Footerâ
You will see a new tab appear on the ribbon called âHeader & Footer Tools â Designâ. Using the buttons on this tab of the ribbon, you can quickly add:
- Page Number;
- Number of Pages;
- Current Date;
- Current Time;
- File Path;
- File Name;
- Sheet Name; or a
- Picture
To the header or footer of your document. To switch from the header to the footer, simply click on âGo to Footerâ which you will find in the âNavigationâ group about half way along the ribbon.
âtill next time!
TNP đ
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007? Well did you know you very quickly protect your spreadsheet from those rogue operators!
Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:
1) Make sure you are currently looking at the sheet you want to protect
2) Click on the âReviewâ tab in the ribbonâ
3) Look for the âChangesâ groupâ
4) Click on âProtect Sheetâ
A little âProtect Sheetâ dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.
For example, you can allow users to select cells, but not format them. You can allow people to insert rows, but not insert columns. And best of all you can add a password to the sheet to ensure only you can make any changes to what can and canât be modified.
Now, you are really in control!
âtill next time!
TNP đ
Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.
By using the âTrace Precedentsâ feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell. The best part of this feature is, nurse
that you will see big arrows that enable you to visually see the relationship, so you donât have to decipher formulas and cell names to make sense of it all.
To turn on Trace Precedents:
1) Select the cell you want to see the precedents of
2) Make sure you are on the âFormulasâ tab of the ribbon
3) Look for the âFormula Auditingâ group (about 3/4 of the way along the ribbon)
4) Click on âTrace Precedentsâ
Now you will see arrows pointing you in the right direction!
âtill next time!
TNP đ
Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.
By using the âTrace Dependentsâ feature, you can very quickly understand exactly the influence a cell has in your spreadsheet. The best part of this feature is, that you will see big arrows that enable you to visually see the relationship, so you donât have to decipher formulas and cell names to make sense of it all.
To turn on Trace Dependents:
1) Select the cell you want to see the dependents of
2) Make sure you are on the âFormulasâ tab of the ribbon
3) Look for the âFormula Auditingâ group (about 3/4 of the way along the ribbon)
4) Click on âTrace Dependentsâ
Now you will see arrows pointing you in the right direction!
âtill next time!
TNP đ