Get productive with Office 2007 in 2009

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 😉

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 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

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 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘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, treat 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 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘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, treat 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.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

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 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘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, treat 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.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

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 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘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, treat 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.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

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 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘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, treat 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.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

Is there a feature of Office that you KNOW exists… but can’t for the life of you find it?

Maybe it was an old feature you remember from Word 2003, or Excel, or PowerPoint.  They didn’t cover it in the course that work sent you to, you can’t find it in the help file, and Google hasn’t returned any results!

Panic?  Not quite yet!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

Get Office 2007 Help, Tips, Tricks, and Tutorials on Twitter!

Did you know that you can get a regular email jam packed with Office 2007 tips direct from TheNewPaperclip.com!

All you need to do is register using this form

Be more productive with Office 2007!  Subscribe to the regular Office 2007 Tips and Tricks newsletter.  Brought to you by TheNewPaperclip.com

Name:
Email:

Register today and you will receive a free copy of my e-book “Your 10 minute guide to getting up to speed with Microsoft Office 2007”

’till next time!
TNP 😉

Keeping up to date with the latest Office 2007 Help, medicine Tips, Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Keeping up to date with the latest Office 2007 Help, obesity Tips, visit web Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, information pills tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Keeping up to date with the latest Office 2007 Help, obesity Tips, visit web Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, information pills tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Are you a member of the Twitterverse?  If you use the micro-blogging service called Twitter, ask
you can how get your favorite productivity articles on Word, gerontologist
Outlook, Excel, PowerPoint… in fact the entire Microsoft Office 2007 suite directly in your Twitter feed.

All you have to do is follow @TheNewPaperclip.

I will be on there regularly so if you have any questions or suggestions for articles you can post them to Twitter as well!

‘till next time!
TNP 😉

Subscribe to the Office 2007 Help, Tips, Tricks and Tutorials Newsletter

Did you know that you can get a regular email jam packed with Office 2007 tips direct from TheNewPaperclip.com!

All you need to do is register using this form

Register today and you will receive a free copy of my e-book “Your 10 minute guide to getting up to speed with Microsoft Office 2007”

’till next time!
TNP 😉

Capture your New Years Resolutions with OneNote 2007 and Outlook 2007

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, ed purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, implant yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, visit web thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

Do you like to have a copy of your schedule with you all the time?  Would managing your time be simpler if you could have a printed copy of your Outlook calendar with you as you travel from meeting to meeting?

Printing out your calendar is a piece of cake in Outlook 2007!

  1. Click on “Calendar” so you are looking at your calendar, no rx
    and not your email!
  2. Select the view you want to print out – it could be a day, a week, a month, or a custom date range
  3. Click on the File menu, and select “Print”

Simple as that!  And remember if you are not sure of which calendar print out you want, that you can Print Preview to see exactly what you are going to get before doing the final print!

By the way, printing a blank calendar in Outlook 2007 on month view is a really nice, and inexpensive way to put a calendar up in your office cubicle, or on your fridge at home to keep track of family events!

‘till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

Do you like to have a copy of your schedule with you all the time?  Would managing your time be simpler if you could have a printed copy of your Outlook calendar with you as you travel from meeting to meeting?

Printing out your calendar is a piece of cake in Outlook 2007!

  1. Click on “Calendar” so you are looking at your calendar, no rx
    and not your email!
  2. Select the view you want to print out – it could be a day, a week, a month, or a custom date range
  3. Click on the File menu, and select “Print”

Simple as that!  And remember if you are not sure of which calendar print out you want, that you can Print Preview to see exactly what you are going to get before doing the final print!

By the way, printing a blank calendar in Outlook 2007 on month view is a really nice, and inexpensive way to put a calendar up in your office cubicle, or on your fridge at home to keep track of family events!

‘till next time!
TNP 😉

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, medical you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

In Outlook 2007 there are a number of views you can “view” your emails with:

  • Messages
  • Messages with Auto Preview
  • Messages from the Last Seven Days
  • Unread Messages in a particular folder
  • Messages sent to me
  • Messages in a timeline (very cool!)
  • and some more complicated views like Outlook Data Files, medicine
    and Documents

So how do you change the view of your inbox?

Simple. 

  1. Click on the folder you want to organise (ie your Inbox).
  2. Click on the tools menu
  3. Select “Organize”
  4. In the window that appears, Hemorrhoids
    click “Using Views”
  5. Select your favourite view

If you want to get really tricky you can create your own custom view by clicking the “Customize Current View” button in the top right hand corner of that box.  You can customise your view with different fields, group by’s, sorts. filters and other settings.

How cool is that!

‘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, population health your are presenting your slides using a plasma or LCD tv.

When you practice your presentation on your computer or on a projector, pilule 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 😉

Well… hasn’t 2008 gone quickly!

Now that Christmas is just past us, search now is the time to start thinking about your new years resolutions.

Most people usually say the same thing every year… I am going to exercise more… I am going to work less etc etc.  But most of the time by mid-February you are already way off track.

The key to a good new years resolution is to be specific, dosage and to write it down somewhere so you are reminded of it.  What better place to do that than in OneNote 2007!

Here is how to make a record of your resolutions… AND be reminded to actually work on them.

1) Write your resolutions in OneNote

2) Tag your resolutions with a specific tag from (you guessed it!) the “Tag” button.  If your resolution is to do a generic task, buy information pills tag it with a “To Do” tag.  If it is a little more specific – say, watch a movie… then tag it with the “Movie to See” tag.  There are dozens of tags you can choose from to give you a visual cue regarding your resolution.

Easy so far right?  Well, now with a little help from Outlook 2007, we can now be reminded throughout the year to work on our resolutions!

3) In OneNote 2007, you will see a “Task” button just to the left of the “Tag” button in the menu.  By selecting one of the “Task” options for your resolution, it can now appear as a task whenever you open Outlook.  So now whenever you are checking your email, your calendar, or your task list… you will have a gentle reminder to work on your new years resolutions, throughout the year.

 

So there you have it, you really have no excuses not to achieve your resolutions this year!

’till next time!
TNP 😉

Organise your Inbox with Views in Outlook 2007

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, ed purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, implant yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, visit web thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

Do you like to have a copy of your schedule with you all the time?  Would managing your time be simpler if you could have a printed copy of your Outlook calendar with you as you travel from meeting to meeting?

Printing out your calendar is a piece of cake in Outlook 2007!

  1. Click on “Calendar” so you are looking at your calendar, no rx
    and not your email!
  2. Select the view you want to print out – it could be a day, a week, a month, or a custom date range
  3. Click on the File menu, and select “Print”

