====== Excel for Scientists ======



===== Excel for Scientists and Engineers =====

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



===== General Introduction to Excel and VBA =====

==== PDFs from Excel Help System ====

=== Worksheet Lookup Functions ===

  * {{:supp:excel_for_scientists:excel_help_ws_fun_lookup_fun_list.pdf|List of lookup functions}}

  * {{:supp:excel_for_scientists:excel_help_ws_fun_match.pdf|MATCH()}}
  * {{:supp:excel_for_scientists:excel_help_ws_fun_vlookup.pdf|VLOOKUP()}}
  * {{:supp:excel_for_scientists:excel_help_ws_fun_hlookup.pdf|HLOOKUP()}}
  * {{:supp:excel_for_scientists:excel_help_ws_fun_lookup.pdf|LOOKUP()}}
  * {{:supp:excel_for_scientists:excel_help_ws_fun_index.pdf|INDEX()}}
  * {{:supp:excel_for_scientists:excel_help_ws_fun_indirect.pdf|INDIRECT()}}

==== Sample Applications ====

  * [[:supp:excel_for_scientists:interpolation]]

==== Excel and VBA Tutorials ====

  * :-):-):-) A **great** and comprehensive [[http://www.excel-easy.com/vba.html|tutorial on VBA for Excel]] from [[http://www.excel-vba-easy.com/|Excel Easy]].

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

==== Youtube Videos on Excel (mostly non-VBA) ====

  * :-) [[https://www.youtube.com/watch?v=eI_7oc-E3h0&index=1&list=PLjT_MIUPIOA9ySAtvcQw1TJ0GaWKhUuJN|Excel 2010 Tutorial For Beginners]]  playlist
  * [[https://www.youtube.com/user/excelisfun|Excel is fun]] playlist, overwhelming selection of Excel videos (not so much VBA)



==== Youtube Videos on VBA for Excel ====

  * :-) [[https://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR|Excel VBA is fun]] playlist 


=== Youtube Channel of VBA4Excel ===

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


  - [[http://www.youtube.com/watch?v=t1vdt0FddsE&list=PL78571089A2F941BD|Excel VBA Beginner Tutorial - Fundamentals]]
  - [[http://www.youtube.com/watch?v=S_bzZpTVmLc&list=PL78571089A2F941BD|Excel VBA Beginner Tutorial - Sorting Data]]
  - [[http://www.youtube.com/watch?v=xtgmhhKZlNM&list=PL78571089A2F941BD|Excel VBA Beginner Tutorial - Introduction to the Visual Basic Editor]]
  - [[http://www.youtube.com/watch?v=qAYGd7IyXfw&list=PL78571089A2F941BD|Excel VBA Intermediate Tutorial - Referencing Cells]]
  - [[http://www.youtube.com/watch?v=NwKkGOpxAbI&list=PL78571089A2F941BD|Excel VBA Intermediate Tutorial - Making Decisions]]
  - [[http://www.youtube.com/watch?v=NTfa1kpLX-0|Excel VBA Intermediate Tutorial - Introduction to Loops]]
  - [[http://www.youtube.com/watch?v=Qw49th_5ZDU|Excel VBA Intermediate Tutorial - Creating User Defined Functions]]
  - [[http://www.youtube.com/watch?v=_sbTZ3aGDpY|Excel VBA Beginner Tutorial - Paste & Sort]]