excel consultants - errors

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Errors

excel consultants - Errors

resolvedResolved · Low Priority · Version Standard

Paul has attended:
PowerPoint Intermediate Advanced course
Excel Advanced course

Errors

How can you avoid getting circular errors?

RE: errors

When you create formulas, make sure you are not referencing the cell that the answer is going to.

Alternatively, you can use the FORMULA AUDITING toolbar to assit in locating and solving formula errors.

VIEW > TOOLBARS > FORMULA AUDITING


 

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips


Server loaded in 0.08 secs.