Simple as that!  And remember if you are not sure of which calendar print out you want, that you can Print Preview to see exactly what you are going to get before doing the final print!

By the way, printing a blank calendar in Outlook 2007 on month view is a really nice, and inexpensive way to put a calendar up in your office cubicle, or on your fridge at home to keep track of family events!

‘till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

Do you like to have a copy of your schedule with you all the time?  Would managing your time be simpler if you could have a printed copy of your Outlook calendar with you as you travel from meeting to meeting?

Printing out your calendar is a piece of cake in Outlook 2007!

  1. Click on “Calendar” so you are looking at your calendar, no rx
    and not your email!
  2. Select the view you want to print out – it could be a day, a week, a month, or a custom date range
  3. Click on the File menu, and select “Print”

Simple as that!  And remember if you are not sure of which calendar print out you want, that you can Print Preview to see exactly what you are going to get before doing the final print!

By the way, printing a blank calendar in Outlook 2007 on month view is a really nice, and inexpensive way to put a calendar up in your office cubicle, or on your fridge at home to keep track of family events!

‘till next time!
TNP 😉

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, medical you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

In Outlook 2007 there are a number of views you can “view” your emails with:

  • Messages
  • Messages with Auto Preview
  • Messages from the Last Seven Days
  • Unread Messages in a particular folder
  • Messages sent to me
  • Messages in a timeline (very cool!)
  • and some more complicated views like Outlook Data Files, medicine
    and Documents

So how do you change the view of your inbox?

Simple. 

  1. Click on the folder you want to organise (ie your Inbox).
  2. Click on the tools menu
  3. Select “Organize”
  4. In the window that appears, Hemorrhoids
    click “Using Views”
  5. Select your favourite view

If you want to get really tricky you can create your own custom view by clicking the “Customize Current View” button in the top right hand corner of that box.  You can customise your view with different fields, group by’s, sorts. filters and other settings.

How cool is that!

‘till next time!
TNP 😉

Office DevCon 2008 – Sydney, Australia

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am).

I would like to discuss this a little to hopefully help everyone out. Whilst on the surface it might look annoying (especially for those how have just moved to Outlook 2007)… there is actually a good reason why the default reminder is 4pm.

First lets talk about Outlook 2003

In Outlook 2003, medications a follow up flag is a follow up flag. You set a time and a date for the reminder and that is that.

In Outlook 2007 however, price there are different types of follow up flags. There is a “Today” follow up flag, urticaria a “Tomorrow” follow up flag, a “This Week”, a “Next Week” and a “Custom”. Obviously, if you use a “Today” follow up flag (which is the default), it will remind you today. If you set a “Tomorrow” follow up flag, it will remind you tomorrow.

The “Today” flag is designed to remind you about things that you need to finish before you go home from work today… hence why it the default is for it to remind you 1 hour before the end of your work day (which would be 4pm in most cases).

As the “Tomorrow” flag is designed to remind you about things to do tomorrow, it will remind you by default at the start of the next work day (8am in most cases).

So say you want to have your default reminder first thing tomorrow morning? Then it is easy to change the default flag that is set. Simply right click on where you currently set your flag, and then in the pop up menu click on “Set Quick Click”. Change the default to “Tomorrow” and your default reminders will now be 8am on the next business day.

Hope that helps clear up some of the confusion around follow up flags. I can understand why it would be confusion coming from Outlook 2003, however with the new flexibility to set different types of flags, Outlook 2007 gives you a lot more control over when you get your reminders.

’till next time!
TNP 😉

PS. If you want to learn more about the default times, you can look at this Office Online help page – http://office.microsoft.com/en-us/outlook/HA012317831033.aspx

Are you an Office freak from down-under?

On the weekend of the 15th and 16th of November, try a group of Aussie Office fanatics are putting together a conference called Office DevCon2008.  From what is on the agenda it looks like a great event for anyone involved in managing Office products in their workplace, seek or for those interested in getting a little more intimate with the Office 2007 suite, patient SharePoint and more.

Registration is free… and there might be sneak previews of Office 14 as well!

If you are in Sydney in mid November, make sure you check it out.  You never know, you might bump into yours truly there as well 🙂

You can find out more by visiting the Office DevCon 2008 website

’till next time!
TNP 😉

Follow Up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am).

I would like to discuss this a little to hopefully help everyone out. Whilst on the surface it might look annoying (especially for those how have just moved to Outlook 2007)… there is actually a good reason why the default reminder is 4pm.

First lets talk about Outlook 2003

In Outlook 2003, medications a follow up flag is a follow up flag. You set a time and a date for the reminder and that is that.

In Outlook 2007 however, price there are different types of follow up flags. There is a “Today” follow up flag, urticaria a “Tomorrow” follow up flag, a “This Week”, a “Next Week” and a “Custom”. Obviously, if you use a “Today” follow up flag (which is the default), it will remind you today. If you set a “Tomorrow” follow up flag, it will remind you tomorrow.

The “Today” flag is designed to remind you about things that you need to finish before you go home from work today… hence why it the default is for it to remind you 1 hour before the end of your work day (which would be 4pm in most cases).

As the “Tomorrow” flag is designed to remind you about things to do tomorrow, it will remind you by default at the start of the next work day (8am in most cases).

So say you want to have your default reminder first thing tomorrow morning? Then it is easy to change the default flag that is set. Simply right click on where you currently set your flag, and then in the pop up menu click on “Set Quick Click”. Change the default to “Tomorrow” and your default reminders will now be 8am on the next business day.

Hope that helps clear up some of the confusion around follow up flags. I can understand why it would be confusion coming from Outlook 2003, however with the new flexibility to set different types of flags, Outlook 2007 gives you a lot more control over when you get your reminders.

’till next time!
TNP 😉

PS. If you want to learn more about the default times, you can look at this Office Online help page – http://office.microsoft.com/en-us/outlook/HA012317831033.aspx

Get Outlook 2007 to connect remotely WITHOUT connecting to a VPN

Have you ever noticed if you select some text in Microsoft Word 2007 you get a little pop-up menu.  You know the one, physician it lets you change the font, apoplectic the font size, anabolics the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Word Options”
  3. Look in the “Popular section”, under “Top options for working with Word
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Word 2007

’till next time

TNP 😉

 

Technorati Tags: ,,

How many times have you lost everything in your document?  Word crashed?  Maybe the power went out?  Whatever it was that happened… I bet it happened just before you were going to save, pharm right?

By default, medicine Word 2007 makes an Auto Recover save every 10 minutes.  But if you are clumsy like me, or don’t trust your computer… you can set Word to autosave your document a lot more than normal.  Here is how:

  1. Click on the old file menu (the office orb)
  2. Click on "Word Options"
  3. Click on the "Save" option in the left hand menu
  4. In the first section "Save Documents", look for the second line which reads something like "Save AutoRecover information every XX minutes
  5. Set your preferred time.  Mine is now every 1 minute 🙂

Just remember when increasing the AutoRecover frequency… that you do see a slight performance hit every time it saves.  Not really noticeable every 10 minutes, but when it happens every 60 seconds it could be annoying!

’till next time!

TNP 😉

 

Technorati Tags: ,

Have you ever poured your heart and soul into absolutely awesome background in your word doc?  Maybe you coloured it bright yellow, therapist or purple, what is ed or ‘mother of pearl’? 

It looks great on the screen, but when you print it… you can’t see it!

Did you know by default Microsoft Word 2007 that background colors and images are not printed?

It is easy to print them out though.  Here is how:

  1. Open the file menu (the circle in the top left hand corner of the screen
  2. Click on "Word Options"
  3. Click on "Display" in the left hand menu
  4. Look in the "Printing options" section"
  5. Tick the "Print background colors and images" check box
  6. Click ok

How easy!  Just a word of warning though… printing a bright yellow background on every page will not only cost you an arm and a leg in ink and toner, but will also require you and your colleagues to invest in sunglasses.

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu.  You know the one, advice it lets you change the font, what is ed the font size, see the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Excel Options”
  3. Look in the “Popular section”, under “Top options for working with Excel
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Excel 2007

’till next time!

TNP 😉

 

Technorati Tags: ,

Are you a little worried by some of the names of the documents you have recently opened in Word 2007?  Scared your boss might catch you out updating your resume, therapist working on your next novel or simply working on things that you shouldn’t?  Well this little trick will help you out!  Basically, cough how to get rid of all those recent documents that Word 2007 lists for you.

  1. Open "Word Options" by clicking on the Office Button, and then looking for the "Word Options" button
  2. Click on the Advanced Section
  3. Scroll down to the "Display" Section
  4. The first option in the "Display" Section is "Show This Number of Recent Documents" – set that to "0"
  5. Click "Ok"

There you have it – no more recent documents means no more strife from your boss! 

But just in case you have a change of heart in the future, you can turn on recent documents again simply by changing the "0" to something like "5" or "17", depending on how many you want to see.

’till next time!
TNP 😉

 

Technorati Tags:

Want to be a desktop publishing great, diagnosis spreadsheeting wiz or PowerPoint guru and help the environment at the same time?

Guess what – you might be already!

Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.

Obviously they left one tip for reducing your impact on the environment… instead of investing in all those Office 2007 self help books, artificial why not just bookmark your favourite Office 2007 help, tips, tricks and tutorial site!

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?

Chances are they are using a great feature of Excel 2007 called "Merge and Center".  What does merge and center do?  Exactly that – it merges all the cells you have selected, bronchi and then centres the text!

So how do you do it?

  1. Select the cells you want to merge
  2. In the ribbon menu (the one at the top) make sure you are on the "Home" tab, noun and then look in the "Alignment" section
  3. Select "Merge & Center"

Simple as that!

Have you selected multiple rows?  Well you will notice that whilst the text will be horizontally centered… it will not be vertically centered.  How do you fix that?  Just near the "Merge & Center" button in the menu there are three buttons.  One that has lines at the top, patient one that has lines in the middle, and one that has lines at the bottom (the one with lines at the bottom will be selected).  Select the one with the lines in the middle – that will center the vertical alignment of your selection.

’till next time!

TNP 😉

Technorati Tags: ,,

Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, healthful rows, caries or both.

Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection".  It’s just like merge and centre, but without all the hassles that merging cells cause.

Center Across Selection is a little harder to find than Merge and Center, but in true The New Paperclip tradition… I am going to show you how!

  1. Select your text and the cells you want to centre your text over.
  2. On the ribbon, make sure you are on the "Home" tab, and then look for the "Alignment" group.
  3. Click on the little square with the arrow in the bottom right hand corner of the "Alignment" group.
  4. In the "Format Cells" box that appears, look for the "Horizontal" drop down box
  5. Select "Center Across Selection"
  6. Click "ok"
  7. Look in amazement at your perfectly centered text 🙂

How easy is that!  Thanks again Jon for the heads up!

’till next time!

TNP 😉

 

Technorati Tags: ,,

It has happened to the best of us.  Your day is going along great, rubella and then all of a sudden you get an Outlook reminder… a reminder for that meeting you totally forgot about.

Now you just have 15 minutes to salvage something out of nothing and impress the boss/wife/colleague/all of the above.

Don’t want to get caught out again?  Apart from memorising your entire calendar every morning and keeping an eagle eye on you watch (unlikely)… why don’t we just increase the default reminder time.

Its quite simple actually!  In Outlook 2007, apoplectic all you need to do is:

  1. Click on “Tools”
  2. Click on “Options”
  3. Look on the “Preferences” tab, in the “Calendar” section (second from the top)
  4. Select your preferred reminder time from the drop down box.
  5. Click ok

If you think you are a hotshot… set the reminder to 0 minutes.  If you are a lost cause, maybe 2 weeks is more appropriate 🙂

’till next time!

TNP 😉

 

 

 

 

Are you like me and need more than 15 minutes to prepare for those meetings you ALWAYS forget about?

Did you know that Microsoft have released an update to Office 2007?  They call it Service Pack 1 (or SP1 for the nerds out there!) and basically it is a big file that you can download that contains lots of updates and bug fixes.

So what you say?  Well it is a good idea to install the Service Pack for a couple of reasons – but the main one is security.

Microsoft Office 2007 Service Pack 1 fixes some holes in Word, view Excel and the rest of the Office suite – holes that could make your computer vulnerable to attack.

What is this PaperClip’s advice?  Simple.  If you haven’t installed it yet – download or get a CD containing the Service Pack, order and make sure you install it!

For more information on the service pack, visit http://support.microsoft.com/kb/936982, or if you want to download it already (note it is 218 MB!) go directly to http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

’till next time!
TNP 😉

Are you like me and tend to write lots and lots in your cells in Excel 2007?  It might be a good idea to make the text wrap.

What does wrapping text mean?  Basically it is where you take one long line of text, therapy and make it "wrap" around onto a number of lines instead.  That way you have a nice readable block of text, instead of the line that goes on forever.

How to you wrap cell text in Excel 2007?  Simple!

  1. Select the cell with all the text
  2. In the ribbon menu, on the "Home" tab, look for the "Alignment" group
  3. Click on the "Wrap Text" button.

 

’till next time!
TNP 😉

 

Do you want to pretty up your spreadsheets just a little?  Why not add a picture in the background!  It could be a company logo, sales a nice relaxing beach landscape or a picture of your kids… whatever it is… it is really simple to add a background image to your spreadsheets in Excel 2007

  1. Open up your spreadsheet
  2. Click on the “Page Layout” tab on the ribbon menu
  3. In the “Page Setup” group, and click on the “Background” button
  4. Select your image

Simple as that!  Now you have a nice background to complement your hard Excel work!

’till next time!
TNP 😉

 

Technorati Tags: ,,

Is there a feature of Office that you KNOW exists… but can’t for the life of you find it?

Maybe it was an old feature you remember from Word 2003, information pills or Excel, or PowerPoint.  They didn’t cover it in the course that work sent you to, you can’t find it in the help file, and Google hasn’t returned any results!

Panic?  Not quite yet!

Here is a neat little trick that I learnt from Tim Anderson over at ITWriting.

  1. Go to the Quick Access Toolbar (you know the one beside the big Office button (the old file menu!))
  2. You will see a little arrow that points down – click on it and then “Customize Quick Access Toolbar”
  3. Click on “More Commands”
  4. In the “Choose commands from” dropdown box, select “All Commands”
  5. Scroll through the list to find your long lost friend!

Simple as that! Kudos to Tim @ IT Writing for a fantastic find!

’till next time!
TNP 😉

I was surfing over at Simply-Basic.com today and stumbled across a great trick that you will find really handy!

In the post John Kolbert explains how Word 2007 interprets dashes, price dots, sale asterisks and more and turns them into different horizontal lines – very cool indeed.

Do you want a simple horizontal line? Type 3 dashes in a row (“—“) and hit enter

What about a thicker line?  Type 3 underscore lines in a row (“___”) and hit enter

So what you say!  What about something trickier like a double line?  Type 3 equals signs in a row (“===”) and hit enter.

There are a few other types of lines that you can create using this great trick – check out the rest of the post for more information.

’till next time!
TNP 😉

Hi there loyal TheNewPaperclip.com readers!

Over the last few months, order your fearless paperclip has been busy writing his very first e-book!  And now it is at a stage ready for public consumption… well almost!

I am looking for 10 people from around the world to be ‘beta testers’ for my new e-book.

All I ask from you is to answer a few questions over email, viagra maybe a IM conversation, or even a quick read of my draft.  In return I will give you a free copy of the e-book when it is published in a few weeks.

You want in?  Simply email my friend Paul Woods (by clicking on this address – paul@paul-woods.com) with a little bit about you, where you are from and why you want to be one of the beta readers!

I look forward to hearing from you.  Get in quick!  I can only accept nominations up until Friday 13 June 2008 (spooky!) and my favourite 10 will be part of the program.

’till next time!
TNP 😉

Have you ever wanted to open a PowerPoint deck that a friend of co-worker has sent you (you know the files – the ones with .ppt, phthisiatrician or .pptx on the end)… but you don’t have PowerPoint 2007 on your computer?

Well there are two options – you can go out and by PowerPoint 2007(and all the other parts of Office 2007)… or you can simply download the FREE PowerPoint Viewer 2007.

PowerPoint Viewer 2007 doesn’t let you edit a PowerPoint file, page but it lets you look at the presentation!  How cool is that (and seriously… what do you get for free these days!  NOT MUCH!)

’till next time!
TNP 😉

Did you think you have great Word 2007 skills?  Does everyone in the office come to you for help with Excel 2007 or PowerPoint?  Are you the Access 2007 database guru at work?

Well – instead of helping everyone else all the time, approved how about you take some time to invest in yourself – and get a credential that proves your worth to your organisation!

You want to become a Microsoft Certified Application Specialist (or MCAS).

What is a Microsoft Certified Application Specialist?  Someone who knows their stuff – that’s what!  Basically it means that possess the right skills and expertise to shine when using one of the Microsoft Office 2007 programs.

There is a different exam for each program (Word, order Excel, PowerPoint, Outlook and Access).. and you don’t have to do all of them! – Say you are just the best at PowerPoint and want to show that on your resume… then just do the PowerPoint 2007 exam.  Simple!

If you are interested, here is a quick list of the exams that you could take:

  • 77-601: MCAS: Using Microsoft Office Word 2007
  • 77-602: MCAS: Using Microsoft Office Excel 2007
  • 77-603: MCAS: Using Microsoft Office PowerPoint 2007
  • 77-604: MCAS: Using Microsoft Office Outlook 2007
  • 77-605: MCAS: Using Microsoft Office Access 2007

What kind of things do you need to know?

Here is a quick look at the topics covered in the Word 2007 exam:

  • Creating and customising documents
  • Formatting content
  • Working with visual content
  • Organising content
  • Reviewing documents
  • Sharing and securing content

To learn more about the Microsoft Certified Application Specialist, and what could be on the other Office 2007 exams – visit http://www.microsoft.com/learning/mcp/msbc/requirements/default.mspx

And if you are studying for any of the exams – make sure you take a look through the rest of this site (www.TheNewPaperclip.com – just in case you didn’t know)… as you might learn a thing or two that will be handy in your exam!

’till next time!
TNP 😉

Are you sending something to someone that you don’t want anyone else to see?  Maybe you are talking about your boss behind their back, hair sending a friend some photos that you don’t want the rest of the office to see… or simply don’t want someone to hit Reply-All on your email.

Well there is a way to turn off Forward and Reply-All.  Yes really!

First things first – this will only work if the person is using Microsoft Office Outlook 2007.  If the person you are sending the email to uses Outlook Express or Outlook Web Access… then you are out of luck 🙁

Want to learn how to do it?  Simply have a read of this article on Microsoft Office Online.

(Thanks to the Inside Office Online blog for pointing this great tip out!)

’till next time!
TNP 😉

In my day job (yeah.. this Paperclip can’t live off giving you Office 2007 help yet!) I always got frustrated when I tried to check my corporate email from home or on the road.  My office is essentially my laptop, adiposity and wether I am on my ADSL connection at home, generic or on my 3G Wireless connection, cheap whenever I wanted to check my email using Outlook, for security reasons (I am guessing) I needed to connect to work through a Virtual Private Network (VPN).  Very annoying!

But then I discovered a great way to get around that!  It is called "Outlook Anywhere" and is probably the hardest option to find and change in Outlook 2007!

For those interested in the details (from a popup box in Outlook 2007)… "Microsoft Office Outlook can communicate with Microsoft Exchange over the Internet by nesting Remote Procedure Calls (RPC) within HTTP packets." 

Woooo too technical for me… but what that basically means is that you don’t need a VPN connection, you just need access to the internet!  How good is that.

Here is how to do it.

  1. Click on "Tools", then "Options"
  2. Click on the "Mail Setup" Tab
  3. Click on the "E-mail Accounts…" button
  4. On the "Email" tab, click on your email account, and then click "Change"
  5. Click on "More Settings"
  6. Click on the "Connection" tab
  7. In the "Outlook Anywhere" section, check the box that says "Connect to Microsoft Exchange using HTTP"
  8. Click on "Exchange Proxy Settings…"
  9. Type your companies "Outlook Web Access" address in the "Connection Settings" box.  For example, it could be owa.companyname.com
  10. Click "OK" about 15 times to close all the windows
  11. Restart Outlook

And there you go – probably the most complicated menu structure in Outlook 2007, but when you find it, it is absolute GOLD!

Now go out and enjoy that extra 30 seconds I have given you every time you want to check your email!

’till next time!
TNP 😉

Don’t want someone to forward your email in Outlook 2007?

Have you ever noticed if you select some text in Microsoft Word 2007 you get a little pop-up menu.  You know the one, physician it lets you change the font, apoplectic the font size, anabolics the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Word Options”
  3. Look in the “Popular section”, under “Top options for working with Word
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Word 2007

’till next time

TNP 😉

 

Technorati Tags: ,,

How many times have you lost everything in your document?  Word crashed?  Maybe the power went out?  Whatever it was that happened… I bet it happened just before you were going to save, pharm right?

By default, medicine Word 2007 makes an Auto Recover save every 10 minutes.  But if you are clumsy like me, or don’t trust your computer… you can set Word to autosave your document a lot more than normal.  Here is how:

  1. Click on the old file menu (the office orb)
  2. Click on "Word Options"
  3. Click on the "Save" option in the left hand menu
  4. In the first section "Save Documents", look for the second line which reads something like "Save AutoRecover information every XX minutes
  5. Set your preferred time.  Mine is now every 1 minute 🙂

Just remember when increasing the AutoRecover frequency… that you do see a slight performance hit every time it saves.  Not really noticeable every 10 minutes, but when it happens every 60 seconds it could be annoying!

’till next time!

TNP 😉

 

Technorati Tags: ,

Have you ever poured your heart and soul into absolutely awesome background in your word doc?  Maybe you coloured it bright yellow, therapist or purple, what is ed or ‘mother of pearl’? 

It looks great on the screen, but when you print it… you can’t see it!

Did you know by default Microsoft Word 2007 that background colors and images are not printed?

It is easy to print them out though.  Here is how:

  1. Open the file menu (the circle in the top left hand corner of the screen
  2. Click on "Word Options"
  3. Click on "Display" in the left hand menu
  4. Look in the "Printing options" section"
  5. Tick the "Print background colors and images" check box
  6. Click ok

How easy!  Just a word of warning though… printing a bright yellow background on every page will not only cost you an arm and a leg in ink and toner, but will also require you and your colleagues to invest in sunglasses.

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu.  You know the one, advice it lets you change the font, what is ed the font size, see the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Excel Options”
  3. Look in the “Popular section”, under “Top options for working with Excel
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Excel 2007

’till next time!

TNP 😉

 

Technorati Tags: ,

Are you a little worried by some of the names of the documents you have recently opened in Word 2007?  Scared your boss might catch you out updating your resume, therapist working on your next novel or simply working on things that you shouldn’t?  Well this little trick will help you out!  Basically, cough how to get rid of all those recent documents that Word 2007 lists for you.

  1. Open "Word Options" by clicking on the Office Button, and then looking for the "Word Options" button
  2. Click on the Advanced Section
  3. Scroll down to the "Display" Section
  4. The first option in the "Display" Section is "Show This Number of Recent Documents" – set that to "0"
  5. Click "Ok"

There you have it – no more recent documents means no more strife from your boss! 

But just in case you have a change of heart in the future, you can turn on recent documents again simply by changing the "0" to something like "5" or "17", depending on how many you want to see.

’till next time!
TNP 😉

 

Technorati Tags:

Want to be a desktop publishing great, diagnosis spreadsheeting wiz or PowerPoint guru and help the environment at the same time?

Guess what – you might be already!

Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.

Obviously they left one tip for reducing your impact on the environment… instead of investing in all those Office 2007 self help books, artificial why not just bookmark your favourite Office 2007 help, tips, tricks and tutorial site!

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?

Chances are they are using a great feature of Excel 2007 called "Merge and Center".  What does merge and center do?  Exactly that – it merges all the cells you have selected, bronchi and then centres the text!

So how do you do it?

  1. Select the cells you want to merge
  2. In the ribbon menu (the one at the top) make sure you are on the "Home" tab, noun and then look in the "Alignment" section
  3. Select "Merge & Center"

Simple as that!

Have you selected multiple rows?  Well you will notice that whilst the text will be horizontally centered… it will not be vertically centered.  How do you fix that?  Just near the "Merge & Center" button in the menu there are three buttons.  One that has lines at the top, patient one that has lines in the middle, and one that has lines at the bottom (the one with lines at the bottom will be selected).  Select the one with the lines in the middle – that will center the vertical alignment of your selection.

’till next time!

TNP 😉

Technorati Tags: ,,

Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, healthful rows, caries or both.

Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection".  It’s just like merge and centre, but without all the hassles that merging cells cause.

Center Across Selection is a little harder to find than Merge and Center, but in true The New Paperclip tradition… I am going to show you how!

  1. Select your text and the cells you want to centre your text over.
  2. On the ribbon, make sure you are on the "Home" tab, and then look for the "Alignment" group.
  3. Click on the little square with the arrow in the bottom right hand corner of the "Alignment" group.
  4. In the "Format Cells" box that appears, look for the "Horizontal" drop down box
  5. Select "Center Across Selection"
  6. Click "ok"
  7. Look in amazement at your perfectly centered text 🙂

How easy is that!  Thanks again Jon for the heads up!

’till next time!

TNP 😉

 

Technorati Tags: ,,

It has happened to the best of us.  Your day is going along great, rubella and then all of a sudden you get an Outlook reminder… a reminder for that meeting you totally forgot about.

Now you just have 15 minutes to salvage something out of nothing and impress the boss/wife/colleague/all of the above.

Don’t want to get caught out again?  Apart from memorising your entire calendar every morning and keeping an eagle eye on you watch (unlikely)… why don’t we just increase the default reminder time.

Its quite simple actually!  In Outlook 2007, apoplectic all you need to do is:

  1. Click on “Tools”
  2. Click on “Options”
  3. Look on the “Preferences” tab, in the “Calendar” section (second from the top)
  4. Select your preferred reminder time from the drop down box.
  5. Click ok

If you think you are a hotshot… set the reminder to 0 minutes.  If you are a lost cause, maybe 2 weeks is more appropriate 🙂

’till next time!

TNP 😉

 

 

 

 

Are you like me and need more than 15 minutes to prepare for those meetings you ALWAYS forget about?

Did you know that Microsoft have released an update to Office 2007?  They call it Service Pack 1 (or SP1 for the nerds out there!) and basically it is a big file that you can download that contains lots of updates and bug fixes.

So what you say?  Well it is a good idea to install the Service Pack for a couple of reasons – but the main one is security.

Microsoft Office 2007 Service Pack 1 fixes some holes in Word, view Excel and the rest of the Office suite – holes that could make your computer vulnerable to attack.

What is this PaperClip’s advice?  Simple.  If you haven’t installed it yet – download or get a CD containing the Service Pack, order and make sure you install it!

For more information on the service pack, visit http://support.microsoft.com/kb/936982, or if you want to download it already (note it is 218 MB!) go directly to http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

’till next time!
TNP 😉

Are you like me and tend to write lots and lots in your cells in Excel 2007?  It might be a good idea to make the text wrap.

What does wrapping text mean?  Basically it is where you take one long line of text, therapy and make it "wrap" around onto a number of lines instead.  That way you have a nice readable block of text, instead of the line that goes on forever.

How to you wrap cell text in Excel 2007?  Simple!

  1. Select the cell with all the text
  2. In the ribbon menu, on the "Home" tab, look for the "Alignment" group
  3. Click on the "Wrap Text" button.

 

’till next time!
TNP 😉

 

Do you want to pretty up your spreadsheets just a little?  Why not add a picture in the background!  It could be a company logo, sales a nice relaxing beach landscape or a picture of your kids… whatever it is… it is really simple to add a background image to your spreadsheets in Excel 2007

  1. Open up your spreadsheet
  2. Click on the “Page Layout” tab on the ribbon menu
  3. In the “Page Setup” group, and click on the “Background” button
  4. Select your image

Simple as that!  Now you have a nice background to complement your hard Excel work!

’till next time!
TNP 😉

 

Technorati Tags: ,,

Is there a feature of Office that you KNOW exists… but can’t for the life of you find it?

Maybe it was an old feature you remember from Word 2003, information pills or Excel, or PowerPoint.  They didn’t cover it in the course that work sent you to, you can’t find it in the help file, and Google hasn’t returned any results!

Panic?  Not quite yet!

Here is a neat little trick that I learnt from Tim Anderson over at ITWriting.

  1. Go to the Quick Access Toolbar (you know the one beside the big Office button (the old file menu!))
  2. You will see a little arrow that points down – click on it and then “Customize Quick Access Toolbar”
  3. Click on “More Commands”
  4. In the “Choose commands from” dropdown box, select “All Commands”
  5. Scroll through the list to find your long lost friend!

Simple as that! Kudos to Tim @ IT Writing for a fantastic find!

’till next time!
TNP 😉

I was surfing over at Simply-Basic.com today and stumbled across a great trick that you will find really handy!

In the post John Kolbert explains how Word 2007 interprets dashes, price dots, sale asterisks and more and turns them into different horizontal lines – very cool indeed.

Do you want a simple horizontal line? Type 3 dashes in a row (“—“) and hit enter

What about a thicker line?  Type 3 underscore lines in a row (“___”) and hit enter

So what you say!  What about something trickier like a double line?  Type 3 equals signs in a row (“===”) and hit enter.

There are a few other types of lines that you can create using this great trick – check out the rest of the post for more information.

’till next time!
TNP 😉

Hi there loyal TheNewPaperclip.com readers!

Over the last few months, order your fearless paperclip has been busy writing his very first e-book!  And now it is at a stage ready for public consumption… well almost!

I am looking for 10 people from around the world to be ‘beta testers’ for my new e-book.

All I ask from you is to answer a few questions over email, viagra maybe a IM conversation, or even a quick read of my draft.  In return I will give you a free copy of the e-book when it is published in a few weeks.

You want in?  Simply email my friend Paul Woods (by clicking on this address – paul@paul-woods.com) with a little bit about you, where you are from and why you want to be one of the beta readers!

I look forward to hearing from you.  Get in quick!  I can only accept nominations up until Friday 13 June 2008 (spooky!) and my favourite 10 will be part of the program.

’till next time!
TNP 😉

Have you ever wanted to open a PowerPoint deck that a friend of co-worker has sent you (you know the files – the ones with .ppt, phthisiatrician or .pptx on the end)… but you don’t have PowerPoint 2007 on your computer?

Well there are two options – you can go out and by PowerPoint 2007(and all the other parts of Office 2007)… or you can simply download the FREE PowerPoint Viewer 2007.

PowerPoint Viewer 2007 doesn’t let you edit a PowerPoint file, page but it lets you look at the presentation!  How cool is that (and seriously… what do you get for free these days!  NOT MUCH!)

’till next time!
TNP 😉

Did you think you have great Word 2007 skills?  Does everyone in the office come to you for help with Excel 2007 or PowerPoint?  Are you the Access 2007 database guru at work?

Well – instead of helping everyone else all the time, approved how about you take some time to invest in yourself – and get a credential that proves your worth to your organisation!

You want to become a Microsoft Certified Application Specialist (or MCAS).

What is a Microsoft Certified Application Specialist?  Someone who knows their stuff – that’s what!  Basically it means that possess the right skills and expertise to shine when using one of the Microsoft Office 2007 programs.

There is a different exam for each program (Word, order Excel, PowerPoint, Outlook and Access).. and you don’t have to do all of them! – Say you are just the best at PowerPoint and want to show that on your resume… then just do the PowerPoint 2007 exam.  Simple!

If you are interested, here is a quick list of the exams that you could take:

  • 77-601: MCAS: Using Microsoft Office Word 2007
  • 77-602: MCAS: Using Microsoft Office Excel 2007
  • 77-603: MCAS: Using Microsoft Office PowerPoint 2007
  • 77-604: MCAS: Using Microsoft Office Outlook 2007
  • 77-605: MCAS: Using Microsoft Office Access 2007

What kind of things do you need to know?

Here is a quick look at the topics covered in the Word 2007 exam:

  • Creating and customising documents
  • Formatting content
  • Working with visual content
  • Organising content
  • Reviewing documents
  • Sharing and securing content

To learn more about the Microsoft Certified Application Specialist, and what could be on the other Office 2007 exams – visit http://www.microsoft.com/learning/mcp/msbc/requirements/default.mspx

And if you are studying for any of the exams – make sure you take a look through the rest of this site (www.TheNewPaperclip.com – just in case you didn’t know)… as you might learn a thing or two that will be handy in your exam!

’till next time!
TNP 😉

Are you sending something to someone that you don’t want anyone else to see?  Maybe you are talking about your boss behind their back, hair sending a friend some photos that you don’t want the rest of the office to see… or simply don’t want someone to hit Reply-All on your email.

Well there is a way to turn off Forward and Reply-All.  Yes really!

First things first – this will only work if the person is using Microsoft Office Outlook 2007.  If the person you are sending the email to uses Outlook Express or Outlook Web Access… then you are out of luck 🙁

Want to learn how to do it?  Simply have a read of this article on Microsoft Office Online.

(Thanks to the Inside Office Online blog for pointing this great tip out!)

’till next time!
TNP 😉

Become Certified on Office 2007 – impress your boss!

Have you ever noticed if you select some text in Microsoft Word 2007 you get a little pop-up menu.  You know the one, physician it lets you change the font, apoplectic the font size, anabolics the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Word Options”
  3. Look in the “Popular section”, under “Top options for working with Word
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Word 2007

’till next time

TNP 😉

 

Technorati Tags: ,,

How many times have you lost everything in your document?  Word crashed?  Maybe the power went out?  Whatever it was that happened… I bet it happened just before you were going to save, pharm right?

By default, medicine Word 2007 makes an Auto Recover save every 10 minutes.  But if you are clumsy like me, or don’t trust your computer… you can set Word to autosave your document a lot more than normal.  Here is how:

  1. Click on the old file menu (the office orb)
  2. Click on "Word Options"
  3. Click on the "Save" option in the left hand menu
  4. In the first section "Save Documents", look for the second line which reads something like "Save AutoRecover information every XX minutes
  5. Set your preferred time.  Mine is now every 1 minute 🙂

Just remember when increasing the AutoRecover frequency… that you do see a slight performance hit every time it saves.  Not really noticeable every 10 minutes, but when it happens every 60 seconds it could be annoying!

’till next time!

TNP 😉

 

Technorati Tags: ,

Have you ever poured your heart and soul into absolutely awesome background in your word doc?  Maybe you coloured it bright yellow, therapist or purple, what is ed or ‘mother of pearl’? 

It looks great on the screen, but when you print it… you can’t see it!

Did you know by default Microsoft Word 2007 that background colors and images are not printed?

It is easy to print them out though.  Here is how:

  1. Open the file menu (the circle in the top left hand corner of the screen
  2. Click on "Word Options"
  3. Click on "Display" in the left hand menu
  4. Look in the "Printing options" section"
  5. Tick the "Print background colors and images" check box
  6. Click ok

How easy!  Just a word of warning though… printing a bright yellow background on every page will not only cost you an arm and a leg in ink and toner, but will also require you and your colleagues to invest in sunglasses.

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu.  You know the one, advice it lets you change the font, what is ed the font size, see the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Excel Options”
  3. Look in the “Popular section”, under “Top options for working with Excel
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Excel 2007

’till next time!

TNP 😉

 

Technorati Tags: ,

Are you a little worried by some of the names of the documents you have recently opened in Word 2007?  Scared your boss might catch you out updating your resume, therapist working on your next novel or simply working on things that you shouldn’t?  Well this little trick will help you out!  Basically, cough how to get rid of all those recent documents that Word 2007 lists for you.

  1. Open "Word Options" by clicking on the Office Button, and then looking for the "Word Options" button
  2. Click on the Advanced Section
  3. Scroll down to the "Display" Section
  4. The first option in the "Display" Section is "Show This Number of Recent Documents" – set that to "0"
  5. Click "Ok"

There you have it – no more recent documents means no more strife from your boss! 

But just in case you have a change of heart in the future, you can turn on recent documents again simply by changing the "0" to something like "5" or "17", depending on how many you want to see.

’till next time!
TNP 😉

 

Technorati Tags:

Want to be a desktop publishing great, diagnosis spreadsheeting wiz or PowerPoint guru and help the environment at the same time?

Guess what – you might be already!

Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.

Obviously they left one tip for reducing your impact on the environment… instead of investing in all those Office 2007 self help books, artificial why not just bookmark your favourite Office 2007 help, tips, tricks and tutorial site!

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?

Chances are they are using a great feature of Excel 2007 called "Merge and Center".  What does merge and center do?  Exactly that – it merges all the cells you have selected, bronchi and then centres the text!

So how do you do it?

  1. Select the cells you want to merge
  2. In the ribbon menu (the one at the top) make sure you are on the "Home" tab, noun and then look in the "Alignment" section
  3. Select "Merge & Center"

Simple as that!

Have you selected multiple rows?  Well you will notice that whilst the text will be horizontally centered… it will not be vertically centered.  How do you fix that?  Just near the "Merge & Center" button in the menu there are three buttons.  One that has lines at the top, patient one that has lines in the middle, and one that has lines at the bottom (the one with lines at the bottom will be selected).  Select the one with the lines in the middle – that will center the vertical alignment of your selection.

’till next time!

TNP 😉

Technorati Tags: ,,

Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, healthful rows, caries or both.

Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection".  It’s just like merge and centre, but without all the hassles that merging cells cause.

Center Across Selection is a little harder to find than Merge and Center, but in true The New Paperclip tradition… I am going to show you how!

  1. Select your text and the cells you want to centre your text over.
  2. On the ribbon, make sure you are on the "Home" tab, and then look for the "Alignment" group.
  3. Click on the little square with the arrow in the bottom right hand corner of the "Alignment" group.
  4. In the "Format Cells" box that appears, look for the "Horizontal" drop down box
  5. Select "Center Across Selection"
  6. Click "ok"
  7. Look in amazement at your perfectly centered text 🙂

How easy is that!  Thanks again Jon for the heads up!

’till next time!

TNP 😉

 

Technorati Tags: ,,

It has happened to the best of us.  Your day is going along great, rubella and then all of a sudden you get an Outlook reminder… a reminder for that meeting you totally forgot about.

Now you just have 15 minutes to salvage something out of nothing and impress the boss/wife/colleague/all of the above.

Don’t want to get caught out again?  Apart from memorising your entire calendar every morning and keeping an eagle eye on you watch (unlikely)… why don’t we just increase the default reminder time.

Its quite simple actually!  In Outlook 2007, apoplectic all you need to do is:

  1. Click on “Tools”
  2. Click on “Options”
  3. Look on the “Preferences” tab, in the “Calendar” section (second from the top)
  4. Select your preferred reminder time from the drop down box.
  5. Click ok

If you think you are a hotshot… set the reminder to 0 minutes.  If you are a lost cause, maybe 2 weeks is more appropriate 🙂

’till next time!

TNP 😉

 

 

 

 

Are you like me and need more than 15 minutes to prepare for those meetings you ALWAYS forget about?

Did you know that Microsoft have released an update to Office 2007?  They call it Service Pack 1 (or SP1 for the nerds out there!) and basically it is a big file that you can download that contains lots of updates and bug fixes.

So what you say?  Well it is a good idea to install the Service Pack for a couple of reasons – but the main one is security.

Microsoft Office 2007 Service Pack 1 fixes some holes in Word, view Excel and the rest of the Office suite – holes that could make your computer vulnerable to attack.

What is this PaperClip’s advice?  Simple.  If you haven’t installed it yet – download or get a CD containing the Service Pack, order and make sure you install it!

For more information on the service pack, visit http://support.microsoft.com/kb/936982, or if you want to download it already (note it is 218 MB!) go directly to http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

’till next time!
TNP 😉

Are you like me and tend to write lots and lots in your cells in Excel 2007?  It might be a good idea to make the text wrap.

What does wrapping text mean?  Basically it is where you take one long line of text, therapy and make it "wrap" around onto a number of lines instead.  That way you have a nice readable block of text, instead of the line that goes on forever.

How to you wrap cell text in Excel 2007?  Simple!

  1. Select the cell with all the text
  2. In the ribbon menu, on the "Home" tab, look for the "Alignment" group
  3. Click on the "Wrap Text" button.

 

’till next time!
TNP 😉

 

Do you want to pretty up your spreadsheets just a little?  Why not add a picture in the background!  It could be a company logo, sales a nice relaxing beach landscape or a picture of your kids… whatever it is… it is really simple to add a background image to your spreadsheets in Excel 2007

  1. Open up your spreadsheet
  2. Click on the “Page Layout” tab on the ribbon menu
  3. In the “Page Setup” group, and click on the “Background” button
  4. Select your image

Simple as that!  Now you have a nice background to complement your hard Excel work!

’till next time!
TNP 😉

 

Technorati Tags: ,,

Is there a feature of Office that you KNOW exists… but can’t for the life of you find it?

Maybe it was an old feature you remember from Word 2003, information pills or Excel, or PowerPoint.  They didn’t cover it in the course that work sent you to, you can’t find it in the help file, and Google hasn’t returned any results!

Panic?  Not quite yet!

Here is a neat little trick that I learnt from Tim Anderson over at ITWriting.

  1. Go to the Quick Access Toolbar (you know the one beside the big Office button (the old file menu!))
  2. You will see a little arrow that points down – click on it and then “Customize Quick Access Toolbar”
  3. Click on “More Commands”
  4. In the “Choose commands from” dropdown box, select “All Commands”
  5. Scroll through the list to find your long lost friend!

Simple as that! Kudos to Tim @ IT Writing for a fantastic find!

’till next time!
TNP 😉

I was surfing over at Simply-Basic.com today and stumbled across a great trick that you will find really handy!

In the post John Kolbert explains how Word 2007 interprets dashes, price dots, sale asterisks and more and turns them into different horizontal lines – very cool indeed.

Do you want a simple horizontal line? Type 3 dashes in a row (“—“) and hit enter

What about a thicker line?  Type 3 underscore lines in a row (“___”) and hit enter

So what you say!  What about something trickier like a double line?  Type 3 equals signs in a row (“===”) and hit enter.

There are a few other types of lines that you can create using this great trick – check out the rest of the post for more information.

’till next time!
TNP 😉

Hi there loyal TheNewPaperclip.com readers!

Over the last few months, order your fearless paperclip has been busy writing his very first e-book!  And now it is at a stage ready for public consumption… well almost!

I am looking for 10 people from around the world to be ‘beta testers’ for my new e-book.

All I ask from you is to answer a few questions over email, viagra maybe a IM conversation, or even a quick read of my draft.  In return I will give you a free copy of the e-book when it is published in a few weeks.

You want in?  Simply email my friend Paul Woods (by clicking on this address – paul@paul-woods.com) with a little bit about you, where you are from and why you want to be one of the beta readers!

I look forward to hearing from you.  Get in quick!  I can only accept nominations up until Friday 13 June 2008 (spooky!) and my favourite 10 will be part of the program.

’till next time!
TNP 😉

Have you ever wanted to open a PowerPoint deck that a friend of co-worker has sent you (you know the files – the ones with .ppt, phthisiatrician or .pptx on the end)… but you don’t have PowerPoint 2007 on your computer?

Well there are two options – you can go out and by PowerPoint 2007(and all the other parts of Office 2007)… or you can simply download the FREE PowerPoint Viewer 2007.

PowerPoint Viewer 2007 doesn’t let you edit a PowerPoint file, page but it lets you look at the presentation!  How cool is that (and seriously… what do you get for free these days!  NOT MUCH!)

’till next time!
TNP 😉

Did you think you have great Word 2007 skills?  Does everyone in the office come to you for help with Excel 2007 or PowerPoint?  Are you the Access 2007 database guru at work?

Well – instead of helping everyone else all the time, approved how about you take some time to invest in yourself – and get a credential that proves your worth to your organisation!

You want to become a Microsoft Certified Application Specialist (or MCAS).

What is a Microsoft Certified Application Specialist?  Someone who knows their stuff – that’s what!  Basically it means that possess the right skills and expertise to shine when using one of the Microsoft Office 2007 programs.

There is a different exam for each program (Word, order Excel, PowerPoint, Outlook and Access).. and you don’t have to do all of them! – Say you are just the best at PowerPoint and want to show that on your resume… then just do the PowerPoint 2007 exam.  Simple!

If you are interested, here is a quick list of the exams that you could take:

  • 77-601: MCAS: Using Microsoft Office Word 2007
  • 77-602: MCAS: Using Microsoft Office Excel 2007
  • 77-603: MCAS: Using Microsoft Office PowerPoint 2007
  • 77-604: MCAS: Using Microsoft Office Outlook 2007
  • 77-605: MCAS: Using Microsoft Office Access 2007

What kind of things do you need to know?

Here is a quick look at the topics covered in the Word 2007 exam:

  • Creating and customising documents
  • Formatting content
  • Working with visual content
  • Organising content
  • Reviewing documents
  • Sharing and securing content

To learn more about the Microsoft Certified Application Specialist, and what could be on the other Office 2007 exams – visit http://www.microsoft.com/learning/mcp/msbc/requirements/default.mspx

And if you are studying for any of the exams – make sure you take a look through the rest of this site (www.TheNewPaperclip.com – just in case you didn’t know)… as you might learn a thing or two that will be handy in your exam!

’till next time!
TNP 😉