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 todaySo 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 đ
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 đ
Are you sick of those extra long forwarded emails that seem to go on forever and ever? Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?
One way to do that is to forward an email as an attachment. Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!
To forward an email as an attachment in Outlook 2007:
1) Select the email you want to forward
2) Click on âActionsâ
3) Click on â Forward as Attachmentâ
4) Compose your message, and hit Send
âtill next time!
TNP đ
Does your Junk Mail folder in Outlook 2007 seem to continually build up with⌠well⌠junk mail? If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.
To automatically delete junk mail in Outlook 2007:
1) Click on âToolsâ
2) Click on âOptionsâ
3) Make sure you are on the âPreferencesâ tabâ
4) In the âE-mailâ section, click on the âJunk E-mailâŚâ button
5) On the âOptionsâ tab, look half way down for a checkbox that says âPermanently delete suspected junk e-mail instead of moving it to the Junk E-mail folderâ. Check that check box.
To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5
âtill next time!
TNP đ
You know how that box always pops up whenever you have a reminder in Outlook 2007? Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.
1) Click on âViewâ
2) Click on âReminders Windowâ
Easy as that!
âtill next time!
TNP đ
Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?
Well the simple, Breast
and great looking option is to use a Slide Background. A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.
To add a simple background to your PowerPoint 2007 presentation:
1) Click on the âDesignâ tab of the ribbon
2) Look for the âBackgroundâ group â on the right hand side of the ribbon
3) Click on âBackground Stylesâ
4) Select your preferred background
You will notice that not all the colours of the rainbow are available. Background styles are linked to the current colour palette that you have selected in the document. If you play around with the colors by clicking on the âColorsâ button whilst you are still on the âDesignâ tab of the ribbon, you will notice the background colour change to match the new palette.
âtill next time!
TNP đ
Do you want to do some hard core data manipulation in your PowerPoint presentation?
Well instead of adding a simple table layout to your slide, capsule you can actually add an Excel spreadsheet. You have all the features of Excel â like formulas, illness
but in a nice looking PowerPoint table.
To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:
1) Make sure you are on the slide you want to include the table in
2) Click on the âInsertâ tab of the ribbon
3) Click on the little arrow below the âTableâ button
4) Click on âExcel Spreadsheetâ
5) Enter your data, manipulate it, and format the table as you desire
âtill next time!
TNP đ
Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?
There are two ways you can go about it â the first is plain old copy and paste. The other is to use the âDuplicate Slideâ feature.
To duplicate slides in PowerPoint 2007:
1) Select the slide or slides you want to duplicate
2) Make sure you are on the âHomeâ tab of the ribbon
3) Look for the âSlidesâ group
4) Click on the little arrow underneath âNew Slideâ
5) Click on âDuplicate Selected Slidesâ
âtill next time!
TNP đ
Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?
To change to Portrait in PowerPoint 2007:
1) Make sure you are on the âDesignâ tab of the ribbon
2) Look for the âPage Setupâ group â on the left hand side of the ribbon
3) Click on âSlide Orientationâ
4) Click on âPortraitâ
To reverse back to Landscape, discount
just repeat the process above, but instead of clicking âPortraitâ at step 4, click on âLandscapeâ.
âtill next time!
TNP đ
Donât you hate it when you accidently click on a text box on your slide and move it? Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.
The good news is that there is a way to reset the slide back to normal. Funnily enough, it is called âResetâ. The best of this feature is, that it only resets the layout of the slide â your text will remain intact!
To reset a slide in PowerPoint 2007:
1) Select the slide you want to reset
2) Make sure you are on the âHomeâ tab of the ribbon
3) Look for the âSlidesâ group, close to the left hand side of the ribbon
4) Click on the âResetâ button â the button that looks like a slide with a blue arrow pointing to the left
âtill next time!
TNP đ
Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?
To do that, sale you need to âFreezeâ the top row of your sheet.
To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:
1) Click on the âViewâ tab of the ribbon
2) Look for the âWindowâ group
3) Click on âFreeze Panesâ
4) Click on âFreeze Top Rowâ
To unfreeze the top row, just repeat the process above, but instead of clicking âFreeze Top Rowâ in step 4), just click on âUnfreeze Panesâ
âtill next time!
TNP đ
Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, urticaria
or biggest to smallest?
To sort from high to low in Excel 2007, Sildenafil
Excel 2010 or Excel 2013:
1) Select the cells you want to sort
2) Click on the âDataâ tab of the Ribbon
3) Look for the âSort & Filterâ group
4) Click on the âSort Z to Aâ button â it is the one that has a Z on top of an A with an arrow pointing down.
âtill next time!
TNP đ