Insights Teach on CourseBond Log in Sign up

Excel for Beginners

Excel in 2 Hours: From Zero to Pivot Tables

Beginner ⏱ 2 hours 📚 60 lessons 🌐 en 🏆 Certificate 📅 Last updated May 2026
Created by Kevin Stratvert

No prior experience? No problem. Learn Excel basics, formulas, charts, and pivot tables in just 2 hours. Understand your data's story now.

1 section • 60 lectures • 2.2h total length

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

Kevin Stratvert

YouTube Channel

📚 6 courses ► YouTube channel

Learn AI, productivity tools, and modern software with fast, step-by-step tutorials.

From tools like ChatGPT (OpenAI), Claude (Anthropic), Google Gemini, and Microsoft Copilot to Excel, Windows, and everyday apps, I break down complex technology into simple, practical steps so you can save time, work smarter, and get more done.

Alongside me, you’ll also learn from a team of expert instructors covering AI, Microsoft 365, automation, and real-world workflows.

New videos every week.

I’m a f

View instructor profile →