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

course

ResolvedVersion 2007

Hilary has attended:
Excel Intermediate course

Course

What iscovered in an advanced Excel 2007 course be?

RE: Course

Hello Hilary

Thank you for your question and welcome to the forum.

Please find below a link to a similar question from another delegate, which I have posted an answer to:
https://www.stl-training.co.uk/post-22968-advanced-excel-course.html #22968

Kind regards
Amanda

Tue 23 Jun 2009: Automatically marked as resolved.

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

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.41 secs.