Completed
) Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Introduction to Excel - Formatting, Formulas, Cell References, Page Setup
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Excel file = “Workbook”, not “Document”
- 3 ) Columns (Represented by Letters) and Rows (Represented by Numbers)
- 4 ) Cells = Intersection of Column and Row = Name or Address like B5 or A1
- 5 ) Worksheet = Sheet = All the Cells
- 6 ) Sheet Tab = Name of worksheet and Insert New Sheets
- 7 ) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
- 8 ) You can add new sheets with Plus button to the right of the sheets:
- 9 ) Workbook = All the sheets = File = File Name
- 10 ) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
- 11 ) Move Cursor
- 12 ) Fill Handle = after you select a cell the little black square in the lower right corner.
- 13 ) Cross Hair or “Angry Rabbit” Cursor
- 14 ) Entering data or formulas
- 15 ) Cross Hair or “Angry Rabbit” Cursor Magic
- 16 ) Default Alignment In Excel:
- 17 ) Stylistic Formatting examples:
- 18 ) Select whole table:
- 19 ) Entering data into a large range of cells
- 20 ) Formulas
- 21 ) First Formula using SUM
- 22 ) Cell References
- 23 ) AVERAGE Function
- 24 ) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
- 25 ) Number Formatting
- 26 ) Page Setup
- 27 ) Move Sheet and Copying Sheet:
- 28 ) Summary
