Level 100 - Beginner

Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, 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

Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, or biggest to smallest?

To sort from high to low 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 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 want to quickly insert a blank page into your Word 2007 document?  Instead of hitting enter 40 times, 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

With 2009 almost behind us, 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

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, 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!

1) Christmas Clipart!

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

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP

So if you have been reading The New Paperclip for a while, 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, and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

I hope you enjoy!

’till next time!
TNP

Do you want to win a copy of “2007 Microsoft Office System Inside Out” by John Pierce – valued at $USD 49.99?  If so… read on…

This month is a great one here at The New Paperclip, for a number of reasons:

1. The first month where I have had over 50 000 unique visitors, who just like you are trying to solve their Office 2007 (and now Office 2010) challenges;
2. I delivered a session at OfficeDevCon09 where there wasn’t a single spare seat in the room; and just today…
3. I have launched a Facebook Fan page, so you can keep up to date with all the tips, tricks and tutorials from TheNewPaperclip.com!
   
   The New Paperclip on Facebook

So to celebrate all these good things, I am giving away a great resource – almost 1300 pages of everything you would ever want to know about Microsoft Office 2007.

So what do you need to do to be in the draw to win?

Before 15 December 2009 – simply do the following:

• Become a Fan of The New Paperclip on Facebook, and
• Post on the wall of the fan page the one thing you would love to know how to do, or problem you would love to solve in Office 2007.

I will pick a winner at random from all the wall posts, and let you all know here, and on the Facebook Fan page who the winner is.

That is all there is to it – just become a fan of The New Paperclip today, and let me know what Office 2007 problems you would like me to help you with – and you could win!  GOOD LUCK!

‘till next time!
TNP

PS… whilst we are at it, if you are on twitter and not following @thenewpaperclip… why not?

So you might be unlucky enough to be looking for a new job, or maybe you are just sick of your current job and need a change!  Whatever your situation, there is one sure thing that you will need to think about – your resume/cv!

Creating your resume or curriculum vitae in Word 2007 is not as hard as you think.  There are literally dozens of very good looking templates you can use which take all the hard work out of creating your latest and greatest resume.

So how do you access the Resume Templates in Word 2007?

1. Click on the office Orb in the top left hand corner
2. Click on "New"
3. In the "New Document" window that appears, look to the left and you will see a big long list of templates to choose from.  Scroll down and click "Resumes and CVs"
4. Click on the type of resume you are after – Basic, Job Specific, or Situation Specific
5. Select the one you want to use, and then click "Download"

And then start customising your resume with your own information! 

Note, for this to work you will need to be connected to the internet as the templates are actually stored on Microsoft Office Online.

‘till next time!
TNP

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.