Create your 2011 Calendar in Word 2010

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

Check it out at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66a6848c-6c28-4b61-9c12-a8cad4b380a4&displaylang=en

‘till next time!
TNP 😉

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

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

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

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

 

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

‘till next time!

TNP 😉

Guide to Group Policy in Office 2010

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

Check it out at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66a6848c-6c28-4b61-9c12-a8cad4b380a4&displaylang=en

‘till next time!
TNP 😉

Building an add-in for Microsoft Office

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

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

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

1) Roll your own

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

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

So I decided to use an alternative.

2) Use Add-in-Express

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

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

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

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

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

‘till next time!
TNP Winking smile

The file menu is back! Welcome to Office 2010

Do you want your page to stretch right across your monitor?  By using “Zoom to Page Width” you can do just that.

To Zoom to Page Width in Word 2007:

1) Click on the “View” tab in the ribbon

2) Look for the “Zoom” group

3) Click on “Page Width”

 

‘till next time!
TNP 😉

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

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

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

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

‘till next time!
TNP 😉

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

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

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

1) Click on the “Design” tab

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

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

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

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, viagra sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, eczema
just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉

Do you want a great looking presentation, women’s health
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Did you know that Outlook 2007 saves drafts of your emails as you type them?  This is great if you accidentally close the email window before sending, disease
or start an email and then the power goes out.

By default Outlook will save a draft every three minutes.  But if you are paranoid about losing your work… or don’t care that much… you can change the timeframes in which the auto-save occurs.

To increase or decrease the auto-save time for draft emails in Outlook 2007:

1) Click “Options” from the menu

2) Make sure you are on the “Preferences” tab”

3) Click the “E-mail Options…” button

4) Click the “Advanced E-Mail Options…” button (about half way down the window)

5) Beside the first checkbox (“AutoSave items every:”) change the number to the number of minutes you would like the interval to be

6) Click OK 3 times to close all the windows

 

To find the drafts that Outlook saves, just take a look in your drafts folder

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, order instead of the default Landscape slide orientation?

To change to Portrait in PowerPoint 2007:

1) Make sure you are on the “Design” tab of the ribbon

2) Look for the “Page Setup” group – on the left hand side of the ribbon

3) Click on “Slide Orientation”

4) Click on “Portrait”

To reverse back to Landscape, just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

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

To sort from low to high in Excel 2007:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

3) Look for the “Sort & Filter” group

4) Click on the “Sort A to Z” button – it is the one that has an A on top of a Z with an arrow pointing down.

 

‘till next time!
TNP 😉

Have you noticed when you spell check an email where you are replying to or forwarding another email, try
that sometimes spell check decides it needs to highlight the poor spelling of your friend or colleague?

Well if you get annoyed by that as much as I do, approved
you will be glad to know there is a setting in Outlook 2007 to ensure that the spelling and grammar checker only checks the content you wrote.

To ignore the original message text in reply or forward:

1) Click “Tools”

2) Click “Options”

3) Click on the “Spelling” tab

4) Check the box “Ignore original message text in reply or forward”

 

‘till next time!
TNP 😉

The To-Do bar in Outlook 2007 is a great time saver – a quick way to understand your current workload, discount
and upcoming appointments.

By default there should be three upcoming appointments shown in the to-do bar – but did you know that you can customise it so you can show more, see
or less appointments?

To increase or decrease the number of upcoming appointments shown in the Outlook 2007 to-do bar:

1) Right click on the To-Do Bar

2) Click “Options…” from the menu that appears

3) In the “To-Do Bar Options” box that appears, change the number of appointments to your preferred number.

Whilst you can have more appointments visible than that can fit on your screen, don’t go to overboard… 5 or 7 would be the upper limit for it to be useful.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, pfizer
hitting a key, health
or pressing next on your wireless presenter?

Well in PowerPoint 2007, you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

2) Click on the “Animations” tab of the ribbon

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, artificial
or click on “Define New Bullet”

If you are defining a new bullet, dosage
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007.

By using the “Trace Dependents” feature, tuberculosis
you can very quickly understand exactly the influence a cell has in your spreadsheet.  The best part of this feature is, look
that you will see big arrows that enable you to visually see the relationship, so you don’t have to decipher formulas and cell names to make sense of it all.

To turn on Trace Dependents:

1) Select the cell you want to see the dependents of

2) Make sure you are on the “Formulas” tab of the ribbon

3) Look for the “Formula Auditing” group (about 3/4 of the way along the ribbon)

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, ailment
and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, case you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Do you want to quickly insert a blank page into your Word 2007 document?  Instead of hitting enter 40 times, pharm
why don’t you use the Insert Blank Page button?

