Archive for June, 2010

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.MS Office 2007 Professional is such a good assistant of the office.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France).MS Office 2007 Ultimate give you more great experience than anything.
  • Spanish (Spain, International Sort)

To turn on Translation ScreenTip:

1) Make sure you are on the “Review” tab of the ribbon.Office 2007 Pro is great! Many people like it!

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, or click on “Turn Off Translation ScreenTip” to turn the translation off. Office 2007 key is available here.

‘till next time!

Are you sick of clicking your mouse, hitting a key, or pressing next on your wireless presenter? Photoshop CS4 is so magic!

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.Acrobat 9 is so useful!

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.Dreamweaver CS4 is very easy-to-use!

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.Many people use Microsoft Office 2007 to help their work and life.

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007. Once you have Windows 7 Professional you love it!

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  The best part of this feature is, 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.Ms office 2007 are so Charismatic.

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. Office 2007 professional and Office 2007 ultimate are my favorite.

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! windows 7 home premium is also my love!

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, and what the email subject is? Office 2007 Pro is great! Many people like it!

Well using the “Auto Preview” feature in Outlook 2007, 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. Office 2007 key is available here.

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

1) Click on “View”

2) Click on “AutoPreview”.Office 2007 enterprise is the expert for the office workers.

 

Simple as that!

Do you want to quickly insert a blank page into your Word 2007 document?  Instead of hitting enter 40 times, why don’t you use the Insert Blank Page button? Many people use Microsoft Office 2007 to help their work and life.

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! MS Office 2007 Professional is such a good assistant of the office.

‘till next time!

Have you ever read a document that has a line like… “See more in section 5.1” or “Refer to figure 8”.MS Office 2007 is the best invention in the world.

Did you know in Word 2007 you can create these cross references, 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, but here is the easy way to create a cross reference in Word 2007.Windows 7 Professional brings people more convenience!

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, 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.Office Professional 2007 and Office Ultimate 2007 are my favorite.

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.windows 7 home premium is also my love!

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.Photoshop CS4 is so magic!

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

‘till next time!

Hi there!

Office 2007 Pro is so great! 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!Microsoft Office 2007  is welcomed by the whole world.

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, 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.Office 2007 professional and Office 2007 Ultimate are so powerfull.
  • Produce Dynamic Presentations with PowerPoint 2010
  • Organize, Store, 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.Office 2007 key is available here.
  • 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. Office 2007 enterprise is the expert for the office workers.

‘till next time!

I have had a lot of feedback from readers of TheNewPaperclip.com, and those that subscribe to the Office 2007 tips newsletter. Office Professional 2007 and Office Ultimate 2007 are my favorite.People are screaming out for short, concise courses that will help them do overcome annoying challenges, and do amazing things with Office 2007. These people – maybe you – have had thoughts like “How do I get Outlook to do this?…”, “How can I get my document to look as great as Jenny’s?…”. “How come everyone says how good Brad’s PowerPoint slides are?” There are plenty of different ways to answer those questions – maybe you have tried some of them, like courses or books. But they are not for everyone: •Maybe you live in a remote area and can’t get to an instructor lead class because the closest one is 1, 2, 3, or even 6 hours away by car. •Maybe you think that reading a bland text book that is 600 pages long is not fun (I AGREE!) •Maybe you just want to interact with someone who will be able to give you the answers you need? windows 7 home premium is also my love!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.Photoshop CS4 is so magic! 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:

TheNewPaperclip.com

Office 2007 Workshops




Select the online workshops you would like to receive more information about:

We respect your email privacy

You might already know about a great feature in Excel 2007 called “Merge and Center”.  Basically it allows you to create a cell that spans across multiple columns – great for headings for example.Office 2007 key is available here.

But sometimes you want to merge the cells – but not centre the text.  That is where “Merge Across” comes in handy.  “Merge Across” does exactly the same as “Merge and Center”, except it keeps the text left justified! 

How good is that!  No more having to change the paragraph alignment!!!

Office 2007 enterprise is the expert for the office workers.

To merge across a number of cells in Excel 2007:

1) Select the cells you want to merge

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

3) Look for the “Alignment” group.MS Office 2007 is the best invention in the world.

4) Click on the small arrow beside “Merge & Center”

5) Click on “Merge Across”

 

To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.Windows 7 Professional brings people more convenience!