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.


TIPS & TRICKS

PASSWORD-PROTECTING OFFICE DOCUMENTS
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 CALCULATION OPERATORS
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.


HELPFUL DOWNLOADS

TIMELY REMINDERS
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. www.planzo.com

STICKY STUFF
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. www.wellcraftedsoftware.com

PASSWORD PROMPTS
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. www.rixler.com

LIGHTNING LAUNCHES
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. www.pssoftlab.com


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

Essentials

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

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

Learn more >

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

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?