All you have to do is:

1) Make sure you are on the “Insert” tab of the ribbon

2) Look for the pages group – on the left hand side

3) Click on “Blank Page”

 

Now you will see a blank page appear in your document where your cursor was.  To add multiple blank pages, just keep clicking that “Blank Page” button!

‘till next time!
TNP 😉

If you have ever printed handouts for your PowerPoint presentations before, unhealthy you know that they can be pretty bland.  Just the slides all stacked up on a page, with plenty of whitespace.

Well did you know that you have complete control over how those handouts actually look?  You can add your company logo, or a copyright statement, or remove the date or the page numbers.  You can do whatever you want!

All of this is controlled from what is called the “Handout Master”.  Those of you familiar with the “Slide Master” will know exactly what we are talking about.  The easiest way to describe the handout master is that it is the template for all the handouts printed from the presentation.

To access the Handout Master in PowerPoint 2007:

1) Click on the “View” tab in the ribbon

2) In the “Presentation Views” group on the left hand side, click on “Handout Master”

Once you are in the master, you can control all manner of different things, including the page setup, the handout orientation (portrait or landscape), the slide orientation on the handouts, and how many slides will appear on each page.

To get out of the “Handout Master” view… simply click the “Close Master View” button on the right hand side of the ribbon

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, purchase
and want to review all the reminders you currently have, buy cialis there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Have you ever read a document that has a line like… “See more in section 5.1” or “Refer to figure 8”

Did you know in Word 2007 you can create these cross references, remedy
and automatically include a hyperlink which when clicked will take the reader directly to the content?

It looks a little complicated when you first take a look, denture
but here is the easy way to create a cross reference in Word 2007

1) Make sure any content you are going to cross reference to exists in the first place.  If you have pictures which you will refer to as figures for example, gynecologist
make sure you are using captions – if not, you can’t cross reference to them

2) Click where you want the cross reference to be placed in your document

3) Click on the “Insert” tab of the ribbon

4) Look for the “Links group”

5) Click on “Cross-reference”

6) You will see two drop down boxes in the “Cross-reference” window.  In the first drop down box, select the type of thing in your document you want to cross reference to – for example if you want to link to a heading, select “Heading”, if you want to cross reference to a figure, select “Figure”

7) You will notice that in the big white box below, a list of all the different things you can cross reference to will now appear.  Select the item you want to cross reference to.  Note, if it doesn’t appear in the list, chances are you haven’t used the right caption, or used a heading style on the item

8) In the second drop down box, select how you want the cross reference described to take the reader of the document – do you just want the page number? or the heading text, or the caption, or the figure number?  Select your preferred option

9) When you are ready, click on “Insert”

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, ampoule you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

Do you want to copy one, treatment two, pancreatitis
three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

2) Make sure you are on the “Home” tab of the ribbon

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, diagnosis there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, recipe
type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

Well instead of adding a simple table layout to your slide, viagra approved
you can actually add an Excel spreadsheet.  You have all the features of Excel – like formulas, but in a nice looking PowerPoint table.

To insert an Excel table in PowerPoint 2007:

1) Make sure you are on the slide you want to include the table in

2) Click on the “Insert” tab of the ribbon

3) Click on the little arrow below the “Table” button

4) Click on “Excel Spreadsheet”

5) Enter your data, manipulate it, and format the table as you desire

 

‘till next time!
TNP 😉

Hi there!

Are you on the bleeding edge and have already had a play around with the beta version of Microsoft Office 2010?  Or are you just interested in what is coming in the next version of your favourite productivity tool?  Well do we have a great link for you today!

Our friends over at Microsoft Press have released a few electronic version of the book – “First Look Microsoft Office 2010”.  14 chapters of Office 2010 gold, overweight
including:

  • Welcome to Office 2010
  • Express Yourself Effectively and Efficiently
  • Collaborate in the Office and Around the World
  • Create and Share Compelling Documents with Word 2010
  • Create Smart Data Insights with Excel 2010
  • Manage Rich Communications with Outlook 2010
  • Produce Dynamic Presentations with PowerPoint 2010
  • Organize, heart
    Store, dosage
    and Share Ideas with OneNote 2010
  • Collaborate Effectively with SharePoint Workspace 2010
  • Create Effective Marketing Materials with Publisher 2010
  • Make Sense of Your Data with Access 2010
  • Putting It All Together
  • Security in Office 2010
  • Training Made Easy

You can read the Microsoft Press blog post – or just click here and download the book directly.  It is about 10.5mb or so.

