Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel versions

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel versions

Resolved · Low Priority · Version 2007

Reply Tue 8 Jul 2008, 16:39Delegate Dawid said...

Dawid has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Access Intermediate course

Excel versions

What are the main differences between Excel 2003 and 2007?

For upcoming training course dates see: Pricing & availability

Reply Wed 9 Jul 2008, 13:37Trainer Amanda said...

RE: Excel versions

Hi Dawid

Thank you for your question and welcome to the forum.

The main difference between 2003 or 2007 is the interface looks different. In 2007, the menu and toolbars in 2003 have been replaced with a ribbon across the top of the screen.

Also some of the Excel features (e.g. list, conditional formatting) have been expanded on/improved.

You can view and use the 2007 version of Office online at
http://office.microsoft.com/en-gb/products/HA101687261033.aspx

Amanda

Excel articles

· Sorting Birthdates Into Their Respective Months In Excel
· How To Share Files In Excel 2010
· How To Create A Macro In Excel 2010
· Creating Error Alerts In Excel Using Data Validation
· Discover The Secret Of How To Conditionally Format An Excel Chart

Please browse our web site to find out more about
microsoft.excel.courses.in.london and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips