Archive for March, 2010

Do you want to copy one, two, 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

If you are looking to spread some Easter cheer with your family, friends, or colleagues this Easter, why not use one of these great Easter templates for Word 2007 and OneNote 2007 Office Online!

• Flyer for an Easter Egg Hunt
• Easter Party Invitation
• Easter Stationery
• … and an Easter Egg OneNote Template!

I hope you and your family have a great Easter!

‘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, 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 might already know about a great feature in Excel 2007 called “Merge and Center”.  Basically it allows you to create a cell that spans across multiple columns – great for headings for example.

But sometimes you want to merge the cells – but not centre the text.  That is where “Merge Across” comes in handy.  “Merge Across” does exactly the same as “Merge and Center”, except it keeps the text left justified! 

How good is that!  No more having to change the paragraph alignment!!!

To merge across a number of cells in Excel 2007:

1) Select the cells you want to merge

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

3) Look for the “Alignment” group

4) Click on the small arrow beside “Merge & Center”

5) Click on “Merge Across”

To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.

‘till next time!
TNP

I have had a lot of feedback from readers of TheNewPaperclip.com, and those that subscribe to the Office 2007 tips newsletter.  People are screaming out for short, 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

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, including:

• Welcome to Office 2010
• Express Yourself Effectively and Efficiently
• Collaborate in the Office and Around the World
• Create and Share Compelling Documents with Word 2010
• Create Smart Data Insights with Excel 2010
• Manage Rich Communications with Outlook 2010
• Produce Dynamic Presentations with PowerPoint 2010
• Organize, Store, and Share Ideas with OneNote 2010
• Collaborate Effectively with SharePoint Workspace 2010
• Create Effective Marketing Materials with Publisher 2010
• Make Sense of Your Data with Access 2010
• Putting It All Together
• Security in Office 2010
• Training Made Easy

You can read the Microsoft Press blog post – or just click here and download the book directly.  It is about 10.5mb or so.

‘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, 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, 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, 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

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, 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 have one of those new widescreen monitors, 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

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, and want to review all the reminders you currently have, 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