‘till next time!
TNP 😉

I have had a lot of feedback from readers of TheNewPaperclip.com, therapy
and those that subscribe to the Office 2007 tips newsletter.  People are screaming out for short, pilule
concise courses that will help them do overcome annoying challenges, and do amazing things with Office 2007. 

These people – maybe you – have had thoughts like “How do I get Outlook to do this?…”, “How can I get my document to look as great as Jenny’s?…”.  “How come everyone says how good Brad’s PowerPoint slides are?”

There are plenty of different ways to answer those questions – maybe you have tried some of them, like courses or books.  But they are not for everyone:

  • Maybe you live in a remote area and can’t get to an instructor lead class because the closest one is 1, 2, 3, or even 6 hours away by car.
  • Maybe you think that reading a bland text book that is 600 pages long is not fun (I AGREE!)
  • Maybe you just want to interact with someone who will be able to give you the answers you need?

If you answered yes to just one of the above – then it sounds like the Office 2007 workshops I will be delivering during the next few months will be exactly what you need.

Are you like many of your fellow TheNewPaperclip.com readers and want to improve your capability and confidence with Office 2007?

If so – these four 2 hour workshops are designed just for you. 

  • Overcome Email Overload with Outlook 2007
    Get to know the key features of Outlook 2007 to help you mange your mail – plus time saving techniques that will enable you to conquer your inbox
  • Crunch Numbers Faster with Excel 2007
    Confidently apply formulas, create charts, and communicate complex data with meaning using Excel 2007
  • Create Better Looking Documents with Word 2007
    Build documents for your workplace, club or school that you can be proud of using Word 2007
  • Deliver Better Presentations with PowerPoint 2007
    Forget boring bullet points – learn the techniques professional speakers (and their designers) use to build compelling slide decks using PowerPoint 2007

 

The workshops will be delivered online, will be interactive, and attendance will be strictly limited to ensure everyone in the workshop gets the results they are after.

For more information as it becomes available over the next few weeks – including dates, times, and workshop prices – and to be one of the first to find out when bookings for each of the workshops have opened – register your details here:

 

By the way… if you pre register you will have access to a multiple workshop discount as well!

So if you are ready to get the most out of Office 2007 – make sure you register for more information, and then book into one of the workshops… coming soon.

‘til next time!
TNP 😉

If you are looking to spread some Easter cheer with your family, more about
friends, visit this site
or colleagues this Easter, why not use one of these great Easter templates for Word 2007 and OneNote 2007 Office Online!

I hope you and your family have a great Easter!

‘till next time!
TNP 😉

So if you are a bit of an Office freak like me, online you will know that Office 2010 was RTM’d last week (Released to Manufacturing – a fancy way of saying “yep, its ready”).  It will be available in the shops in the next few months, but if you are a corporate customer with a volume licensing agreement – or you have a subscription to MSDN or TechNet – you will find you can get the Office 2010 bits, and product keys already.

With RTM comes a shift in content here at The New Paperclip.  Whilst I will still produce Office 2007 content, there is a whole new world of Office 2010 that is to be explored, documented, and published in easy to understand language just for you kind folks!

Before we get into the nitty gritty of Office 2010 – there is one thing I would love to share with you.

One thing that most of you will like (and people that work on IT Helpdesks will LOVE) about Office 2010 is that the File Menu is back!  Well, technically it never left, but in Office 2007 it wasn’t called the File Menu, it was simply this weird looking “Office Orb”. 

So IT Managers – if you are looking for a quick win to cut your helpdesk calls dramatically (you know… all the ones that were like “Where has Print gone”, Where has Save gone” etc) – just upgrade to Office 2010.  Because everyone knows, you find them in the File Menu.  And you will not get as many calls about

“What is that funny looking circle thing… what do you mean you want me to click on it?  It doesn’t look like a button!”

If you are upgrading to Office 2010 – make sure you subscribe or check back regularly for more tips, tricks and tutorials.

‘till next time!
TNP 😉

First Look Microsoft Office 2010: Free e-Book from Microsoft Press

Do you want your page to stretch right across your monitor?  By using “Zoom to Page Width” you can do just that.

To Zoom to Page Width in Word 2007:

1) Click on the “View” tab in the ribbon

2) Look for the “Zoom” group

3) Click on “Page Width”

 

‘till next time!
TNP 😉

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

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

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

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

‘till next time!
TNP 😉

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

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

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

1) Click on the “Design” tab

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

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

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

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, viagra sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, eczema
just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉

