In FOCS we will use the book
E. Joseph Billo: Excel for Scientists and Engineers: Numerical Methods. Wiley-Interscience, New York, 2007
Find it in the University library: https://nrwoz2.bib-bvb.de/search?bvnr=HT015099797

• List of lookup functions

• MATCH()
• VLOOKUP()
• HLOOKUP()
• LOOKUP()
• INDEX()
• INDIRECT()

• A great and comprehensive tutorial on VBA for Excel from Excel Easy.

• http://www.excelfunctions.net/Excel-VBA-Tutorial.html

• Excel 2010 Tutorial For Beginners playlist
• Excel is fun playlist, overwhelming selection of Excel videos (not so much VBA)

• Excel VBA is fun playlist

• http://www.youtube.com/user/VBA4Excel/videos

1. Excel VBA Beginner Tutorial - Fundamentals
2. Excel VBA Beginner Tutorial - Sorting Data
3. Excel VBA Beginner Tutorial - Introduction to the Visual Basic Editor
4. Excel VBA Intermediate Tutorial - Referencing Cells
5. Excel VBA Intermediate Tutorial - Making Decisions
6. Excel VBA Intermediate Tutorial - Introduction to Loops
7. Excel VBA Intermediate Tutorial - Creating User Defined Functions
8. Excel VBA Beginner Tutorial - Paste & Sort