Differences

This shows you the differences between two versions of the page.

--- supp:excel_for_scientists:start [2015/10/28 20:18] – [Excel and VBA Tutorials] admin
+++ supp:excel_for_scientists:start [2015/11/26 12:26] (current) – [PDFs from Excel Help System] admin
@@ Line 11: / Line 11: @@
 ===== 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 ====
-  * :-) [[http://www.excel-vba-easy.com/|Excel Easy]], a **great** and comprehensive tutorial on Excel and VBA for Excel. They provide a couple of sections on [[http://www.excel-easy.com/vba.html|VBA]].
+  * :-):-):-) 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 ====
+==== Youtube Videos on VBA for Excel ====
-  * [[https://www.youtube.com/watch?v=eI_7oc-E3h0&index=1&list=PLjT_MIUPIOA9ySAtvcQw1TJ0GaWKhUuJN|Excel 2010 Tutorial For Beginners]]  playlist
+  * :-) [[https://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR|Excel VBA is fun]] playlist
-  * [[https://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR|Excel VBA is fun]] playlist
-  * [[https://www.youtube.com/user/excelisfun|Ecel is fun]] playlist, overwhelming selection of Excel videos (not so much VBA)