excel training

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

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

Excel Training

resolvedResolved · Low Priority · Version 2007

Angie has attended:
Excel Intermediate course

Excel Training

How can I fix the error formulas?

RE: Excel Training

Hi Angie

Thanks for the post, sorry i have not got back to you before now

The first thing to do if you have an error is trace back the error to find out where the problem is, using the auditing area of the formulas ribbon - then by trace precedents and dependants you will be able to pin point the problem and then hopefully fix it but it will depend on the error itself - if you have an error you would like me to look at please reply or attach it to this post


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.09 secs.