Ok… so being The New Paperclip you know I love everything Office. Well my old friends at Microsoft are just about to launch something new. It is a little different to the Office that you are used to though. But don’t worry, pharm it is a good thing!!
So what is Office 365? Well if you run a small business, approved or are a manager at a larger one, you might be interested. Office 365 gives your business:
Email & Calendar functionality so you can manage your day
Office Web Apps, so you can view and edit your documents, spread sheets and presentations from any computer with an internet browser
A website for your business
The ability to instant message, video conference and set up professional online meetings
All of that out of something Microsoft calls “The Cloud” – that is just a fancy way of saying you don’t need to run your own servers if you don’t want to – Microsoft will do it for you.
The other exciting part is that instead of paying hundreds or thousands of dollars up front for the above, you get to pay per user per month. Depending on which Office 365 version you sign up for… you can also get a subscription based version Office 2010 on your desktop as well, without having to pay up front!
If any of the above sounds like it would help your business, you should check out Office 365 at www.office365.com
In the mean time, here at TheNewPaperclip.com we are broadening our content – we are now publishing tips and tricks and other articles that will give you all the Office 365 Help you need. You will see more and more of that content appear over the next few weeks and months.
A quick post for all you guys out there that have to manage Office 2010 deployments in a business. Microsoft have made available a great resource that outlines all the different Group Policy settings for Office 2010 – a must have resource if you want to manage your Office 2010 deployment well.
Well it is New Years Day in most of the world – Welcome to 2011!!!
So with that in mind lets figure out how to create a 2011 Calendar using Word 2010. Creating a personalised calendar – whether a simple month view or something a bit more complicated which you can record appointments, mind see the lunar phases, try
or public holidays – is an absolute breeze.
Here is how to create a 2011 Calendar in Word 2010:
With 2010 behind us in most parts of the world, women’s health
now is the time to start creating your own 2011 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 “2011 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.
It couldn’t be any simpler than that. Wishing you and your family a wonderful year ahead!
A quick post for all you guys out there that have to manage Office 2010 deployments in a business. Microsoft have made available a great resource that outlines all the different Group Policy settings for Office 2010 – a must have resource if you want to manage your Office 2010 deployment well.
Well it is New Years Day in most of the world – Welcome to 2011!!!
So with that in mind lets figure out how to create a 2011 Calendar using Word 2010. Creating a personalised calendar – whether a simple month view or something a bit more complicated which you can record appointments, mind see the lunar phases, try
or public holidays – is an absolute breeze.
Here is how to create a 2011 Calendar in Word 2010:
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…
web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
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!
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:
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 aheader 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 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, rx or smallest to biggest?
To sort from low to high in Excel 2007, 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 A to Z†button – it is the one that has an A on top of a Z with an arrow pointing down.
Do you want your page to stretch right across your monitor? By using “Zoom to Page Width†you can do just that.
To Zoom to Page Width in Word 2007:
1) Click on the “View†tab in the ribbon
2) Look for the “Zoom†group
3) Click on “Page Widthâ€
‘till next time! TNP 😉
Have you ever change the font size or the font type or the font colour one too many times and realised that it would be far easier just to start again?
Well instead of deleting your text and having to retype it, here
you can use a feature of Word 2007 called “Clear Formattingâ€.
As the name suggests, “Clear Formatting†will remove all the formatting you have applied to your text, and set it back to the default paragraph style.
You can find the “Clear Formatting†button on the “Home†tab of the ribbon, in the “Font†group. Just select the text you want to clear up, and then click on the button.
‘till next time! TNP 😉
Usually PowerPoint presentations are built to be delivered on-screen. Using the print options you can create handouts and notes pages that you can then print out and hand to your audience.
But did you know that you can use PowerPoint to design presentations built specifically to be delivered in the print format. One slide per A4 or Letter page (and not a cropped or zoomed version of an onscreen slide)
To do so, look
all you need to do is change the page size of the PowerPoint slides in your deck.
1) Click on the “Design†tab
2) Click on “Page Setup†in the “Page Setup†group on the left hand side of the ribbon
3) In the “Page Setup†window, in the drop down box “Slides sized for:†select your preferred paper size
This is a great way to design slides specifically for transparencies or over-head projectors as well.
‘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, viagra sale you need to “Freeze†the top row of your sheet.
To Freeze the top row in Excel 2007:
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, eczema
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 want a great looking presentation, women’s health
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?
Well the simple, 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 😉
Did you know that Outlook 2007 saves drafts of your emails as you type them? This is great if you accidentally close the email window before sending, disease
or start an email and then the power goes out.
By default Outlook will save a draft every three minutes. But if you are paranoid about losing your work… or don’t care that much… you can change the timeframes in which the auto-save occurs.
To increase or decrease the auto-save time for draft emails in Outlook 2007:
1) Click “Options†from the menu
2) Make sure you are on the “Preferences†tabâ€
3) Click the “E-mail Options…†button
4) Click the “Advanced E-Mail Options…†button (about half way down the window)
5) Beside the first checkbox (“AutoSave items every:â€) change the number to the number of minutes you would like the interval to be
6) Click OK 3 times to close all the windows
To find the drafts that Outlook saves, just take a look in your drafts folder
‘till next time! TNP 😉
Do you want to create a slide that is Portrait, order 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, just repeat the process above, but instead of clicking “Portrait†at step 4, click on “Landscapeâ€.
‘till next time! TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, help or smallest to biggest?
To sort from low to high in Excel 2007:
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 A to Z†button – it is the one that has an A on top of a Z with an arrow pointing down.
‘till next time! TNP 😉
Have you noticed when you spell check an email where you are replying to or forwarding another email, try
that sometimes spell check decides it needs to highlight the poor spelling of your friend or colleague?
Well if you get annoyed by that as much as I do, approved
you will be glad to know there is a setting in Outlook 2007 to ensure that the spelling and grammar checker only checks the content you wrote.
To ignore the original message text in reply or forward:
1) Click “Toolsâ€
2) Click “Optionsâ€
3) Click on the “Spelling†tab
4) Check the box “Ignore original message text in reply or forwardâ€
‘till next time! TNP 😉
The To-Do bar in Outlook 2007 is a great time saver – a quick way to understand your current workload, discount
and upcoming appointments.
By default there should be three upcoming appointments shown in the to-do bar – but did you know that you can customise it so you can show more, see
or less appointments?
To increase or decrease the number of upcoming appointments shown in the Outlook 2007 to-do bar:
1) Right click on the To-Do Bar
2) Click “Options…†from the menu that appears
3) In the “To-Do Bar Options†box that appears, change the number of appointments to your preferred number.
Whilst you can have more appointments visible than that can fit on your screen, don’t go to overboard… 5 or 7 would be the upper limit for it to be useful.
‘till next time! TNP 😉
Are you sick of clicking your mouse, pfizer
hitting a key, health
or pressing next on your wireless presenter?
Well in PowerPoint 2007, 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 😉
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â€, artificial
or click on “Define New Bulletâ€
If you are defining a new bullet, dosage
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 😉
Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007.
By using the “Trace Dependents†feature, tuberculosis
you can very quickly understand exactly the influence a cell has in your spreadsheet. The best part of this feature is, look
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 😉
Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, ailment
and what the email subject is?
Well using the “Auto Preview†feature in Outlook 2007, case 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 😉
Do you want to quickly insert a blank page into your Word 2007 document? Instead of hitting enter 40 times, pharm
why don’t you use the Insert Blank Page button?
All you have to do is:
1) Make sure you are on the “Insert†tab of the ribbon
2) Look for the pages group – on the left hand side
3) Click on “Blank Pageâ€
Now you will see a blank page appear in your document where your cursor was. To add multiple blank pages, just keep clicking that “Blank Page†button!
‘till next time! TNP 😉
If you have ever printed handouts for your PowerPoint presentations before, unhealthy you know that they can be pretty bland. Just the slides all stacked up on a page, with plenty of whitespace.
Well did you know that you have complete control over how those handouts actually look? You can add your company logo, or a copyright statement, or remove the date or the page numbers. You can do whatever you want!
All of this is controlled from what is called the “Handout Masterâ€. Those of you familiar with the “Slide Master†will know exactly what we are talking about. The easiest way to describe the handout master is that it is the template for all the handouts printed from the presentation.
To access the Handout Master in PowerPoint 2007:
1) Click on the “View†tab in the ribbon
2) In the “Presentation Views†group on the left hand side, click on “Handout Masterâ€
Once you are in the master, you can control all manner of different things, including the page setup, the handout orientation (portrait or landscape), the slide orientation on the handouts, and how many slides will appear on each page.
To get out of the “Handout Master†view… simply click the “Close Master View†button on the right hand side of the ribbon
‘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, purchase
and want to review all the reminders you currently have, buy cialis 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 😉
Have you ever read a document that has a line like… “See more in section 5.1†or “Refer to figure 8â€
Did you know in Word 2007 you can create these cross references, remedy
and automatically include a hyperlink which when clicked will take the reader directly to the content?
It looks a little complicated when you first take a look, denture
but here is the easy way to create a cross reference in Word 2007
1) Make sure any content you are going to cross reference to exists in the first place. If you have pictures which you will refer to as figures for example, gynecologist
make sure you are using captions – if not, you can’t cross reference to them
2) Click where you want the cross reference to be placed in your document
3) Click on the “Insert†tab of the ribbon
4) Look for the “Links groupâ€
5) Click on “Cross-referenceâ€
6) You will see two drop down boxes in the “Cross-reference†window. In the first drop down box, select the type of thing in your document you want to cross reference to – for example if you want to link to a heading, select “Headingâ€, if you want to cross reference to a figure, select “Figureâ€
7) You will notice that in the big white box below, a list of all the different things you can cross reference to will now appear. Select the item you want to cross reference to. Note, if it doesn’t appear in the list, chances are you haven’t used the right caption, or used a heading style on the item
8) In the second drop down box, select how you want the cross reference described to take the reader of the document – do you just want the page number? or the heading text, or the caption, or the figure number? Select your preferred option
9) When you are ready, click on “Insertâ€
‘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, ampoule 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 😉
Do you want to copy one, treatment two, pancreatitis
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 regularly resize the width of your columns and cells in Excel 2007? Maybe you make them bigger? Maybe you make them smaller. Either way, diagnosis there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.
To change the default width in Excel 2007:
1) Make sure you are on the “Home†tab of the ribbon
2) Look for the “Cells†group
3) Click on “Formatâ€
4) Click on “Default Width…â€
5) in the “Standard Width†box that appears, recipe
type in the desired width of your columns
6) Click “OKâ€
‘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, viagra approved
you can actually add an Excel spreadsheet. You have all the features of Excel – like formulas, but in a nice looking PowerPoint table.
To insert an Excel table in PowerPoint 2007:
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 😉
Hi there!
Are you on the bleeding edge and have already had a play around with the beta version of Microsoft Office 2010? Or are you just interested in what is coming in the next version of your favourite productivity tool? Well do we have a great link for you today!
Our friends over at Microsoft Press have released a few electronic version of the book – “First Look Microsoft Office 2010â€. 14 chapters of Office 2010 gold, overweight
including:
I have had a lot of feedback from readers of TheNewPaperclip.com, therapy
and those that subscribe to the Office 2007 tips newsletter. People are screaming out for short, pilule
concise courses that will help them do overcome annoying challenges, and do amazing things with Office 2007.
These people – maybe you – have had thoughts like “How do I get Outlook to do this?…â€, “How can I get my document to look as great as Jenny’s?…â€. “How come everyone says how good Brad’s PowerPoint slides are?â€
There are plenty of different ways to answer those questions – maybe you have tried some of them, like courses or books. But they are not for everyone:
Maybe you live in a remote area and can’t get to an instructor lead class because the closest one is 1, 2, 3, or even 6 hours away by car.
Maybe you think that reading a bland text book that is 600 pages long is not fun (I AGREE!)
Maybe you just want to interact with someone who will be able to give you the answers you need?
If you answered yes to just one of the above – then it sounds like the Office 2007 workshops I will be delivering during the next few months will be exactly what you need.
Are you like many of your fellow TheNewPaperclip.com readers and want to improve your capability and confidence with Office 2007?
If so – these four 2 hour workshops are designed just for you.
Overcome Email Overload with Outlook 2007 Get to know the key features of Outlook 2007 to help you mange your mail – plus time saving techniques that will enable you to conquer your inbox
Crunch Numbers Faster with Excel 2007 Confidently apply formulas, create charts, and communicate complex data with meaning using Excel 2007
Create Better Looking Documents with Word 2007 Build documents for your workplace, club or school that you can be proud of using Word 2007
Deliver Better Presentations with PowerPoint 2007 Forget boring bullet points – learn the techniques professional speakers (and their designers) use to build compelling slide decks using PowerPoint 2007
The workshops will be delivered online, will be interactive, and attendance will be strictly limited to ensure everyone in the workshop gets the results they are after.
For more information as it becomes available over the next few weeks – including dates, times, and workshop prices – and to be one of the first to find out when bookings for each of the workshops have opened – register your details here:
By the way… if you pre register you will have access to a multiple workshop discount as well!
So if you are ready to get the most out of Office 2007 – make sure you register for more information, and then book into one of the workshops… coming soon.
‘til next time! TNP 😉
If you are looking to spread some Easter cheer with your family, more about
friends, visit this site
or colleagues this Easter, why not use one of these great Easter templates for Word 2007 and OneNote 2007 Office Online!
So if you are a bit of an Office freak like me, online you will know that Office 2010 was RTM’d last week (Released to Manufacturing – a fancy way of saying “yep, its readyâ€). It will be available in the shops in the next few months, but if you are a corporate customer with a volume licensing agreement – or you have a subscription to MSDN or TechNet – you will find you can get the Office 2010 bits, and product keys already.
With RTM comes a shift in content here at The New Paperclip. Whilst I will still produce Office 2007 content, there is a whole new world of Office 2010 that is to be explored, documented, and published in easy to understand language just for you kind folks!
Before we get into the nitty gritty of Office 2010 – there is one thing I would love to share with you.
One thing that most of you will like (and people that work on IT Helpdesks will LOVE) about Office 2010 is that the File Menu is back! Well, technically it never left, but in Office 2007 it wasn’t called the File Menu, it was simply this weird looking “Office Orbâ€.
So IT Managers – if you are looking for a quick win to cut your helpdesk calls dramatically (you know… all the ones that were like “Where has Print goneâ€, Where has Save gone†etc) – just upgrade to Office 2010. Because everyone knows, you find them in the File Menu. And you will not get as many calls about
“What is that funny looking circle thing… what do you mean you want me to click on it? It doesn’t look like a button!â€
If you are upgrading to Office 2010 – make sure you subscribe or check back regularly for more tips, tricks and tutorials.
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…
web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
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!
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:
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 aheader 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.
Do you want your page to stretch right across your monitor? By using “Zoom to Page Width†you can do just that.
To Zoom to Page Width in Word 2007:
1) Click on the “View†tab in the ribbon
2) Look for the “Zoom†group
3) Click on “Page Widthâ€
‘till next time! TNP 😉
Have you ever change the font size or the font type or the font colour one too many times and realised that it would be far easier just to start again?
Well instead of deleting your text and having to retype it, here
you can use a feature of Word 2007 called “Clear Formattingâ€.
As the name suggests, “Clear Formatting†will remove all the formatting you have applied to your text, and set it back to the default paragraph style.
You can find the “Clear Formatting†button on the “Home†tab of the ribbon, in the “Font†group. Just select the text you want to clear up, and then click on the button.
‘till next time! TNP 😉
Usually PowerPoint presentations are built to be delivered on-screen. Using the print options you can create handouts and notes pages that you can then print out and hand to your audience.
But did you know that you can use PowerPoint to design presentations built specifically to be delivered in the print format. One slide per A4 or Letter page (and not a cropped or zoomed version of an onscreen slide)
To do so, look
all you need to do is change the page size of the PowerPoint slides in your deck.
1) Click on the “Design†tab
2) Click on “Page Setup†in the “Page Setup†group on the left hand side of the ribbon
3) In the “Page Setup†window, in the drop down box “Slides sized for:†select your preferred paper size
This is a great way to design slides specifically for transparencies or over-head projectors as well.
‘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, viagra sale you need to “Freeze†the top row of your sheet.
To Freeze the top row in Excel 2007:
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, eczema
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 want a great looking presentation, women’s health
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?
Well the simple, 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 😉
Did you know that Outlook 2007 saves drafts of your emails as you type them? This is great if you accidentally close the email window before sending, disease
or start an email and then the power goes out.
By default Outlook will save a draft every three minutes. But if you are paranoid about losing your work… or don’t care that much… you can change the timeframes in which the auto-save occurs.
To increase or decrease the auto-save time for draft emails in Outlook 2007:
1) Click “Options†from the menu
2) Make sure you are on the “Preferences†tabâ€
3) Click the “E-mail Options…†button
4) Click the “Advanced E-Mail Options…†button (about half way down the window)
5) Beside the first checkbox (“AutoSave items every:â€) change the number to the number of minutes you would like the interval to be
6) Click OK 3 times to close all the windows
To find the drafts that Outlook saves, just take a look in your drafts folder
‘till next time! TNP 😉
Do you want to create a slide that is Portrait, order 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, just repeat the process above, but instead of clicking “Portrait†at step 4, click on “Landscapeâ€.
‘till next time! TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, help or smallest to biggest?
To sort from low to high in Excel 2007:
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 A to Z†button – it is the one that has an A on top of a Z with an arrow pointing down.
‘till next time! TNP 😉
Have you noticed when you spell check an email where you are replying to or forwarding another email, try
that sometimes spell check decides it needs to highlight the poor spelling of your friend or colleague?
Well if you get annoyed by that as much as I do, approved
you will be glad to know there is a setting in Outlook 2007 to ensure that the spelling and grammar checker only checks the content you wrote.
To ignore the original message text in reply or forward:
1) Click “Toolsâ€
2) Click “Optionsâ€
3) Click on the “Spelling†tab
4) Check the box “Ignore original message text in reply or forwardâ€
‘till next time! TNP 😉
The To-Do bar in Outlook 2007 is a great time saver – a quick way to understand your current workload, discount
and upcoming appointments.
By default there should be three upcoming appointments shown in the to-do bar – but did you know that you can customise it so you can show more, see
or less appointments?
To increase or decrease the number of upcoming appointments shown in the Outlook 2007 to-do bar:
1) Right click on the To-Do Bar
2) Click “Options…†from the menu that appears
3) In the “To-Do Bar Options†box that appears, change the number of appointments to your preferred number.
Whilst you can have more appointments visible than that can fit on your screen, don’t go to overboard… 5 or 7 would be the upper limit for it to be useful.
‘till next time! TNP 😉
Are you sick of clicking your mouse, pfizer
hitting a key, health
or pressing next on your wireless presenter?
Well in PowerPoint 2007, 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 😉
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â€, artificial
or click on “Define New Bulletâ€
If you are defining a new bullet, dosage
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 😉
Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007.
By using the “Trace Dependents†feature, tuberculosis
you can very quickly understand exactly the influence a cell has in your spreadsheet. The best part of this feature is, look
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 😉
Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, ailment
and what the email subject is?
Well using the “Auto Preview†feature in Outlook 2007, case 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 😉
Do you want to quickly insert a blank page into your Word 2007 document? Instead of hitting enter 40 times, pharm
why don’t you use the Insert Blank Page button?
All you have to do is:
1) Make sure you are on the “Insert†tab of the ribbon
2) Look for the pages group – on the left hand side
3) Click on “Blank Pageâ€
Now you will see a blank page appear in your document where your cursor was. To add multiple blank pages, just keep clicking that “Blank Page†button!
‘till next time! TNP 😉
If you have ever printed handouts for your PowerPoint presentations before, unhealthy you know that they can be pretty bland. Just the slides all stacked up on a page, with plenty of whitespace.
Well did you know that you have complete control over how those handouts actually look? You can add your company logo, or a copyright statement, or remove the date or the page numbers. You can do whatever you want!
All of this is controlled from what is called the “Handout Masterâ€. Those of you familiar with the “Slide Master†will know exactly what we are talking about. The easiest way to describe the handout master is that it is the template for all the handouts printed from the presentation.
To access the Handout Master in PowerPoint 2007:
1) Click on the “View†tab in the ribbon
2) In the “Presentation Views†group on the left hand side, click on “Handout Masterâ€
Once you are in the master, you can control all manner of different things, including the page setup, the handout orientation (portrait or landscape), the slide orientation on the handouts, and how many slides will appear on each page.
To get out of the “Handout Master†view… simply click the “Close Master View†button on the right hand side of the ribbon
‘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, purchase
and want to review all the reminders you currently have, buy cialis 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 😉
Have you ever read a document that has a line like… “See more in section 5.1†or “Refer to figure 8â€
Did you know in Word 2007 you can create these cross references, remedy
and automatically include a hyperlink which when clicked will take the reader directly to the content?
It looks a little complicated when you first take a look, denture
but here is the easy way to create a cross reference in Word 2007
1) Make sure any content you are going to cross reference to exists in the first place. If you have pictures which you will refer to as figures for example, gynecologist
make sure you are using captions – if not, you can’t cross reference to them
2) Click where you want the cross reference to be placed in your document
3) Click on the “Insert†tab of the ribbon
4) Look for the “Links groupâ€
5) Click on “Cross-referenceâ€
6) You will see two drop down boxes in the “Cross-reference†window. In the first drop down box, select the type of thing in your document you want to cross reference to – for example if you want to link to a heading, select “Headingâ€, if you want to cross reference to a figure, select “Figureâ€
7) You will notice that in the big white box below, a list of all the different things you can cross reference to will now appear. Select the item you want to cross reference to. Note, if it doesn’t appear in the list, chances are you haven’t used the right caption, or used a heading style on the item
8) In the second drop down box, select how you want the cross reference described to take the reader of the document – do you just want the page number? or the heading text, or the caption, or the figure number? Select your preferred option
9) When you are ready, click on “Insertâ€
‘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, ampoule 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 😉
Do you want to copy one, treatment two, pancreatitis
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 regularly resize the width of your columns and cells in Excel 2007? Maybe you make them bigger? Maybe you make them smaller. Either way, diagnosis there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.
To change the default width in Excel 2007:
1) Make sure you are on the “Home†tab of the ribbon
2) Look for the “Cells†group
3) Click on “Formatâ€
4) Click on “Default Width…â€
5) in the “Standard Width†box that appears, recipe
type in the desired width of your columns
6) Click “OKâ€
‘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, viagra approved
you can actually add an Excel spreadsheet. You have all the features of Excel – like formulas, but in a nice looking PowerPoint table.
To insert an Excel table in PowerPoint 2007:
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 😉
Hi there!
Are you on the bleeding edge and have already had a play around with the beta version of Microsoft Office 2010? Or are you just interested in what is coming in the next version of your favourite productivity tool? Well do we have a great link for you today!
Our friends over at Microsoft Press have released a few electronic version of the book – “First Look Microsoft Office 2010â€. 14 chapters of Office 2010 gold, overweight
including:
I have had a lot of feedback from readers of TheNewPaperclip.com, therapy
and those that subscribe to the Office 2007 tips newsletter. People are screaming out for short, pilule
concise courses that will help them do overcome annoying challenges, and do amazing things with Office 2007.
These people – maybe you – have had thoughts like “How do I get Outlook to do this?…â€, “How can I get my document to look as great as Jenny’s?…â€. “How come everyone says how good Brad’s PowerPoint slides are?â€
There are plenty of different ways to answer those questions – maybe you have tried some of them, like courses or books. But they are not for everyone:
Maybe you live in a remote area and can’t get to an instructor lead class because the closest one is 1, 2, 3, or even 6 hours away by car.
Maybe you think that reading a bland text book that is 600 pages long is not fun (I AGREE!)
Maybe you just want to interact with someone who will be able to give you the answers you need?
If you answered yes to just one of the above – then it sounds like the Office 2007 workshops I will be delivering during the next few months will be exactly what you need.
Are you like many of your fellow TheNewPaperclip.com readers and want to improve your capability and confidence with Office 2007?
If so – these four 2 hour workshops are designed just for you.
Overcome Email Overload with Outlook 2007 Get to know the key features of Outlook 2007 to help you mange your mail – plus time saving techniques that will enable you to conquer your inbox
Crunch Numbers Faster with Excel 2007 Confidently apply formulas, create charts, and communicate complex data with meaning using Excel 2007
Create Better Looking Documents with Word 2007 Build documents for your workplace, club or school that you can be proud of using Word 2007
Deliver Better Presentations with PowerPoint 2007 Forget boring bullet points – learn the techniques professional speakers (and their designers) use to build compelling slide decks using PowerPoint 2007
The workshops will be delivered online, will be interactive, and attendance will be strictly limited to ensure everyone in the workshop gets the results they are after.
For more information as it becomes available over the next few weeks – including dates, times, and workshop prices – and to be one of the first to find out when bookings for each of the workshops have opened – register your details here:
By the way… if you pre register you will have access to a multiple workshop discount as well!
So if you are ready to get the most out of Office 2007 – make sure you register for more information, and then book into one of the workshops… coming soon.
Do you want your page to stretch right across your monitor? By using “Zoom to Page Width†you can do just that.
To Zoom to Page Width in Word 2007:
1) Click on the “View†tab in the ribbon
2) Look for the “Zoom†group
3) Click on “Page Widthâ€
‘till next time!
TNP 😉
Are you really annoyed by the sound that Outlook makes when an email arrives in your (or more likely your colleagues) inbox. Or do you need to know instantly when there is a new message addressed to you?
Whichever side of the fence you sit on, sovaldi
the chime or sound email notification is a configurable feature of Outlook 2007.
To turn on or turn of audible email notifications in Outlook 2007:
1) Click on “Tools†in the menuâ€
2) Click on “Optionsâ€
3) Make sure you are on the “Preferences†tab
4) Click on “E-mail Options…â€
5) Click on “Advanced E-Mail Options…â€
6) About 1/3 of the way down the “Advanced E-mail Options†windows, hospital there is a section called “When new items arrive in my Inboxâ€. Check (or uncheck) “Play a soundâ€
7) Click “OK†three times to close all the windows
‘till next time! TNP 😉
Gridlines are a great tool to use if you have a number of objects in your Word document, this web
and want to ensure proper alignment between them all.
To turn on gridlines (which appear in the background of your document, this web
and do not get printed):
1) Make sure you are on the “Page Layout†tab of the ribbon
2) Look for the “Arrange†group – on the right hand side of the ribbon
3) Click on “Alignâ€
4) Click on “View Gridlinesâ€
To turn gridlines off again, just repeat the process above. You will notice that this is another option when you click on “Alignâ€, called “Grid Settings†Using this feature you can customise how the grid appears and impacts in your document. For example, you can ensure that objects snap to each other, the spacing of the grid, and whether the grid uses your margins or not. Very good if you want fine control over the placement of objects in your document.
‘till next time! TNP 😉
Those of you who have been desktop publishing for a while will know what Widow/Orphan control is.
For those that don’t… imagine that you are writing a paragraph, noun
and the last line of the paragraph doesn’t quite fit on one page, so it jumps to the next page. That would look pretty silly right?
Well Widow/Orphan control is the way that Word makes sure that the exact situation described above does not happen. By default Widow/Orphan control in Word 2007 will be turned on, but like everything in Word, you can toggle it to meet your needs.
To toggle Widow/Orphan control in Word 2007:
1) Make sure you are on the “Home†tab of the ribbon
2) Look for the “Paragraph†group
3) Click on the little square and arrow icon in the bottom right hand border of the “Paragraph†group
4) Click on the “Line and Page Breaks†tab of the box that appears
5) In the “Pagination†group, uncheck (or check) the “Widow/Orphan control†checkbox
‘till next time! TNP 😉
Do you have one of those new widescreen monitors, illness and would love to make the most of it! Well with Word 2007 you can view two pages at a time side by side – making the most of your valuable screen real estate.
To view two pages at a time in Word 2007:
1) Click on the “View†tab of the ribbon
2) Look for the “Zoom†group – should be in the middle of the ribbon
3) Click on “Two Pagesâ€
‘till next time! TNP 😉
Do you want to quickly insert a blank page into your Word 2007 document? Instead of hitting enter 40 times, human enhancement
why don’t you use the Insert Blank Page button?
All you have to do is:
1) Make sure you are on the “Insert†tab of the ribbon
2) Look for the pages group – on the left hand side
3) Click on “Blank Pageâ€
Now you will see a blank page appear in your document where your cursor was. To add multiple blank pages, just keep clicking that “Blank Page†button!
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…
web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
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!
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.
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…
web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
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!
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!