Advanced Excel

Here is a description of the class from the college course catalog:

"For all of its analytical power, it has been observed that 90% of all users of Microsoft Excel use it to keep simple lists. Microsoft has recognized that and has built in very useful functions specifically for lists, but a list in Excel has a special meaning and definition. Jerry Matson teaches what a list is and how to organize, sort, filter, and report on various lists of information using data filters, VLOOKUP, and pivot tables."

Here is a link to the class notes handout: Class Notes - Advanced Excel - Lists

Here is a link to the main presentation: Advanced Excel - The Power of Lists