Monday, November 26, 2007

Excel 2003 - online resources

Remember our online video demos of much of what we learn about MS Office at tinyurl.com/i0th, including
* - Linking cells between worksheets
* - Protecting cells to prevent user input
* - Functions - the IF function - the VLOOKUP function
* - Conditional Formatting (formatting cells which meet specified conditions)
* - Data validation
* - Pivot Tables - analyze an Excel database ("list") with a pivot table
* - Scenarios