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: http://ift.tt/2yvldZw
Download Full Written Notes: http://ift.tt/2x4QWzr
Class web page link: http://ift.tt/2kPyedk
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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.