Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Excel Twitters 20080712

Moved to the Excel Twitters archive:

Excel Twitters 20080712

6 comments to Excel Twitters 20080712

  1. Ken Puls
    July 12th, 2008 at 12:59 pm

    "Entering data into excel….I think I missed my calling "

    Wow... I felt like that once... when I was 12! (Take your kid to work day, as I recall.)

    "there is something about watching an Excel macro run that I find entertaining"

    I hope this person just hasn't found "screenupdating=false" part yet... LOL!

  2. Debra Dalgleish
    July 12th, 2008 at 1:26 pm

    Ken, yeah, I wasn't sure if that was love or sarcasm, so let's hope I guessed wrong.
    And sometimes I leave screen updating on, just so people can see that things are happening. The macro runs slower, but at least they know it's still running, and hasn't hung.

  3. Jon Peltier
    July 12th, 2008 at 1:46 pm

    Hmmmmm. All of the items that mention 2007 are in the second category. Did you see any where the commenter liked the new interface?

  4. Debra Dalgleish
    July 12th, 2008 at 2:34 pm

    Jon, good question. After some digging I found this -- about a month ago, someone said, "Having a little more fun than I should be playing with conditional formatting in Excel 2007 at work." So far, that's it.

  5. jarret freedman
    July 14th, 2008 at 9:55 am

    on the article - inserting pictures into comments in excel, does anyone know how to program vba so that the comment automatically takes a picture's address from a cell in the same row and be able to replicate for following rows vs having to manually define the location of the picture for each comment?

  6. Debra Dalgleish
    July 14th, 2008 at 5:07 pm

    Jarret, There's a sample file at the following link, that might help you get started. You can adjust the code to match your folders. Debra
    http://www.contextures.com/excelfiles.html#CM0003

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>