Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Finished File: Download File: http:\/\/ift.tt\/2yvldZw
\nDownload Full Written Notes: http:\/\/ift.tt\/2x4QWzr
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (00:25) Goal of video
\n3. (03:07) Type labels for Net Income Projection Table and Assumption Table
\n4. (07:18) Add Stylistic Formatting
\n5. (09:00) Enter Formula Inputs
\n6. (09:35) Format Cells Dialog Box using Ctrl + 1
\n7. (13:43) Start Revenue Formula (we are not copying this formula anywhere)
\n8. (14:12) Revenue Increase Formula (uses Relative and Absolute Cell References):
\n9. (15:50) Why Percentage Revenue Increase Formula is TRUE
\n10. (19:26) The Beauty of Excel
\n11. (20:23) Expense Formula (uses Relative and Absolute Cell References)
\n12. (22:15) Why Expense Formula is TRUE
\n13. (22:30) Net Income Formula (uses two Relative Cell References)
\n14. (24:05) Insert Chart: Column Chart
\n15. (25:03) Move and Resize Chart
\n16. (26:12) Format Chart with Green Plus
\n17. (27:00) Discuss Chart Junk
\n18. (27:44) Delete Chart Elements
\n19. (28:22) Open Chart Formatting Task Pane with Ctrl + 1
\n20. (30:36) Link Chart Title to Cell
\n21. (32:56) Use Alt Key to Snap Chart to Grid
\n22. (32:26) Excel\u2019s Golden Rule
\n23. (32:26) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update
\n24. (34:26) Page Setup
\n25. (36:56) Summary<\/p>\n