Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: http://ift.tt/2kPLWg5
Download Full Written Notes: http://ift.tt/2xFJdfr
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:30) Excel file = “Workbook”, not “Document”
3. (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers)
4. (02:29) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5. (03:46) Worksheet = Sheet = All the Cells
6. (03:55) Sheet Tab = Name of worksheet and Insert New Sheets
7. (04:18) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
8. (04:18) You can add new sheets with Plus button to the right of the sheets:
9. (05:00) Workbook = All the sheets = File = File Name
10. (05:20) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
11. (05:20) Move Cursor
12. (05:20) Fill Handle = after you select a cell the little black square in the lower right corner.
13. (05:20) Cross Hair or “Angry Rabbit” Cursor
14. (06:45) Entering data or formulas
15. (07:42) Cross Hair or “Angry Rabbit” Cursor Magic
16. (13:22) Default Alignment In Excel:
17. (14:20) Stylistic Formatting examples:
18. (17:22) Select whole table:
19. (18:35) Entering data into a large range of cells
20. (22:05) Formulas
21. (22:05) First Formula using SUM
22. (24:37) Cell References
23. (26:15) AVERAGE Function
24. (34:40) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
25. (42:30) Number Formatting
26. (47:52) Page Setup
27. (58:32) Move Sheet and Copying Sheet:
28. (01:01:47) Summary