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

So if you are a bit of an Office freak like me, 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.

‘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

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

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