Excel for Beginners

A hands-on introduction to spreadsheets. Learn how a workbook is organized, enter and format data, write your first formulas and use the functions people rely on every day, then build a simple expense tracker from scratch.

  • Beginner
  • 60 minutes
  • 6 modules
  • Free
  • Certificate of completion
Start Course

What you'll learn

  • Find your way around a workbook: cells, rows, columns and sheets
  • Enter and format numbers, dates and text so they are easy to read
  • Write formulas that use cell references instead of typed numbers
  • Use SUM, AVERAGE, MIN, MAX and IF
  • Copy formulas correctly with relative and absolute references
  • Sort a list to find answers quickly

Course modules

  1. 1IntroductionWhy spreadsheets are worth learning
  2. 2Core ConceptsCells, formulas and functions
  3. 3Practical ExampleAdding up a month of sales
  4. 4Practice ActivityBuild a weekly expense tracker
  5. 5Knowledge QuizCheck your understanding
  6. 6Course CompletionCourse complete