Sunday, October 21, 2007

Note to Excel Users:

Top 10 Excel Functions/Tips:
  1. pivot tables
  2. VLOOKUP()
  3. defining named dynamic ranges with OFFSET()
  4. MATCH() -- like HGH for VLOOKUP()
  5. autofilter
  6. create easy html tables with concatenation
  7. escape characters in text strings: ", '
  8. Solver (Beirut rankings!)
  9. TEXT()
  10. imbed flash games that are banned by internet filters
Beep Excel Rulz Beep

No comments: