Level 300 – Advanced

Has this ever happened to you?  You start working on your masterpiece in Word 2007, and then you send the document out to a number of people for their feedback.

They all add their two cents (some add twenty!) and then email the document back to you.

But now you are stuck in a dilemma… how do you quickly merge all those changes together into one document, without having to read each line and try to understand what they changed.

Well there is a great feature in Word 2007 called “Combine”.  You can use it to simply combine to documents, and see all the differences between the two documents.  You can track what has been inserted, what has been deleted, what has been moved, any formatting changes, and see any comments they made.

But that isn’t the best part.  It also creates a new combined document without losing the original and revised document.

So how do you do it?

1) Make sure you are on the “Review” tab in the Ribbon

2) Look for the “Compare” group

3) Click on the little arrow below the “Compare” button

4) Click “Combine”

5) Select your “Original Document” and your “Revised Document”

6) Click OK

7) Check out your brand new combined Word 2007 document!

How easy is that!

‘till next time!
TNP

For all those Visio lovers out there, then you should already know about the Microsoft Visio Toolbox.  If not, you seriously can’t call yourself a Visio lover!

The Visio Toolbox is a collection of articles, case studies, and most importantly add-ins for Visio 2007.

So if you are looking for justification for your boss to upgrade to Visio 2007, articles on interesting topics such as “Silverlight and Visio”, or add-ins such as the Rack Server Virtualization Add-In, the Disk Space Monitoring Add-in, or the Microsoft Exchange Server 2007 Visio Add-in… then you need to check out the Microsoft Visio Toolbox!

‘till next time!
TNP

Are you a traditionalist who hates Graphical Interfaces.  Do you love WordPerfect classic mode, or run Vim at home, but have to use Word 2007 in the office?

Or do you just want to focus on writing, and none of that formatting stuff that an editor can deal with for you?

Well you might be surprised to know that you can very quickly set up Word 2007 to get rid of the Ribbon, get rid of the status bar, and change the colours to a classic monochrome green with a black background!

Bet you didn’t know that!

Well our friends over at the Microsoft Office Word Team Blog have described exactly how to set up Word 2007 in a quasi-classic mode!  You can read more about it in their post called Word Throwback “Just Write” Edition… which was coincidentally inspired by one of my favourite authors and bloggers, Tim Ferriss.

How cool is that!  Takes me back to 1989!

‘till next time!
TNP

Don’t you hate how you put lots of effort into a Word 2007 document, and then you see one of your colleagues play around with the formatting, or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

‘till next time!
TNP

Are you writing a report, an assignment, or just a plain old document and need to hyphenate you paragraphs?

By default, Word 2007 has hyphenation turned off, but it is really easy to turn it on, and there are a number of options to control how the hyphenation works.

To turn on hyphenation in Word 2007 to hyphenate your document, simply:

1) Go to the “Page Layout” tab on the Ribbon

2) Look for the “Page Setup” group

3) Click on “Hyphenation”

4) Select “Automatic”

Now that your document is hyphenated, lets look at the settings you can change to control exactly how the hyphenation works!

5) Click on “Hyphenation” again

6) Click on “Hyphenation Options…”

In the box that appears, there are two key settings you can play with.  The first is the “Hyphenation zone”, and the second is “Limit consecutive hyphens to”.  Change these settings to adjust the hyphenation to meet your needs!

‘till next time!
TNP

So are you comfortable with the basics of Office 2007, and want to go a little deeper?  Maybe you want to build your knowledge around one particular product?  Maybe you just want something interesting to read!

If you are into Office 2007, you might not know it, but The New Paperclip is not your only option (if you thought it was, I am very flattered though!).  There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.

Here are a few places you should look…

Number 1: Alltop’s Top Microsoft Office News – [http://microsoft-office.alltop.com/]

This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office.  This one page displays all the news from 30 or so of the web’s leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the ‘blogosphere’ is thinking about when it comes to Office.

You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article – it gets updated every hour!

Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]

This blog is run by the folks who run Microsoft’s own Office help site – Office Online.  Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.

