Excel for Beginners (Kevin Stratvert)

About this course

Learn Microsoft Excel from the very beginning, in short, easy lessons from former Microsoft product manager Kevin Stratvert. Who it's for: students, office workers and anyone who needs Excel for work or study. These are the free, official videos of the "Excel for Beginners" playlist from the Kevin Stratvert YouTube channel (youtube.com/@KevinStratvert). All videos belong to Kevin Stratvert; Sikhami is not affiliated with Kevin Stratvert and simply arranges the public playlist into a course, so you can learn one lesson at a time and keep track of your progress.

What you will learn

• Getting Excel, and finding your way around the interface • Entering data quickly, and formatting and layout • Formulas and functions, including relative and absolute references and XLOOKUP • Charts, sorting and filtering, and flash fill • Working with multiple worksheets and workbooks • Protecting, sharing and printing your work

This course at a glance

Lectures

60 video lectures

Video

2h 9m in all

Level

All levels

Language

English

Access

Lifetime access

Certificate

On completion

Lectures last updated September 2026

Course content

1 section · 60 lectures · 2h 9m

1. 1. Excel for Beginners

   • 1-1. Introduction: Welcome to Excel for Beginners1m
   • 1-2. Introduction: What is Excel1m
   • 1-3. Introduction: How to get Excel1m
   • 2-1. Main interface: Start screen2m
   • 2-2. Main interface: Workbook and worksheet0m
   • 2-3. Main interface: Tabs and ribbon1m
   • 2-4. Main interface: Navigate through a worksheet2m
   • 2-5. Main interface: Navigate through a workbook0m
   • 2-6. Main interface: Help1m
   • 3-1. Enter data: Numbers4m
   Show all 60 lectures

   • 3-2. Enter data: Column width and row height1m
   • 3-3. Enter data: Dates and times2m
   • 3-4. Enter data: Select cells to enter data quickly0m
   • 4-1. Save workbook: Save workbook0m
   • 4-2. Save workbook: Benefits of saving a workbook in the cloud0m
   • 5-1. Format, layout, and design: Basic formatting4m
   • 5-2. Format, layout, and design: Tables3m
   • 5-3. Format, layout, and design: Insert rows and columns1m
   • 5-4. Format, layout, and design: Copy and move2m
   • 5-5. Format, layout, and design: Conditional formatting1m
   • 5-6. Format, layout, and design: Hide rows and columns1m
   • 5-7. Format, layout, and design: Find and replace1m
   • 6-1. Formulas and functions: Status bar for basic metrics1m
   • 6-2. Formulas and functions: Enter a basic formula with addition and subtraction3m
   • 6-3. Formulas and functions: Repeat formulas1m
   • 6-4. Formulas and functions: Relative and absolute references4m
   • 6-5. Formulas and functions: Division0m
   • 6-6. Formulas and functions: Order of operations1m
   • 6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE6m
   • 6-8. Formulas and functions: VLOOKUP function5m
   • 6-9. Formulas and functions: XLOOKUP function3m
   • 7-1. Charts: Insert and format charts5m
   • 7-2. Charts: Analyze data to generate charts2m
   • 8-1. Sorting and filtering: Sort3m
   • 8-2. Sorting and filtering: Filter2m
   • 8-3. Sorting and filtering: Worksheet views1m
   • 9-1. Pivot tables: All about pivot tables13m
   • 10-1. Flash fill: Separate and merge data using flash fill2m
   • 11-1. Adjust worksheet views: Freeze panes2m
   • 11-2. Adjust worksheet views: Split panes1m
   • 12-1. Multiple worksheets and workbooks: Rename and color worksheets1m
   • 12-2. Multiple worksheets and workbooks: Add and delete worksheets0m
   • 12-3. Multiple worksheets and workbooks: Hide and unhide worksheets0m
   • 12-4. Multiple worksheets and workbooks: Move and copy worksheets1m
   • 12-5. Multiple worksheets and workbooks: Worksheet groups1m
   • 13-1. Share and collaborate: Protect worksheet2m
   • 13-2. Share and collaborate: Protect workbook0m
   • 13-3. Share and collaborate: Password protect workbook0m
   • 13-4. Share and collaborate: Share workbook2m
   • 13-5. Share and collaborate: Version history0m
   • 14-1. Print: Print selection2m
   • 14-2. Print: Set print area1m
   • 14-3. Print: Hide column0m
   • 14-4. Print: Page settings1m
   • 14-5. Print: Adjust columns1m
   • 14-6. Print: Repeat headers0m
   • 14-7 Print: Headers and footers1m
   • 14-8. Print: Show gridlines0m
   • 14-9. Print: Page break view1m
   • 15-1. Wrap up: Wrap up0m

How long it takes

2h 9m of video in 60 lectures. Pick a pace that suits you:

• Steady

  5 days

  at 30 minutes a day

• Regular

  3 days

  at 1 hour a day

• Fast track

  2 days

  at 2 hours a day

Video time only: practice takes a little longer. Your place in every lecture is saved, so you can stop any time.

Earn a certificateLearn more

Who teaches it

Sikhami InstituteNew Delhi · 297 courses · 698 learners · 477 followersSikhami Institute is Sikhami's own institute for free learning. We pick some of the best free courses on YouTube, from Harvard's CS50, MIT, NPTEL, Khan Academy, Google, Microsoft, the BBC, Crash Course, PW, Magnet Brains, CodeWithHarry and many more, and turn them into proper courses on Sikhami that you can follow lesson by lesson while your progress is saved. Free courses in every category, in English and Hindi: school and competitive exams, programming and AI, languages, music and dance, art, yoga and fitness, cooking, trades, business, marketing, farming and more. All videos belong to their creators and play from their official YouTube channels, and each course credits its creator. Questions or suggestions? Write to help@sikhami.com.

Questions people ask

More from Sikhami InstituteSee all

Operating System Complete Course (Gate Smashers)

Computer Courses · 90 lectures · 53 students · Free

2 joined this week

Computer Organization and Architecture (Neso Academy)

Academics Courses · 98 lectures · 39 students · Free

8 joined this week

Java Tutorial for Beginners (Telusko)

Computer Courses · 105 lectures · 14 students · Free

7 joined this week

Algorithms (Abdul Bari)

Computer Courses · 83 lectures · 13 students · Free

4 joined this week