Completed
5-1. Format, layout, and design: Basic formatting
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for Beginners
Automatically move to the next video in the Classroom when playback concludes
- 1 1-1. Introduction: Welcome to Excel for Beginners
- 2 1-2. Introduction: What is Excel
- 3 1-3. Introduction: How to get Excel
- 4 2-1. Main interface: Start screen
- 5 2-2. Main interface: Workbook and worksheet
- 6 2-3. Main interface: Tabs and ribbon
- 7 2-4. Main interface: Navigate through a worksheet
- 8 2-5. Main interface: Navigate through a workbook
- 9 2-6. Main interface: Help
- 10 3-1. Enter data: Numbers
- 11 3-2. Enter data: Column width and row height
- 12 3-3. Enter data: Dates and times
- 13 3-4. Enter data: Select cells to enter data quickly
- 14 4-1. Save workbook: Save workbook
- 15 4-2. Save workbook: Benefits of saving a workbook in the cloud
- 16 5-1. Format, layout, and design: Basic formatting
- 17 5-2. Format, layout, and design: Tables
- 18 5-3. Format, layout, and design: Insert rows and columns
- 19 5-4. Format, layout, and design: Copy and move
- 20 5-5. Format, layout, and design: Conditional formatting
- 21 5-6. Format, layout, and design: Hide rows and columns
- 22 5-7. Format, layout, and design: Find and replace
- 23 6-1. Formulas and functions: Status bar for basic metrics
- 24 6-2. Formulas and functions: Enter a basic formula with addition and subtraction
- 25 6-3. Formulas and functions: Repeat formulas
- 26 6-4. Formulas and functions: Relative and absolute references
- 27 6-5. Formulas and functions: Division
- 28 6-6. Formulas and functions: Order of operations
- 29 6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE
- 30 6-8. Formulas and functions: VLOOKUP function
- 31 6-9. Formulas and functions: XLOOKUP function
- 32 7-1. Charts: Insert and format charts
- 33 7-2. Charts: Analyze data to generate charts
- 34 8-1. Sorting and filtering: Sort
- 35 8-2. Sorting and filtering: Filter
- 36 8-3. Sorting and filtering: Worksheet views
- 37 9-1. Pivot tables: All about pivot tables
- 38 10-1. Flash fill: Separate and merge data using flash fill
- 39 11-1. Adjust worksheet views: Freeze panes
- 40 11-2. Adjust worksheet views: Split panes
- 41 12-1. Multiple worksheets and workbooks: Rename and color worksheets
- 42 12-2. Multiple worksheets and workbooks: Add and delete worksheets
- 43 12-3. Multiple worksheets and workbooks: Hide and unhide worksheets
- 44 12-4. Multiple worksheets and workbooks: Move and copy worksheets
- 45 12-5. Multiple worksheets and workbooks: Worksheet groups
- 46 13-1. Share and collaborate: Protect worksheet
- 47 13-2. Share and collaborate: Protect workbook
- 48 13-3. Share and collaborate: Password protect workbook
- 49 13-4. Share and collaborate: Share workbook
- 50 13-5. Share and collaborate: Version history
- 51 14-1. Print: Print selection
- 52 14-2. Print: Set print area
- 53 14-3. Print: Hide column
- 54 14-4. Print: Page settings
- 55 14-5. Print: Adjust columns
- 56 14-6. Print: Repeat headers
- 57 14-7 Print: Headers and footers
- 58 14-8. Print: Show gridlines
- 59 14-9. Print: Page break view
- 60 15-1. Wrap up: Wrap up
