Click here to use this awesome interactive tool on the Microsoft Office website

(Please note that you will need to have installed Silverlight player in order to view the interactive guide)

Microsoft have created a fantastic, easy to use tool that allows you to select the menu options as you found them in Word 2003, and the tool will show you where to find the equivalent in Word 2007.

Click here to use this awesome interactive tool on the Microsoft Office website

Find your way round in the Powerpoint 2007 interface…

Microsoft have created a fantastic, easy to use tool that allows you to select the menu options as you found them in previous versions of Powerpoint, and the tool will show you where to find the equivalent in Powerpoint 2007.

Click here to use this awesome interactive tool on the Microsoft Office website

(Please note that you will need to have installed Silverlight player in order to view the interactive guide)

Microsoft have created a fantastic, easy to use tool that allows you to select the menu options as you found them in previous versions of Powerpoint, and the tool will show you where to find the equivalent in Powerpoint 2010.

(Please note that you will need to have installed Silverlight player in order to view the interactive guide)

Microsoft have created a fantastic, easy to use tool that allows you to select the menu options as you found them in previous versions of Excel, and the tool will show you where to find the equivalent in Excel 2010.

Click here to use this awesome interactive tool on the Microsoft Office website

(Please note that you will need to have installed Silverlight player in order to view the interactive guide)

Microsoft have created a fantastic, easy to use tool that allows you to select the menu options as you found them in Excel 2003, and the tool will show you where to find the equivalent in Excel 2007.

Click here to use this awesome interactive tool on the Microsoft Office website

Excel 2007 brings loads of powerful tools into the hands of basic users – which we like. For me, the best bit about 2007 is that it truly feels like Microsoft have built it around user feedback. Every tool I use frequently has been improved and brought to the forefront of the interface

Filters

It is now possible (and very easy!) to filter by date, by colour, and by multiple values

Conditional formatting

Yey, we’re no longer limited to 3 conditional formats per cell! Also, there are some fantastic condtional formatting rules & styles already set up and ready to go – including:

• Highlight blanks
• Highlight duplicates
• Colour scales / heat maps
• Percentage bars
• Traffic lights

…and what makes these options so powerful is using them in conjunction with the new filter by colour and sort by colour options

Countifs and Sumifs

For those of you that used Countif and Sumif in previous version of Excel will LOVE this…

Ever wanted to count all records that match this AND that AND the other criteria?… Well, you’re in luck!

That’s exactly what the new plural countifs and sumifs formulas do – allow multiple criteria to be checked from one function.

Convenience

Code hinting

Whenever you use a name in a function, Excel will auto-complete it and even colour code it so you know its spelt correctly. When you’re writing a function (e.g. an IF statement) and get to a value that has numerous options, Excel 2007 provides a pop-up menu allowing you to select from the possible values. Equally, if you’re referencing a named range, Excel will help auto-complete those names as you type AND colour code and names you type as a quick visual check that what you typed is correct

More power to the right-click menu

Anyone fairly IT literate will know that the right-click menu is both a time-saver and a get out of jail free card – well now it includes all the common formatting tools e.g. bold, italic, alignment, etc… so no more to-ing and fro-ing between the cells you want to format and the toolbars.

The Quick Access Toolbar

This handy tool is a major timesaver and basically allows you to add any tool you like to a convenient ‘shelf’ at the top of the screen. Once added, you’ll never need to dig through menus to find it again!

What’s even better is how easy it is to set up… all you need to do in order to add a tool is simply right-click the tool’s icon and choose Add to Quick Access Toolbar – it’s that easy!

Table formatting

Ever struggled trying to colour alternate rows of a table? It’s now one click away!

The Watch Window

This extremely helpful tool allows you to keep an eye on the value in any specified cells – regardless of where you are in the workbook. Imagine your delving into the minute detail of an individual receipt and want to keep track of the Annual Profit or the Total Receipts Amount, not a problem with Watch Window!