Excel for Accounting and Finance - Northwest Accounting Educators Conference 2012 - NAE 2012

Download File: http://people.highline.edu/mgirvin/ExcelIsFun.htm In this video Mike excelisfun Girvin presents these topics: 1. Efficiently Create Budget Using Mixed Cell References ( 1:11 minute mark) 2. Conditionally Format Row Using Mixed Cell References ( 11:50 minute mark) 3. Conditionally Format MIN / MAX Values In Each Row (Mixed Cell References) ( 17:07 minute mark) 4. SUMPRODUCT Function To Calculate Expected Value ( 21:33 minute mark) 5. SUMPRODUCT Function To Calculate Weighted Grades ( 25:06 minute mark) 6. SUMPRODUCT Function To Calculate Budgeted Income Statement ( 27:23 minute mark) 7. SUMPRODUCT Function To Calculate Weighted Average From Transactional Data ( 30:05 minute mark) 8. VLOOKUP Basics ( 38:55 minute mark) 9. VLOOKUP & MATCH Functions To Do Two-Way Lookup ( 45:21 minute mark) 10. VLOOKUP & MATCH Functions To Retrieve Record and Display Vertically or Horizontally ( 49:22 minute mark) 11. VLOOKUP For Variable Tax or Commission Calculation ( 51:55 minute mark) 12. Grade Table Subtract Two Lowest Before Assigning Decimal Grade ( 56:35 minute mark) 13. Array Formula: INDEX & MATCH Functions To Lookup First Value ( 01:02:08 hour/minute mark) 14. Array Formula: LOOKUP Function To Lookup Last Value ( 01:09:25 hour/minute mark) 15. PivotTable For Yearly Percentage Change Calculations ( 01:13:47 hour/minute mark) 16. PivotTable For Running Total ( hour/minute mark) 17. PivotTable For Cross Tabular Calculations & % of Row & % of Column Calculations ( 01:20:06 hour/minute mark) 18. Creating & Using Defined Names With Keyboard ( 01:27:45 hour/minute mark) 19. Recorded Macro For Variable Height Tables: Using Relative & Absolute Cell References ( 01:32:47 hour/minute mark) 20. Number Formatting For Formula Inputs ( 01:44:38 hour/minute mark) Northwest Accounting Educators Conference 2012 NAE 2012 Conference Pivot Table PivotTable