Download workbook: people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm
Topics in this video:
1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list (00:27 min)
2. Sort Dialog Box to get records to top (02:43 min)
3. Is Item in List 2 NOT in List 1? Use MATCH and ISNA. Comparing Library database list of books to the list of items found in inventory count. (03:36 min)
4. IF, ISNA and MATCH functions to show "Missing" when book from library shelves is missing (05:20 min)
Compare two columns, Compare 2 columns, Compare 2 lists, compare two lists, compare two lists of items. Match two columns, Match 2 columns.
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.
Be sure to download the workbook to follow along with the examples. They are found on the official course website.