Tutorials for more difficult Excel topics

Please read the written description of each topic. Also watch one video on each topic if you would like.

Topic Written Description (choose at least 1 of each) Video
Cell References:

short general - please read this one

text describing cell references entry for Excel 2007 - takes a while to load - not required

text describing cell references entry for Excel 2003:- takes a while to load - not required

good simple video:

If Statement: simple description - short- please read this one

 

video describing the if statement

 

Charts: Excel 2003 chart wizard - click on next at bottom of the screen you will see to read all - please read this one or the one below

Excel 2007 charting - very basic - please read this one or the one above

Excel 2007 charting - more details - look at lesson 4 OR try this one which is a bit simpler

Advanced list of many types of charts you can create in Excel

video to show simple chart wizard in Excel 2003

video to show simple chart wizard in Excel 2007

video to show charting, but is a little long