Archive for November, 2006

Do you love creating documents that are full of pictures?  Are you sick and tired of the same old Clip Art that comes included with Word?  Do you need more Clip Art for Word 2007, PowerPoint 2007, Publisher 2007, or any of the Microsoft Office 2007 programs? 

You are in luck!

Microsoft have a website that has over 150,000 (that’s one hundred and fifty THOUSAND!) free images and sounds that you can add to your documents, spreadsheets, or Publisher creations.

To search through the extensive online FREE Clip Art library, all you need to do is go to the Clip Art page on Microsoft Office Online, and type your search into the box at the top of the screen!

[tags]Clip Art, Office 2007, Stock[/tags]

Have you upgraded from Excel 2003 to Excel 2007 but are unsure where some of your favourite commands are in the new ribbon user interface?  Don’t worry… here is a quick guide for some of my (and hopefully your) favourite Excel commands:

1. Create a New Spreadsheet in Excel 2007
   Click on the Microsoft Office button (the circle in the top left hand corner of the screen), and select new
2. Insert Rows in Excel 2007
   Click on the ‘Home’ tab of the Ribbon, and then in the ‘Cells’ group, click ‘Insert’, and then click on ‘Insert Rows’
3. Check Spelling in Excel 2007
   Click on the ‘Review’ tab of the Ribbon, and then in the ‘Proofing’ group, click ‘Spelling’.  Or you could use the shortcut key, which is F7
4. How to AutoSum in Excel 2007
   First select the cells that you want to AutoSum, and then click on the ‘Home’ tab, look in the ‘Editing’ group, click ‘Sum’, and then click ‘Sum’
5. Save your Spreadsheet in Excel 2007
   You can either click on the Microsoft Office Button (the circle in the top left hand corner of the screen) and select Save (or Save As), or you can click on the Save button in the Quick Access Toolbar (you can find the Quick Access Toolbar in the top left hand corner of the screen, just near the Microsoft Office button.)

Do you want to know where all your other favourite Excel 2003 commands are hidden (I mean where your favourite buttons can be found!)?  Microsoft have put together a great tool to help you out.  You can find the Interactive Excel 2003 to Excel 2007 command reference guide on the Microsoft Office website

’till next time

TNP  

[tags]Excel 2007, Office, 2007, Help, Tutorial, Command Reference[/tags]

Are you a teacher, student, or home user of Office, and want to upgrade or buy a full version of Office 2007?  Microsoft Office Home and Student 2007 is probably the best version for you.  Why?  Well it is cheaper than most of the other office suites, but includes all the programs you are most likely to use every day.

What programs are included in Microsoft Office Home and Student 2007?

There are four different programs which come with Home and Student edition.  They are:

• Word 2007
  For all your word processing, typing, document creation needs.  Great for school, college or university homework and assignments.
• Excel 2007
  Covers all your number crunching spreadsheet needs.  Great for creating graphs and reports for your homework or assignments
• PowerPoint 2007
  Enables you to create your own presentations.  Capture your ideas, and share them with an audience.  Again great for homework or assignments where you need to present in front of a class or audience
• OneNote 2007
  OneNote is great for taking notes, jotting down information, and keeping track of things.  Just like a paper notebook, except electronic!  Again fantastic for school, college of university, as you can keep your research notes all in one place.

Microsoft Office Home and Student 2007 (along with all other Microsoft Office suites, and individual products) will be available in late January, and will cost around USD$150

TNP

I am sure as soon as you thought about upgrading to Office 2007 and looked at the options available, you thought – “dang it, this is going to be hard work deciphering exactly what version (or SKU) of Office I should buy.“ 

Well let me save you the hassle and let you know exactly what you are getting when you purchase Microsoft Office Professional 2007:

• Word 2007
  For all your word processing / document reading and creation needs
• Excel 2007
  For crunching the numbers
• PowerPoint 2007
  For presenting information to your peers
• Outlook 2007 (with Business Contact Manager)
  To keep in touch with your colleagues through email (and keep track of customer details using the Business Contact Manager)
• Access 2007
  To build databases to store your important business data
• Publisher 2007
  To produce professional looking documents, marketing collateral, reports, business cards, banners, signs, websites etc.
• Accounting Express 2007
  To make managing the finances of your small business (or your EBay empire!) easy

There are two different versions of Microsoft Office Professional 2007 that you can buy.  The first is a full version of the product, which you need to buy if you do not currently have a version of Office on your computer. 

If you currently use Office on your computer, then you can purchase the UPGRADE version, which is a lot cheaper!

Love to see comments like this one I received today!

“I love your website! You make changing to Office 07 much more better with all your tips and stuff. The way you say it makes me understand, and get the idea more better. Thanks!” – Michael, Houston, USA

Keep the comments coming, and let me know what you want me to write about.  I now have my hands on a RTM copy of Office 2007 Professional, so I will be pumping more Office 2007 Tips, Tricks and Tutorials in the coming weeks.

Cheers,

TNP

Exciting news!!!  My sources at Microsoft have all been spruiking that Microsoft Office 2007 has now reached the magic milestone that is RTM.

If you are a MSDN subscriber, you can expect the gold code to be available in the next few days.

If you are a consumer, we still need to wait until early next year to purchase Microsoft Office 2007 from the shops!

So now that Office 2007 is available, are there any areas that you need me to cover?  Over the next week or two I think I will get back to basics and build tutorials that cover the products (Word 2007, Excel 2007, PowerPoint 2007 and Outlook 2007 to start with) from the ground up!

If you have any suggestions… please leave a comment and let me know.

TNP

[tags]Office 2007, RTM, Tutorial[/tags]