• AnnLuck

    I love this series and am looking forward to more advanced tips . . . pivot tables would be nice. =)

  • http://www.architechsw.com pavlicko

    Josh,

    really good explanation of how to use Vlookup – there’s not a day that goes by that I don’t use that..

    A quick note about Paste Special and copy and pasting charts into a word doc – anyone that’s done this probably realizes that office 2007 updates the word doc chart if you modify the excel chart that you copied it from, which can be REALLY annoying.

    To copy and paste a chart from excel into word and NOT have it update when you make changes, use the paste as picture option on the ribbon tab – home page – on the paste dropdown – first copy – then paste as picture into word and you’ll be golden.
    This caused me endless nightmares before I discovered it.