Microsoft Office · Beginner level

Beginner level · Module 4 of 5 · 12 guided hours

Spreadsheet Basics in Excel

Enter and format data, write basic formulas and create a simple chart for everyday records such as budgets and attendance.

Learning objectives

  • Enter, edit and format data in worksheets
  • Write formulas with cell references and SUM/AVERAGE
  • Create and print a simple chart

Topics

  • workbook, worksheets and cells
  • data entry and number formats
  • formulas and basic functions
  • charts and printing

Lessons

  1. Lesson 1 Worksheets, Cells and Data Entry

    Understand the workbook structure and enter, edit and format data correctly.

    cell addressrangenumber formatautofill

  2. Lesson 2 Formulas and Basic Functions

    Calculate totals, averages and differences with formulas that update automatically.

    formularelative referencefunctionfill handle

  3. Lesson 3 Charts and Printing Spreadsheets

    Turn data into a simple chart and print or export a spreadsheet that fits the page.

    chart typechart title and labelsprint areafit to page

Practical activity

Build a simple stock and sales sheet for a small shop with formulas for totals and a chart of best-selling items.

Expected outcomes

  • Correct, self-updating everyday spreadsheets
  • Clear charts and printouts

Assessment

Practical test: the instructor changes input values and checks that results update correctly.

Free taster lesson Microsoft Excel Basics Read a free self-study lesson on this topic in the Free Course Library.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.