Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

---

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!

1) Christmas Clipart!

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

2) Holiday Letter Tutorial!

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 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

Have you ever noticed that your PowerPoint Presentations are running a little sluggish?  Maybe they jump through every transition, ed
or just take a long time to load up?

There is one way to help accelerate your PowerPoint deck – and that is to lower the resolution that it displays at.

To alter the resolution that your PowerPoint presentation uses:

1) Make sure you are on the “Slide Show” tab of the ribbon

2) Look for the “Monitors” group

3) Select your preferred resolution from the “Resolution” drop down box

To put it simply, the lower the resolution, the higher the performance of your presentation will be, but at a cost of lower fidelity.  On the flip side if you want to turn up the visual quality of the presentation, and don’t mind a little performance hit, crank up the resolution to as high as your computer (or more importantly your projector) can handle.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

2) Click on the “Animations” tab of the ribbon

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

Well like most things in Outlook 2007, this web
if you want you are able to change the default reply font color.

To do so:

1) Click on “Tools”

2) Click on “Options”

3) Click on the “Mail Format” tab

4) Click on “Stationery and Fonts” – about half way down the “Options” dialog box

5) About half way down the “Signatures and Stationery” dialog box that appears, you will find  a section called “Replying or forwarding messages”.  Click on the “Font” button directly below that, and then select the font colour you would like to use. 

6) Click “OK” three times to close all the boxes.

 

You can also change your default reply font and size using this technique

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Share this tip: on Twitter on Facebook on Google+