Differences

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

--- supp:excel_for_scientists:start [2015/10/28 20:11] – [Youtube Videos] admin
+++ supp:excel_for_scientists:start [2015/11/26 10:34] – [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
+  * :-):-):-) 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]].
-==== Youtube Videos ====
+  * :-) http://www.excelfunctions.net/Excel-VBA-Tutorial.html
-  * [[https://www.youtube.com/watch?v=eI_7oc-E3h0&index=1&list=PLjT_MIUPIOA9ySAtvcQw1TJ0GaWKhUuJN|Excel 2010 Tutorial For Beginners]] Youtube playlist
+==== Youtube Videos on Excel (mostly non-VBA) ====
-==== Video Tutorials, Youtube Channels ====
+  * :-) [[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)
-=== Excel VBA is fun ===
-  * [[https://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR|Excel VBA is fun]] playlist
+==== Youtube Videos on VBA for Excel ====
+  * :-) [[https://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR|Excel VBA is fun]] playlist
@@ Line 41: / Line 61: @@
   - [[http://www.youtube.com/watch?v=_sbTZ3aGDpY|Excel VBA Beginner Tutorial - Paste & Sort]]
-=== Youtube Channel "Excel is fun" ===
-  * https://www.youtube.com/user/excelisfun