Computer Courses

Excel for Beginners (Kevin Stratvert)

Sikhami InstituteEnglish

Free

Join for free
  • 60 video lectures (2h 9m)
  • Certificate of completion
  • Ask the teacher your doubts
  • Watch on the web and in the Android app

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

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
    • 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