Try before you buy?

It should probably come as no surprise that Microsoft's largesse, as far as offering users a free taste of the beta of Office 2007, was short-lived. The multimillion dollar company is clearly feeling the pinch and if you haven't already downloaded the free trial then you've missed your chance - you'll now have to pay.

Admittedly, it's charging only $US1.50 per download but, given that it's benefited from all the free advice and feedback of existing beta testers, it seems a bit rich to start asking punters to cough up. Microsoft claims that with more than three million copies of the beta downloaded since it became available in May, it has exceeded its target by more than 500 per cent and needs to recoup some of the bandwidth costs by charging for the beta.

It hasn't ruled out offering future free beta copies of software but, if the opportunity arises again, the best advice is to get in quick. Existing beta users can still get free updates to the software, but it is due to be shut down in February 2007, with only limited functionality remaining. This is in line with estimates that the full version of Office 2007 will launch early 2007.

If you'd prefer to wait for the real thing, this month we complete our look at the new features of Office 2007 so you'll know what to expect.

1. Excel Formulae AutoComplete makes it easier to create formulae in Excel. To access it, click on a cell, type and the start of the function, for example 'sub' for subtotal. It'll offer you possible functions; you click on the correct one. You can build a formula or multiple formulae using this method.

2. Excel Conditional Formatting allows you to highlight trends or anomalies within tables. To use conditional formatting, click on the button in the tool ribbon. Choose from the drop-down menus to highlight cells that contain certain features, are above or below a specific numerical value, or create your own rules.

3. PowerPoint allows you to easily apply a theme to a presentation using Smart Art. Select the elements to which you want to apply the theme and click on the 'Convert to Smart Art' button on the tool ribbon. You can then select the theme you want to apply and tailor colours and styles using the Design toolbar.

4. You can now set the resolution of your presentation for the type of display you are using. Click the Slide Show tab, then on the arrow next to the 'Use current resolution' menu. From here you can select the desired resolution of your fi nished presentation. Tips indicate which resolution provides clearer or faster results.

5. Outlook allows you to automatically add a fl agged message to your to-do list. Click the fl ag icon to mark a message for follow-up. You can flag a message to be followed up today or at a future date, create a custom follow up and add reminders. Right-clicking on existing flags pulls up all these options.

6. You can view multiple calendars within Outlook. Click the calendar view and upload other calendars from the Internet using the Browse Calendars Online feature in the left-hand menu. From here you can search for online calendars, automatically upload them and view them side-by-side with your own calendar.


You can assign a password to any Office document when you save it. In Excel, Word and PowerPoint, click Tools-Options and Security to set a password. You can choose to add a password to prevent anyone from opening or modifying the document.

Excel evaluates all operations within a formula using a strict left-to-right order of precedence, unless you use brackets to interrupt this order. If you want a refresher on this order, press <F1> within Excel to access the help files and search for calculation operators. Then click on the About Calculation Operators link.


Outlook 2007 makes sharing calendars and calendar information online simple. But it's not the only way. Planzo provides free online calendars you can share with other members and send reminders of scheduled events to your mobile phone and via e-mail.

Sticky notes are handy but untidy. Simply Stickies 1.5 replicates their usefulness on your desktop, allowing you to 'stick' different coloured reminders on your screen. Notes are automatically saved and displayed at startup. Download a free demo or purchase the full version for $US9.

Forgotten the password for an Office document? Rixler's latest decryption tool, Office Password Recovery Toolbox ($US60) can be used to decrypt up to two Microsoft Word or Excel documents protected with open passwords, and offers unlimited use for other types.

PS Hot Launch VVL allows you to launch applications quickly from a menu in the system tray and quick launch applications using hotkeys. Use customised hotkeys to insert frequently used text, change the volume or control any other common feature. It's available as a free download.

Join the PC World newsletter!

Error: Please check your email address.

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Ursula Seymour

PC World
Show Comments


Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >


Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >


Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >


Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles


GGG Evaluation Team

Kathy Cassidy


First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni


For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Steph Mundell


The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.

Andrew Mitsi


The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.

Simon Harriott


My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?