Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Kevin has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course

Excel 2007

What are the main differences between Excel 2003 and 2007

RE: Excel 2007

Hi Kevin,
Thank you for your question;
In reply: The major difference between the two incarnations is in the user interface... the look of it. Functionality has changed slightly in some places, but the usage of formulae and functions is still the same. Most of 2003's operations and dialog boxes can be accessed by using the right click. The biggest change is in the graphics area (charts and drawing) this has been revamped quite considerably. The Interface is a bit of a problem to 'get your head around' intitially but is quite user friendly and once you get used to it you wonder what all the noise was about... without going into reams of information about the changes which you can see for yourself I hope that has helped...Pete

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.