Excel for Beginners

Learn the essentials of Excel in only 2 hours. We start with the basics & then advance to formulas & functions, charts & pivot tables. By the end, you'll have a strong foundation in Excel & will understand the story behind your data.

60 videos · Kevin Stratvert

• 1-1. Introduction: Welcome to Excel for Beginners
• 1-2. Introduction: What is Excel
• 1-3. Introduction: How to get Excel
• 2-1. Main interface: Start screen
• 2-2. Main interface: Workbook and worksheet
• 2-3. Main interface: Tabs and ribbon
• 2-4. Main interface: Navigate through a worksheet
• 2-5. Main interface: Navigate through a workbook
• 2-6. Main interface: Help
• 3-1. Enter data: Numbers
• 3-2. Enter data: Column width and row height
• 3-3. Enter data: Dates and times
• 3-4. Enter data: Select cells to enter data quickly
• 4-1. Save workbook: Save workbook
• 4-2. Save workbook: Benefits of saving a workbook in the cloud
• 5-1. Format, layout, and design: Basic formatting
• 5-2. Format, layout, and design: Tables
• 5-3. Format, layout, and design: Insert rows and columns
• 5-4. Format, layout, and design: Copy and move
• 5-5. Format, layout, and design: Conditional formatting
• 5-6. Format, layout, and design: Hide rows and columns
• 5-7. Format, layout, and design: Find and replace
• 6-1. Formulas and functions: Status bar for basic metrics
• 6-2. Formulas and functions: Enter a basic formula with addition and subtraction
• 6-3. Formulas and functions: Repeat formulas
• 6-4. Formulas and functions: Relative and absolute references
• 6-5. Formulas and functions: Division
• 6-6. Formulas and functions: Order of operations
• 6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE
• 6-8. Formulas and functions: VLOOKUP function
• 6-9. Formulas and functions: XLOOKUP function
• 7-1. Charts: Insert and format charts
• 7-2. Charts: Analyze data to generate charts
• 8-1. Sorting and filtering: Sort
• 8-2. Sorting and filtering: Filter
• 8-3. Sorting and filtering: Worksheet views
• 9-1. Pivot tables: All about pivot tables
• 10-1. Flash fill: Separate and merge data using flash fill
• 11-1. Adjust worksheet views: Freeze panes
• 11-2. Adjust worksheet views: Split panes
• 12-1. Multiple worksheets and workbooks: Rename and color worksheets
• 12-2. Multiple worksheets and workbooks: Add and delete worksheets
• 12-3. Multiple worksheets and workbooks: Hide and unhide worksheets
• 12-4. Multiple worksheets and workbooks: Move and copy worksheets
• 12-5. Multiple worksheets and workbooks: Worksheet groups
• 13-1. Share and collaborate: Protect worksheet
• 13-2. Share and collaborate: Protect workbook
• 13-3. Share and collaborate: Password protect workbook
• 13-4. Share and collaborate: Share workbook
• 13-5. Share and collaborate: Version history
• 14-1. Print: Print selection
• 14-2. Print: Set print area
• 14-3. Print: Hide column
• 14-4. Print: Page settings
• 14-5. Print: Adjust columns
• 14-6. Print: Repeat headers
• 14-7 Print: Headers and footers
• 14-8. Print: Show gridlines
• 14-9. Print: Page break view
• 15-1. Wrap up: Wrap up