Level 100 - Beginner

Hi there,

Just thought I would share with you some fantastic news I received the other day.  Paul Woods – the guy who created / is The New Paperclip was recognised by Microsoft for technical leadership with a Most Valuable Professional award.

Specifically it was an award in the Business Productivity / Word category

So what is a Microsoft Most Valuable Professional Award?

From the MVP website:

“Microsoft is pleased to recognize and award its Most Valuable Professionals (MVPs). We present the MVP Award to thank individuals for their exceptional contributions to technical communities worldwide. When a community participant sees an MVP in a technical community, whether in a newsgroup, as a user group host, a conference speaker, or a respondent in forums, that community participant can be confident that the information shared by the MVP will be of the highest caliber and will help every user make the most of the technology.”

Pretty neat huh! 

So what does it mean for The New Paperclip?  More great tips and tricks for Office 2007, and soon Office 2010!

‘till next time!
TNP

Ever wondered what the real person behind TheNewPaperclip looks like?

Check out this video of Paul Woods (the guy behind The New Paperclip) talking about Windows 7.

I thought I would spend some time today checking out some of the other Office 2007 help/tutorial sites out there.  There are quit a few good ones, and in the interest of helping you get the most out of your Word 2007 experience, I thought I will publish a list of my favorite ones!

Now of course, you will find the best Word 2007 tutorials (if I do say so myself) here at TheNewPaperclip.com… but if you want a bit of variety… check out a few of these guys!

Microsoft Office Online – Word 2007 Courses (Microsoft.com)

There are 27 courses here, each ranging from 20-50 minutes on a wide range of Word 2007 topics.  And this is straight from the horses mouth at Microsoft!

Microsoft Word 2007 Tutorial – Free & Online (BayconGroup.com)

Full of practical exercises, this beginners tutorial is broken into five lessons so you can learn at your own pace!

Microsoft Word 2007 In Pictures (InPics.net)

This is a great visual tutorial that explains exactly how to get up to speed with the basics in Word 2007 – highly recommended!

Microsoft Word 2007 Tutorials (Word07.com)

Fairly comprehensive list of topics covering most of what you would want to know about Word 2007.

So there you have it – a quick selection of some of the best Word 2007 tutorials out there. 

And remember, if you want Word 2007 tips delivered to your inbox regularly, make sure you subscribe to the Office 2007 newsletter!

‘till next time!
TNP

Are you a hardcore spreadsheet king?  The number cruncher?  On the Accounting A-team?

Then chances are… your spelling is… well… not very good at all!

Luckily Excel has a spell checking feature that will stop people from noticing your spelling mistakes!

1) Click on the “Review” tab in the Ribbon

2) Click on “Spelling”

or alternatively just use the “F7” keyboard shortcut!

‘till next time!
TNP

Have you spent hours working on the perfect project plan, with literally hundreds, if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

‘till next time!
TNP

Do you need to find a phone number of one of your colleagues?  Well if you have Office Communicator 2007 you can quickly look up their digits.

1) Find the person in your contact list, or using the Search feature

2) Look for the phone beside their name

3) Hover your mouse over the phone, and click on the little arrow that appears

4) You will find the phone number on the fly-out menu

‘till next time!
TNP

Have you been working on a spreadsheet, but then suddenly realised that you need to add another column?

Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.

The long way

1) Select the cell that is to the right of where you want the new column to appear

2) Look at the ribbon, and make sure you are on the “Home” tab

3) Look to the right, and you will see the “Cells” group

4) Click on “Insert”, and then select “Insert Sheet Columns”

The short way

1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear

2) Click “Insert” from the menu that appears

If you want to add two or more columns, you can use one of the methods above, and simply use the “Redo” command to keep inserting new columns – either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y

‘till next time!
TNP

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

• Erika Ehrli (Adventures in Office Development and .Net):
  Links for February 6th 2009: Workflow Development Resources Interactive Map, Join Us on Facebook, + Lots of New Articles and Downloads 
• The Office for Mac Team Blog:
  the MacBU Giving Campaign
• Inside Office Online:
  Raining pennies (and other cool effects)
• The Microsoft Office Word Team’s Blog:
  Advanced Comparison of Word Documents

‘till next time!
TNP

Are you new, or have just upgraded to Word 2007?  Since starting The New Paperclip over two years ago, there have been a few questions that come up again and again that people ask – some of which I have listed below.

1. How do I change my page orientation in Word 2007 from Portrait to Landscape or vice versa?
2. How do I change my line spacing in Word 2007?
3. How do I undo in Word 2007?
4. How do I do an email merge in Word 2007?
5. How do I add page numbers in Word 2007?
6. How do I print in Word 2007?
7. Where did the file menu go in Word 2007?
8. How can I change my page layout in Word 2007?
9. How do I superscript text in Word 2007?
10. How do I email a document using Word 2007?

Remember that you can have more Word 2007 help, tips, tricks and tutorials delivered to your inbox simply by subscribing to the Office 2007 newsletter.

Finally… if you have any more Word 2007 questions, check out The Ultimate Guide to Word 2007

‘till next time!
TNP

They have been closed for a while now, but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

• Word 2007 Forum
• Outlook 2007 Forum
• Excel 2007 Forum
• PowerPoint 2007 Forum
• Access 2007 Forum
• Groove 2007 Forum
• InfoPath 2007 Forum
• OneNote 2007 Forum
• Project 2007 Forum
• Publisher 2007 Forum
• SharePoint Designer 2007 Forum
• Visio 2007 Forum

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP