Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Start & Finished File: http:\/\/ift.tt\/2yLURpp
\nDownload Full Written Notes: http:\/\/ift.tt\/2maLU35
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (01:15) Example 1: Excel Table feature for VLOOKUP & Data Validation List
\n3. (07:10) Example 2: Excel Table feature for Chart
\n4. (09:45) Example 3: Excel Table feature for PivotTable
\n5. (13:10) Example 4: Excel Table feature for Other Formulas
\n6. (16:50) Example 5: Add New Column to an Excel Table AND Create Approximate Match Lookup Table from a written statement.
\n7. (17:47) Create Approximate Match Lookup Table from Written Instructions
\n8. (24:35) Change Settings to Allow Columns and Rows to be added to Excel Table as you work: Excel File, Options, Proofing, AutoCorrect, Auto Format As You Type, \u201cApply As You Work\u201d \u2013 \u201cInclude New Rows and Columns in Table\u201d
\n9. (26:10) Add columns to Excel Tables with Table Formula Nomenclature with Relative and Absolute References.
\n10. (29:30) Formula for Discounts when we need to calculate Net Revenue based on a Discount.
\n11. (34:14) Add new records to bottom of Excel Table and Formulas will automatically populate down
\n12. (35:05) Summary – Conclusion<\/p>\n