Friday, November 20, 2009

Excel 2003 -- links

Some of the Excel features you'll be learning are shown in our video tutorials at http://tinyurl.com/i0th.

* Linking cells between worksheets
* Cell Protection
      -- protect cells to prevent user input
* Functions
      -- IF
      -- VLOOKUP
* Conditional Formatting
      -- format cells which meet specified conditions
* Data validation
      -- validate data as it is entered
* Pivot Tables
      -- analyze an Excel database ("list") with a pivot table
* Scenarios
      -- create scenarios
      -- create a scenario summary

The videos show Excel version 2000, not 2003, but there are few significant differences.