Highline Excel 2013 Chemistry Video #1: Basic Excel: Data Entry, Formatting, Charting & Formulas

Download Files (Excel File is at VERY BOTTOM of page (use Ctrl + End to jump to bottom):
For Highline College Chemistry Class, learn how to:
1. (01:23 min mark) Insert Symbol
2. (02:25 min mark) Word Wrap
3. (03:00 min mark) Stylistic Formatting
4. (03:52 min mark) Enter Raw Data
5. (04:40 min mark) Number Formatting
6. (06:10 min mark) How to Create Charts in Excel 2013
7. (06:47 min mark) X-Y Scatter Chart
8. (07:15 min mark) Proper Labels on Charts
9. (08:10 min mark) Link Labels to Cells
10. (10:11 min mark) Rotate Label
11. (11:22 min mark) Chart Title
12. (12:10 min mark) Remove Gridlines
13. (13:10 min mark) Number Formatting on X & Y Axes
14. (14:27 min mark) Relationship between x and y
15. (16:04 min mark) Add Linear Trend Line
16. (17:43 min mark) Page Setup
17. (22:52 min mark) SLOPE function
18. (25:12 min mark) INTERCEPT function
19. (26:32 min mark) Make Prediction with formula
20. (28:34 min mark) Create Sequential Numbers: 0, 1, 2, 3…
21.
22. (30:08 min mark) Relative Cell References
23. (30:08 min mark) Absolute Cell References
24. (32:13 min mark) Lock cell references (make Absolute) with keyboard: F4
25. (33:24 min mark) Copy Formula with Double Click
26. (35:10 min mark) RSQ function
27. (36:22 min mark) PEARSON function = CORREL function
Teachers: John Pfeffer, Natalie Bjorge, Tom Flaherty