Do you want a great looking presentation, women’s health
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Did you know that Outlook 2007 saves drafts of your emails as you type them?  This is great if you accidentally close the email window before sending, disease
or start an email and then the power goes out.

By default Outlook will save a draft every three minutes.  But if you are paranoid about losing your work… or don’t care that much… you can change the timeframes in which the auto-save occurs.

To increase or decrease the auto-save time for draft emails in Outlook 2007:

1) Click “Options” from the menu

2) Make sure you are on the “Preferences” tab”

3) Click the “E-mail Options…” button

4) Click the “Advanced E-Mail Options…” button (about half way down the window)

5) Beside the first checkbox (“AutoSave items every:”) change the number to the number of minutes you would like the interval to be

6) Click OK 3 times to close all the windows

 

To find the drafts that Outlook saves, just take a look in your drafts folder

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, order instead of the default Landscape slide orientation?

To change to Portrait in PowerPoint 2007:

1) Make sure you are on the “Design” tab of the ribbon

2) Look for the “Page Setup” group – on the left hand side of the ribbon

3) Click on “Slide Orientation”

4) Click on “Portrait”

To reverse back to Landscape, just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

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

To sort from low to high in Excel 2007:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

3) Look for the “Sort & Filter” group

4) Click on the “Sort A to Z” button – it is the one that has an A on top of a Z with an arrow pointing down.

 

‘till next time!
TNP 😉

Have you noticed when you spell check an email where you are replying to or forwarding another email, try
that sometimes spell check decides it needs to highlight the poor spelling of your friend or colleague?

Well if you get annoyed by that as much as I do, approved
you will be glad to know there is a setting in Outlook 2007 to ensure that the spelling and grammar checker only checks the content you wrote.

To ignore the original message text in reply or forward:

1) Click “Tools”

2) Click “Options”

3) Click on the “Spelling” tab

4) Check the box “Ignore original message text in reply or forward”

 

‘till next time!
TNP 😉

The To-Do bar in Outlook 2007 is a great time saver – a quick way to understand your current workload, discount
and upcoming appointments.

By default there should be three upcoming appointments shown in the to-do bar – but did you know that you can customise it so you can show more, see
or less appointments?

To increase or decrease the number of upcoming appointments shown in the Outlook 2007 to-do bar:

1) Right click on the To-Do Bar

2) Click “Options…” from the menu that appears

3) In the “To-Do Bar Options” box that appears, change the number of appointments to your preferred number.

Whilst you can have more appointments visible than that can fit on your screen, don’t go to overboard… 5 or 7 would be the upper limit for it to be useful.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, pfizer
hitting a key, health
or pressing next on your wireless presenter?

Well in PowerPoint 2007, you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

2) Click on the “Animations” tab of the ribbon

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, artificial
or click on “Define New Bullet”

If you are defining a new bullet, dosage
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007.

By using the “Trace Dependents” feature, tuberculosis
you can very quickly understand exactly the influence a cell has in your spreadsheet.  The best part of this feature is, look
that you will see big arrows that enable you to visually see the relationship, so you don’t have to decipher formulas and cell names to make sense of it all.

To turn on Trace Dependents:

1) Select the cell you want to see the dependents of

2) Make sure you are on the “Formulas” tab of the ribbon

3) Look for the “Formula Auditing” group (about 3/4 of the way along the ribbon)

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, ailment
and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, case you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Do you want to quickly insert a blank page into your Word 2007 document?  Instead of hitting enter 40 times, pharm
why don’t you use the Insert Blank Page button?

All you have to do is:

1) Make sure you are on the “Insert” tab of the ribbon

2) Look for the pages group – on the left hand side

3) Click on “Blank Page”

 

Now you will see a blank page appear in your document where your cursor was.  To add multiple blank pages, just keep clicking that “Blank Page” button!

‘till next time!
TNP 😉

If you have ever printed handouts for your PowerPoint presentations before, unhealthy you know that they can be pretty bland.  Just the slides all stacked up on a page, with plenty of whitespace.

Well did you know that you have complete control over how those handouts actually look?  You can add your company logo, or a copyright statement, or remove the date or the page numbers.  You can do whatever you want!

All of this is controlled from what is called the “Handout Master”.  Those of you familiar with the “Slide Master” will know exactly what we are talking about.  The easiest way to describe the handout master is that it is the template for all the handouts printed from the presentation.

To access the Handout Master in PowerPoint 2007:

1) Click on the “View” tab in the ribbon

2) In the “Presentation Views” group on the left hand side, click on “Handout Master”

Once you are in the master, you can control all manner of different things, including the page setup, the handout orientation (portrait or landscape), the slide orientation on the handouts, and how many slides will appear on each page.

