Скачать с ютуб Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts в хорошем качестве

Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Finished File: Download File: https://people.highline.edu/mgirvin/Y... Download Full Written Notes: https://people.highline.edu/mgirvin/Y... Class web page link: https://people.highline.edu/mgirvin/A... Buy excelisfun products: https://teespring.com/stores/excelisf... Topics in this video: 1. (00:01) Introduction 2. (00:25) Goal of video 3. (03:07) Type labels for Net Income Projection Table and Assumption Table 4. (07:18) Add Stylistic Formatting 5. (09:00) Enter Formula Inputs 6. (09:35) Format Cells Dialog Box using Ctrl + 1 7. (13:43) Start Revenue Formula (we are not copying this formula anywhere) 8. (14:12) Revenue Increase Formula (uses Relative and Absolute Cell References): 9. (15:50) Why Percentage Revenue Increase Formula is TRUE 10. (19:26) The Beauty of Excel 11. (20:23) Expense Formula (uses Relative and Absolute Cell References) 12. (22:15) Why Expense Formula is TRUE 13. (22:30) Net Income Formula (uses two Relative Cell References) 14. (24:05) Insert Chart: Column Chart 15. (25:03) Move and Resize Chart 16. (26:12) Format Chart with Green Plus 17. (27:00) Discuss Chart Junk 18. (27:44) Delete Chart Elements 19. (28:22) Open Chart Formatting Task Pane with Ctrl + 1 20. (30:36) Link Chart Title to Cell 21. (32:56) Use Alt Key to Snap Chart to Grid 22. (32:26) Excel’s Golden Rule 23. (32:26) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update 24. (34:26) Page Setup 25. (36:56) Summary