Rugby Fan? Use Excel to track the Rugby World Cup

If you are like me and follow Rugby Union (Go the ALL BLACKS!!!), clinic you will love something that the team at the Excel Blog posted the other day.

It is a spread sheet that you can use to track your team’s progress during the world cup.

Read more about the Rugby World Cup score tracker and get your hands on the free Excel spread sheet on the Excel Blog

Reset a User’s Password in Office 365

So you are a small business with a handful of users that use Office 365 for email, click collaboration and alike.  What if one of those user’s forgets their password?

Now – if you are a user who has forgotten their password – the best thing to do will be to talk to your IT team, medical or the person in charge of all your Office 365 accounts.  If they don’t know how to reset your password, discount simply tell them to read the rest of this article.

If you don’t have a fancy set up like some larger organisations with things like DirSync, and ADFS (Active Directory Federation Services), you will probably just want to reset the password for their Microsoft Online Services account.

To do that, if you are the administrator of your Office 365 “tenant” all you need to do is:

1) Sign into the Office 365 Portal (

2) On the Admin page, you will see a number of “Admin Shortcuts” at the top of the page.  Click on “Reset User passwords”


3) Select the user from the list that you want to reset the password for – make sure you check the box beside their name

4) At the top of the list of users, now select “Reset Password”

5) Select whether or not you want to email the user their new password

6) Click “Reset Password”

Simple as that!  Now if you are the administrator of your Office 365 tenant and have forgotten your Administrator Password… stop panicking!  Take a look at this article from the Office 365 Technical Blog which will help you reset your Office 365 administrator password.

‘till next time!

Office 365 is almost here

Ok… so being The New Paperclip you know I love everything Office. Well my old friends at Microsoft are just about to launch something new. It is a little different to the Office that you are used to though. But don’t worry, it is a good thing!!

They call it Office 365.

So what is Office 365? Well if you run a small business, or are a manager at a larger one, you might be interested. Office 365 gives your business:

  • Email & Calendar functionality so you can manage your day
  • Office Web Apps, so you can view and edit your documents, spread sheets and presentations from any computer with an internet browser
  • A website for your business
  • The ability to instant message, video conference and set up professional online meetings

All of that out of something Microsoft calls “The Cloud” – that is just a fancy way of saying you don’t need to run your own servers if you don’t want to – Microsoft will do it for you.

The other exciting part is that instead of paying hundreds or thousands of dollars up front for the above, you get to pay per user per month. Depending on which Office 365 version you sign up for… you can also get a subscription based version Office 2010 on your desktop as well, without having to pay up front!

If any of the above sounds like it would help your business, you should check out Office 365 at

In the mean time, here at we are broadening our content – we are now publishing tips and tricks and other articles that will give you all the Office 365 Help you need. You will see more and more of that content appear over the next few weeks and months.

’till next time!

Create your 2011 Calendar in Word 2007

Hi – looking to see how to create a 2011 calendar in Word 2010 – click here.

With 2010 behind us in most parts of the world, stuff now is the time to start creating your own 2011 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 “2011 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.

It couldn’t be any simpler than that.  Wishing you and your family a wonderful year ahead!

‘till next time!


Create your 2011 Calendar in Word 2010

Well it is New Years Day in most of the world – Welcome to 2011!!!

So with that in mind lets figure out how to create a 2011 Calendar using Word 2010.  Creating a personalised calendar – whether a simple month view or something a bit more complicated which you can record appointments, mind see the lunar phases, ask or public holidays – is an absolute breeze.

Here is how to create a 2011 Calendar in Word 2010:

  1. Go to the File menu, pills and click New
  2. Look at the Templates section.  If you are connected to the internet you will see a folder called “Calendars”.  Click on it!
  3. Click on “2011 Calendars”
  4. Select your preferred style from the library of calendar templates.


Simple as that – now you can go ahead and personalize the calendar to suit your needs, save it, print it out, and be more organised in 2011!

‘till next time!


Guide to Group Policy in Office 2010

A quick post for all you guys out there that have to manage Office 2010 deployments in a business.  Microsoft have made available a great resource that outlines all the different Group Policy settings for Office 2010 – a must have resource if you want to manage your Office 2010 deployment well.

Check it out at

‘till next time!

Building an add-in for Microsoft Office

Soon I will be publishing a series of articles on The New Paperclip which dive a bit deeper into extending the functionality of Microsoft Office.  Probably a scary thought for most of you, cialis but I have found that if we want to extract that extra 10-50% more out of Office there comes a time where you need to start coding.

In particular I am going to focus on building high value add-ins for Microsoft Office.

Now when it comes to writing an add-in, illness there are a couple of ways to go about it.

1) Roll your own

If you are confident C#  or VB coder there is nothing stopping you from cracking open Visual Studio, discount downloading Visual Studio Tools for Office and giving it your best shot.  I must admit I tried this at first, and had some success.

But that success was time consuming, and when I wanted to build an add-in that was backwards compatible with Outlook 2007 (which has that horrible combination of ribbon and command bar), Office 2003/XP and beyond it became VERY time consuming.

So I decided to use an alternative.

2) Use Add-in-Express

Before I share my experience with Add-in-Express… here is what the brochure says!

Add-in Express for Office and .NET is the only all-in-one platform that includes all the features you may expect for your Microsoft Office extensions such as Office COM add-ins, smart tags, Excel XLLs, RTD servers and Automation add-ins (UDFs). It fully supports Microsoft Visual Studio 2010, 2008 and 2005 and makes it very comfortable for developing application-level extensions for all available Office versions from 2000 to 2010.”

What that means for people new to Office Development is that Add-in-Express makes it easy to quickly extend the functionality of Microsoft Office, irrespective of what version you are running.  And after spending about a month using the tool to build some add-ins myself, I have to agree.  For someone who is exploring Office Development for the first time, taking the painful parts of COM out of the picture meant that I could focus on the features and functionality I wanted to build, and not spend hours pulling my hair out!

For example, being able to access all the key events in Office without having to write event handlers accelerated development time.  Sure, it may only seem like a small thing, but as any developer knows, anything that saves you time, and takes the pain of troubleshooting away is a good thing!

Anyways – if you are interested in developing your own Office Add-in, make sure you subscribe and check back in the next few weeks for more content about my development experiences – and some examples that will get your Office Development journey started.

‘till next time!
TNP Winking smile

Clear formatting in Word 2007

Have you ever change the font size or the font type or the font colour one too many times and realised that it would be far easier just to start again?

Well instead of deleting your text and having to retype it, no rx you can use a feature of Word 2007 called “Clear Formatting”.

As the name suggests, order “Clear Formatting” will remove all the formatting you have applied to your text, and set it back to the default paragraph style.

You can find the “Clear Formatting” button on the “Home” tab of the ribbon, in the “Font” group.  Just select the text you want to clear up, and then click on the button.

‘till next time!

Create PowerPoint slides designed specifically for A4 or Letter printing

Usually PowerPoint presentations are built to be delivered on-screen.  Using the print options you can create handouts and notes pages that you can then print out and hand to your audience. 

But did you know that you can use PowerPoint to design presentations built specifically to be delivered in the print format.  One slide per A4 or Letter page (and not a cropped or zoomed version of an onscreen slide)

To do so, story all you need to do is change the page size of the PowerPoint slides in your deck.

1) Click on the “Design” tab

2) Click on “Page Setup” in the “Page Setup” group on the left hand side of the ribbon

3) In the “Page Setup” window, remedy in the drop down box “Slides sized for:” select your preferred paper size

This is a great way to design slides specifically for transparencies or over-head projectors as well.

‘till next time!