To get out of the “Handout Master” view… simply click the “Close Master View” button on the right hand side of the ribbon

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, purchase
and want to review all the reminders you currently have, buy cialis there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Have you ever read a document that has a line like… “See more in section 5.1” or “Refer to figure 8”

Did you know in Word 2007 you can create these cross references, remedy
and automatically include a hyperlink which when clicked will take the reader directly to the content?

It looks a little complicated when you first take a look, denture
but here is the easy way to create a cross reference in Word 2007

1) Make sure any content you are going to cross reference to exists in the first place.  If you have pictures which you will refer to as figures for example, gynecologist
make sure you are using captions – if not, you can’t cross reference to them

2) Click where you want the cross reference to be placed in your document

3) Click on the “Insert” tab of the ribbon

4) Look for the “Links group”

5) Click on “Cross-reference”

6) You will see two drop down boxes in the “Cross-reference” window.  In the first drop down box, select the type of thing in your document you want to cross reference to – for example if you want to link to a heading, select “Heading”, if you want to cross reference to a figure, select “Figure”

7) You will notice that in the big white box below, a list of all the different things you can cross reference to will now appear.  Select the item you want to cross reference to.  Note, if it doesn’t appear in the list, chances are you haven’t used the right caption, or used a heading style on the item

8) In the second drop down box, select how you want the cross reference described to take the reader of the document – do you just want the page number? or the heading text, or the caption, or the figure number?  Select your preferred option

9) When you are ready, click on “Insert”

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, ampoule you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

Do you want to copy one, treatment two, pancreatitis
three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

2) Make sure you are on the “Home” tab of the ribbon

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, diagnosis there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, recipe
type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

Well instead of adding a simple table layout to your slide, viagra approved
you can actually add an Excel spreadsheet.  You have all the features of Excel – like formulas, but in a nice looking PowerPoint table.

To insert an Excel table in PowerPoint 2007:

1) Make sure you are on the slide you want to include the table in

2) Click on the “Insert” tab of the ribbon

3) Click on the little arrow below the “Table” button

4) Click on “Excel Spreadsheet”

5) Enter your data, manipulate it, and format the table as you desire

 

‘till next time!
TNP 😉

Hi there!

Are you on the bleeding edge and have already had a play around with the beta version of Microsoft Office 2010?  Or are you just interested in what is coming in the next version of your favourite productivity tool?  Well do we have a great link for you today!

Our friends over at Microsoft Press have released a few electronic version of the book – “First Look Microsoft Office 2010”.  14 chapters of Office 2010 gold, overweight
including:

  • Welcome to Office 2010
  • Express Yourself Effectively and Efficiently
  • Collaborate in the Office and Around the World
  • Create and Share Compelling Documents with Word 2010
  • Create Smart Data Insights with Excel 2010
  • Manage Rich Communications with Outlook 2010
  • Produce Dynamic Presentations with PowerPoint 2010
  • Organize, heart
    Store, dosage
    and Share Ideas with OneNote 2010
  • Collaborate Effectively with SharePoint Workspace 2010
  • Create Effective Marketing Materials with Publisher 2010
  • Make Sense of Your Data with Access 2010
  • Putting It All Together
  • Security in Office 2010
  • Training Made Easy

You can read the Microsoft Press blog post – or just click here and download the book directly.  It is about 10.5mb or so.

‘till next time!
TNP 😉

Create a 2010 Calendar in Word 2007

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

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

3) Create your own Holiday Greeting Cards!

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

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

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Put a Screenshot in a Word 2010 document

So you are a hotshot who doesn’t need to use a mouse!  Fair enough, viagra 40mg power users tend to find they can do tasks quicker by using shortcut keys.  Shortcut keys are combinations of keystrokes on your keyboard that can make the program do a certain task.

The new Ribbon UI in Word 2007, Excel 2007, and PowerPoint 2007 is easier to use with a mouse, but if you want to use your keyboard shortcuts, there is a quick, easy, and visual way to find out what you need to press.

All you need to do, is hit the “Alt” key.  Simple as that.  By pressing the “Alt” button in Word 2007, the keyboard shortcuts appear on top of all the different sections of the Ribbon.

For example, (looking at the screenshot), to open the file menu, all I need to do is hit “ALT+F”.  If I want to save my file, which happens to be one of the Quick Access Toolbar buttons, I could hit “Alt+1”.  To change to the Insert Tab in the Word 2007 ribbon, I could hit “Alt+N”

