206,250 views 191 on YTPak
1,030 29

#### Published on 03 Sep 2012 | over 5 years ago

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
Customize Your Hybrid Embed Video Player!

6-digit hexadecimal color code without # symbol.

Report video function is under development.