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 2007

	98.1 % recommend us
	More live stats...

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

Training information:

Excel 2007

Resolved · Low Priority · Version 2007

Reply Wed 26 Aug 2009, 14:10Delegate Sally said...

Sally has attended:
Excel Introduction course
Excel Intermediate course
Powerpoint Intermediate Advanced course

Excel 2007

How do I format data labels?

For upcoming training course dates see: Pricing & availability

Reply Wed 2 Sep 2009, 13:41Trainer Amanda said...

RE: Excel 2007

Hello Sally

Thank you for your question.

If you select one of the data labels, then right-click and select Format Data Labels from the shortcut menu, you will have all the options for working with the data labels available to you.

Kind regards
Amanda

Reply Wed 2 Sep 2009, 14:09Trainer Jacob said...

RE: Excel 2007

Hi Sally

Thanks for your post.

You can find more information on data labels from your course reference material you received on your attendance of our Excel Introduction course, and also by searching the forum for previous related posts.

Regards

Jacob

Wed 9 Sep 2009: Automatically marked as resolved.

Excel articles

· Flexible uses for Excel at Home
· Inviting Investment Into Your Business Can Be Easier With Excel
· How To Use Excel To Track Your Weight Loss
· The Key Settings In Excel 2003's Options Panel
· How To Make Excel Open A Particular File When It Launches

Please browse our web site to find out more about
microsoft+excel+training+course 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