As soon as you go to another tab in the ribbon, if you hit “Alt” again, you can see all the shortcuts for each piece of functionality on that tab.

 

So there you have it – all you need to do is remember “Alt” is your shortcut to keyboard shortcuts in Word 2007! (and Excel 2007, PowerPoint 2007 etc etc).

Want to master the key shortcuts in Word 2007?

TheNewPaperclip.com has put together a 5 day audio course that will help you remember and confidently use the key keyboard shortcuts in Word 2007 in just 15 minutes a day.  You can find out more over at www.shortcutcourse.com, or you can enrol in the course now.

Buy Now 

’till next time!

TNP 😉

Office 2007, Shortcuts, Tips, Tutorial, Word 2007

Hey everyone… welcome to October! (OMG almost Christmas!)

I am sure almost everyone who is reading this post has Excel installed on their computer at work or at university.  But how many of you really know what Excel is really capable of?

This month I am going to focus on Excel 2007 content.  One Excel 2007 tutorial each day for the entire month… 31 posts that will help you master Excel (and not the other way around!)

So are you ready to excel at Excel?  (sorry, viagra sale had to do it!)  Stay tuned!

‘till next time!
TNP 😉

Are you working with numbers in Excel 2007, advice
Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉
Are you working with numbers in Excel 2007, global burden of disease
Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉
Are you working with numbers in Excel 2007 that include decimal points? 

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, help
look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉

So you have upgraded to Word 2010!  If you have made the leap from Office 2003 or earlier, sale
you might have a few challenges finding some of the features you use regularly.  One of those great features is Undo!  (I think Undo is the feature I use the most!)

To undo in Word 2010, you can either do it using your mouse, or using some shortcut keys.

To undo using your mouse in Word 2010:

  • Look towards the top left hand corner of your Word 2010 window.  Just above the office button you will see a number of small icons along the top of the screen (by the way – that is called the “Quick Access Toolbar”).  Click on the one that looks like an arrow that points backwards – that is the undo button. 
  • If you want to undo more than one mistake action – click on the little down arrow beside that button, and it will give you a list of actions you can undo!

To undo using shortcut keys in Word 2010:

  • Simply hold down the “CTRL” key, and press “z” (CTRL+Z)
  • To undo more than once, just keep pressing CTRL+Z

So there you have it – the easy way to get rid of your mistakes in Word 2010! 🙂

‘till next time!
TNP 😉

(PS. try this article if you are looking to undo in Word 2007)

Are you building a spreadsheet and would like to know how many black cells you have in a given range in an Excel 2007, oncologist
Excel 2010 or Excel 2013 workbook?

There is a great function in Excel that you can use to do exactly that – count the number of BLANK cells in a range.

Simply type…

=COUNTBLANK(range)

(replace range with the range of cells you want to limit your count to).

Note that there is one particular thing that might slip you up with this function.  When using =COUNTBLANK(), buy cialis
Excel is only searching for blank, empty cells.  If you have a space in a cell for example – it might look empty to you, but Excel can see that there is a space – which means it will not think it is blank, and not count it.

‘till next time!
TNP 😉

If you are like me, thumb or anyone else that I work with, drugs
in fact if you are anyone in business today – chances are you use Outlook EVERY DAY!

And if you are like 99% of the population, you will double click on that Outlook icon every morning to open it.  Talk about wasting time! 

Did you know that we can automate things so Outlook will automatically start whenever you log into your computer. 

All you need to do is find the “Startup” folder in your Windows XP, Windows Vista, or Windows 7 start menu.  Once you have found it, simply drag the Outlook icon into that folder.

Actually this works with any program, not just Outlook.  So if you want to automatically start Word, Excel, PowerPoint, Internet Explorer… in fact any application on your computer – just drag the icon into the Startup folder.

So there you have it – one less thing for you to do in the morning!

‘till next time!
TNP 😉

Hey if you have upgraded to Office 2010, sales you might have noticed an unreal new feature which allows you to very quickly paste a screenshot into your Word 2010 documents, salve
Excel 2010 workbooks, visit this
or PowerPoint 2010 decks!

Here is how!

  1. Open up your Word 2010 document
  2. Click on the “Insert tab” in the Word 2010 ribbon
  3. Look for the “Illustrations” group
  4. Click on “Screenshot”

Once you click on “Screenshot, you have two options.  The first is to simply paste in the screenshots that Word 2010 has already taken for you!  For example, if you have four different applications open, Word has figured out that you might want a screenshot of one of those applications – and simply lets you pick which one you want to use (very smart!).  All you have to do is click on the screenshot you want to use!