Number 3: The blogs of all the Office teams at Microsoft

There is nothing better than getting it from the horse’s mouth right!  These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007

• The PowerPoint Team Blog
• The Word Team Blog
• The Outlook Team Blog
• The Excel Team Blog
• The Project Team Blog
• The Groove Team Blog
• The Access Team Blog
• The InfoPath Team Blog
• The OneNote Team Blog (well one of the team anyways!)
• The Visio Team Blog

There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start… well, of course after you have read all the articles on The New Paperclip!

‘till next time!
TNP

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP

WARNING:  THIS TIP POTENTIALLY COULD SAVE YOU HOURS!  Seriously, this has to be one of the biggest time saving features in any Microsoft product in the companies entire history. 

Have you ever wanted to display photos in a presentation with a bit of text?  Maybe it is a presentation of all your photos from the work team building event, your child’s 21st, or you just have dozens, hundreds, or heaven forbid… thousands of photos you want to display in a PowerPoint presentation.

There are two ways you could go about creating your presentation.  The INCREDIBLY LONG WAY, or the quick way!

The incredibly long way

1) Open up PowerPoint 2007

2) Pick your slide design and theme

3) Insert every photo individually

4) Resize them individually

5) Caption them individually

6) Add picture effects to them individually

… that is a lot of work for anything more than 10 photos… in fact it is hard work for less than 10 photos!

The quick and very preferred way!

1) Open up PowerPoint 2007

2) On the Ribbon, click on the “Insert” tab, look for the “Illustrations” group, and then click on “Photo Album”.  You want to select “New Photo Album”

3) In the box that appears, click on the “File/Disk…” button and simply browse for all the photos you want to add to your presentation

4) Select all the options you want.  If you want to put captions below all your photos, make sure you check that box.  Pay special attention to the layout you wan to use as well.  You can have one picture per slide at full screen (very nice, no need to resize!), or you can have multiple images per slide.  If you are going for multiple images, make sure you select a frame shape to go around your images, as it will make your presentation look far more professional.  If you can’t decide on a shape, use the “Simple Frame, White” one – you will not be disappointed

5) Make sure you select a theme for your presentation

6) When you are ready, click “Create”

So… on paper it looks like the same number of steps right?  WRONG.  Instead of doing the same 6 task to each and every one of the photos you want to include, by using a PowerPoint 2007 Photo Album you let PowerPoint do all the hard work for you, across each and EVERY photo you want to include, automatically!

Potential Time Saving!

Seriously, say you have 150 photos from an event you want to put in a presentation to play over dinner – if you do it the long way, it could take you 2 – 3 hours depending how quick you are with the mouse.  Using a PowerPoint 2007 photo album that could take just 30 seconds! 

How good is that!  I thought you would like it!

’till next time!
TNP

So you are about to do a presentation – maybe it is at an event or a tradeshow – and instead of using a projector, your are presenting your slides using a plasma or LCD tv.

When you practice your presentation on your computer or on a projector, your slides look fine.  But as soon as you try your deck on the plasma or LCD, your slides stretch and look horrible!

How do you get your slides to look perfect on the plasma?

Did you know that you can change the size, shape, and orientation of your slides in PowerPoint 2007!

You can set up your presentation for different “On Screen” sizes, such as 4:3 (which is the default), or 16:9 and 16:10 aspect ratios, which are perfect for widescreen plasma panels!

(just as an aside, you can also select different paper sizes as well if you want to build your slides specifically for printing as opposed to being used on screen – but we can talk about that another day!)

To change your slides from standard to widescreen

1. In PowerPoint 2007, click on the “Design” tab on the Ribbon
2. Look for the “Page Setup” group
3. Click on “Page Setup”
4. Look for the “Slides sized for:” drop down box, and select either “On-screen Show (16:9)” or “On-screen Show (16:10)
5. Click “OK”

Now you will have noticed the shape of your slides has changed from being close to a square, to more like a rectangle – and you will find that your graphics and text will no longer distort when you show your presentations on those fancy plasma screens!

Now get out there and impress those customers!

’till next time!
TNP