Advanced excel tutorial

Linking worksheets

You may want to use the value from a cell in another worksheet within the same workbook in a formula. For example, the value of cell A1 in the current worksheet and cell A2 in the second worksheet can be added using the format "sheetname!celladdress". The formula for this example would be "=A1+Sheet2!A2" where the value of cell A1 in the current worksheet is added to the value of cell A2 in the worksheet named "Sheet2".

Few Links:
http://spreadsheets.about.com/od/advancedexce/Advanced_Topics_in_Excel_Spreadsheets.htm

http://www.beyondtechnology.com/tips.shtml

Creating a Drop Down List in Excel 2007
http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm
http://spreadsheets.about.com/od/datamanagementinexcel/qt/080504dropdown2.htm

Macro tutorial
http://spreadsheets.about.com/od/advancedexcel/ss/excel_macro.htm

vlookup
http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

hlookup
http://spreadsheets.about.com/od/excelfunctions/ss/hlookup.htm

Goalseek
http://spreadsheets.about.com/od/advancedexcel/qt/080802goal_seek.htm

Database
http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm

Removing duplicate records
http://spreadsheets.about.com/od/excel2007tips/qt/data_duplicates.htm

Advanced filter
http://spreadsheets.about.com/gi/dynamic/offsite.htm?zi=1/XJ/Ya&sdn=spreadsheets&zu=http%3A%2F%2Fwww.docnmail.com%2FExcelFilter%2Ffilter4.htm

Import text files
http://spreadsheets.about.com/gi/dynamic/offsite.htm?zi=1/XJ/Ya&sdn=spreadsheets&zu=http%3A%2F%2Fwww.docnmail.com%2FExcelFilter%2Ffilter4.htm

Pivot table
http://video.about.com/spreadsheets/Create-Excel-Pivot-Tables.htm

This will give you an idea of using vb script in excel
http://spreadsheets.about.com/gi/dynamic/offsite.htm?zi=1/XJ/Ya&sdn=spreadsheets&zu=http%3A%2F%2Fwww.contextures.com%2FxlUserForm01.html