The second is to take a screen clipping – which allows you very fine control over which part of your screen you want to take a screen shot of.  Simply click on “Screen Clipping” and then drag your mouse to select your screenshot.

Either way, getting screenshots into Word, Excel, and PowerPoint 2010 just became a whole lot easier!

‘till next time!
TNP 😉

How to undo in Word 2010

So you are a hotshot who doesn’t need to use a mouse!  Fair enough, viagra 40mg power users tend to find they can do tasks quicker by using shortcut keys.  Shortcut keys are combinations of keystrokes on your keyboard that can make the program do a certain task.

The new Ribbon UI in Word 2007, Excel 2007, and PowerPoint 2007 is easier to use with a mouse, but if you want to use your keyboard shortcuts, there is a quick, easy, and visual way to find out what you need to press.

All you need to do, is hit the “Alt” key.  Simple as that.  By pressing the “Alt” button in Word 2007, the keyboard shortcuts appear on top of all the different sections of the Ribbon.

For example, (looking at the screenshot), to open the file menu, all I need to do is hit “ALT+F”.  If I want to save my file, which happens to be one of the Quick Access Toolbar buttons, I could hit “Alt+1”.  To change to the Insert Tab in the Word 2007 ribbon, I could hit “Alt+N”

As soon as you go to another tab in the ribbon, if you hit “Alt” again, you can see all the shortcuts for each piece of functionality on that tab.

 

So there you have it – all you need to do is remember “Alt” is your shortcut to keyboard shortcuts in Word 2007! (and Excel 2007, PowerPoint 2007 etc etc).

Want to master the key shortcuts in Word 2007?

TheNewPaperclip.com has put together a 5 day audio course that will help you remember and confidently use the key keyboard shortcuts in Word 2007 in just 15 minutes a day.  You can find out more over at www.shortcutcourse.com, or you can enrol in the course now.

Buy Now 

’till next time!

TNP 😉

Office 2007, Shortcuts, Tips, Tutorial, Word 2007

Hey everyone… welcome to October! (OMG almost Christmas!)

I am sure almost everyone who is reading this post has Excel installed on their computer at work or at university.  But how many of you really know what Excel is really capable of?

This month I am going to focus on Excel 2007 content.  One Excel 2007 tutorial each day for the entire month… 31 posts that will help you master Excel (and not the other way around!)

So are you ready to excel at Excel?  (sorry, viagra sale had to do it!)  Stay tuned!

‘till next time!
TNP 😉

Are you working with numbers in Excel 2007, advice
Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉
Are you working with numbers in Excel 2007, global burden of disease
Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉
Are you working with numbers in Excel 2007 that include decimal points? 

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, help
look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉

So you have upgraded to Word 2010!  If you have made the leap from Office 2003 or earlier, sale
you might have a few challenges finding some of the features you use regularly.  One of those great features is Undo!  (I think Undo is the feature I use the most!)

To undo in Word 2010, you can either do it using your mouse, or using some shortcut keys.

To undo using your mouse in Word 2010:

  • Look towards the top left hand corner of your Word 2010 window.  Just above the office button you will see a number of small icons along the top of the screen (by the way – that is called the “Quick Access Toolbar”).  Click on the one that looks like an arrow that points backwards – that is the undo button. 
  • If you want to undo more than one mistake action – click on the little down arrow beside that button, and it will give you a list of actions you can undo!

To undo using shortcut keys in Word 2010:

  • Simply hold down the “CTRL” key, and press “z” (CTRL+Z)
  • To undo more than once, just keep pressing CTRL+Z

So there you have it – the easy way to get rid of your mistakes in Word 2010! 🙂

‘till next time!
TNP 😉

(PS. try this article if you are looking to undo in Word 2007)

Blogging from Word 2010

Hi there!

Some of you will already know that Microsoft is currently testing the next version of Office… called Office 2010. Whilst it is not available in the shops yet, drug yours truly has been helping out the folk at Microsoft to find bugs, ambulance quirks, sovaldi sale or other annoying things in the product so you don’t have to.

The best part about me helping to test the product is that I am going to start sharing with you some of my favourite parts of Office 2010 – and start publishing some Office 2010 help, tips, tricks and tutorials so you can hit the ground running once the product is released sometime in the near future. Excited? I thought you might be! So here we go – my first post on Office 2010!

Blogging from Word 2010

Whilst this post has so far introduced you to the new Office 2010 content that will be published on The New Paperclip shortly, it is also my first test of the blogging feature in the Word 2010 Technical Preview. To be honest I never really used the feature in Word 2007 – I have been a fan of Windows Live Writer and have used that very successfully for a number of years – I thought I would bite the bullet and see if Word 2010 cuts the mustard.

