User Tools

Site Tools


supp:excel_for_scientists:start

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
supp:excel_for_scientists:start [2015/10/29 14:50] – [Youtube Videos on Excel] adminsupp: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 ===== ===== 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 ==== ==== 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   * :-) http://www.excelfunctions.net/Excel-VBA-Tutorial.html
-  * :-) [[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]]. 
  
 ==== Youtube Videos on Excel (mostly non-VBA) ==== ==== Youtube Videos on Excel (mostly non-VBA) ====
supp/excel_for_scientists/start.txt · Last modified: 2015/11/26 12:26 by admin