Download Excel File: [ Ссылка ]
Download pdf Notes: [ Ссылка ]
Entire Class Web Site: [ Ссылка ]
In this video learn how to apply Excel’s Golden Rule to build efficient Excel Formula Solutions & Excel Models.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:22) Excel’s Golden Rule
3. (02:17) What If Analysis (First Discussion)
4. (02:49) What is an Excel Model
5. (03:13) Example #1: Build Student Extra Credit Score Table
6. (07:08) What If Analysis Example
7. (08:01) Example #2: Build Month Expense Multi-step Calculation Table
8. (17:29) Excel Model Example
9. (20:19) Example #3: Create a Payroll Table
10. (25:15) Why Excel’s Golden Rule is so Important
11. (29:25) Summary
Next Video: Excel & Business Math 04:
Research on causes of Excel errors: [ Ссылка ]