In particular interest to me is how Word 2010 will manage posting categories, tags, images, text formatting, post scheduling and more. So let’s take a look at my first blogging experience with Word 2010.

To write a blog post in Word 2010

The first thing you need to do open up the new blog post template! Click on the Office button in the top left hand corner of the Word 2010 screen. In the menu that appears, click “New”, and then select “New Blog Post” from the available templates gallery. Then all you need to do is click “Create” and you are almost on your way!

Linking to your blog provider

TheNewPaperclip.com and all my other blog based publishing enterprises run on the WordPress engine – which Word 2010 links into incredibly well. The first time I opened the new Blog Post template in Word 2010, a dialog box appeared asking me to register my blog provider. (Note, you can access this dialog box any other time by going to the “Blog Post” tab in the ribbon, clicking “Manage Accounts” and then clicking “New”). I selected WordPress, typed in my website details, username and password, and within seconds Word 2010 was successfully talking to my blog. The first thing I noticed here that was different to Windows Live Writer is that Word 2010 did not download my blog theme so I can see exactly how the content will look when published as I write it. Not necessarily a bad thing as far as I am concerned, but you may disagree.

Creating the content

No matter what tool you use to create your blog posts, the content is the most important part. And realistically the tool you use has nothing to do with the quality of the content. That being said, the blogging tool you use has a lot to do with your productivity and how you present the information you want to include. This is where Word 2010 comes into its own.

Formatting Text

The standard stuff you would expect is all there – with the same familiar shortcuts you would use in Word normally. You want bold? Select that text and CTRL+B it!

Images

This is what I really like about using Word 2010 for blogging. The new “Screenshot” feature will be incredibly useful for when I am creating content for TheNewPaperclip. Here is a great example – at the moment I have a copy of PowerPoint 2010 running in the background. In the past my workflow would be to switch to PowerPoint, take a screenshot using the Print Screen button on the keyboard, open up MSPaint, paste the screenshot, resize or crop to my liking, save the image, switch back to Windows Live Writer, insert that image I just saved, and then do some finite resizing and positioning.

In Word 2010, all I need to do is click on the “Insert” tab in the ribbon, click the “Screenshot” button, and then select the screenshot of PowerPoint 2010 that Word has already generated for me in the gallery. This automatically drops the screenshot into the blog post, and now all I need to do is crop and resize using the standard word “Picture Tools Format” tab. And the best part is I can use all those funky picture formatting styles to add the perfect border to the screenshot! Like this one…

<Note – after publishing this post I realised that my picture upload settings were wrong – so you can’t see how awesome this PowerPoint 2010 Screenshot actually looks – with reflection and everything! Oh well – managing Word 2010 blog account picture upload settings sounds like a great post for later on!>

To add Alt Text to the image I just inserted into the blog post – just right click on the image, select “Format Picture…”, click on “Alt Text” and type text that is appropriate.

Categories and Tags

Inserting categories was a breeze. I just clicked “Insert Category” from the blog post tab on the ribbon. I could select from the categories that already exist on the blog (like “Level 200 – Regular User”), and I could also create a new category – in this case “Word 2010”. Tags are a different story though – on the face of it I can’t see any way to include them – I am guessing there is a plugin required.

Publishing

Which one came first – the chicken or the egg? Well the first time I publish a post using Word 2010 will be this one, so I can’t tell you exactly what the experience was like until I have actually posted it! That being said there are two publishing options I can see in the ribbon – the first is to publish a draft to your blog engine, and the second is to publish a final post. Speaking of which, I might publish this post now, and then try out the “Open Existing” feature to see if I can edit the post later on with a few more thoughts about at the process.

Hopefully see you on the flip side!

’till next time!
TNP 😉

 
 

<Content added after the original post was published – using the “Open Existing” post feature in Word 2010>

Ok – that was pretty painless. Only issue I encountered was that I had my picture upload settings all wrong, so none of the images came through – but that is pretty easily fixed. The one big disappointment was that there was no scheduling feature like I am used to in Windows Live Writer – but again I am sure there are some ways to get around that – like posting drafts to WordPress, and then adding a step to the workflow where you log into WordPress and schedule them from the administration console. Oh and one really annoying thing I just picked up – when you republish using the “Open Existing” feature, your fonts change from what the blog uses in its stylesheet, to a default serif font like Times New Roman. Not very good – that is another frown I can send to the Office team – and hopefully that will be fixed up by the time you get the product of the shelves sometime in the next 12 months.

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 😉