05.10.11……Too many spreadsheets, not enough screen!

 Bob posts:  This tip will help you view multiple spreadsheets at the same time without resizing each worksheet.

 Excel 2003:

  1. Click Window
  2. Click Arrange

Continue reading

04.29.2011……Conditional Formatting

Beta Omega Beta posts:  I think excel 2003 has this, but you are limited to 1 or 2 conditionals formats versus more than 1 or 2 in 2007.  Yes, in 2007’s product features it says more than 1 or 2 conditional formats.

So what is the benefit?  Conditional formatting is like filtering, but without the filter.  There have been times where I continuously flip back and forth between filters trying to compare what is going on in one section versus the other.

Continue reading

04.29.2011…….Finding Formulas Fast!

Bob postsAre you tired of feeling like you are playing BINGO while tracking down the cells that compose a formula in your spreadsheet?  Well, you’re going to love this tip!  It is called Trace Precedents and Trace Dependents.   Continue reading

  • TELCO TALK

    Telco wisdom, ramblings, vents, accolades and accomplishments of the Atlanta Audit Center. Talking Telco 24-7!
  • July 2017
    M T W T F S S
    « Oct    
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
  • Archives