Loading...

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

197,698 views

Loading...

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Sep 2, 2012

Download File: http://people.highline.edu/mgirvin/Ex...
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

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...