Chapter 10

Creating Spreadsheets with Microsoft Excel

Learning objectives

  • Explain the features of the Excel interface
  • Demonstrate how to navigate in a workbook and enter text
  • Show how to change the structure of a worksheet
  • Explain how to use formatting to improve a worksheet
  • Demonstrate the use of formulas and functions
  • Show how to summarize and illustrate data with charts
  • Understand how Excel uses tables to organized structured data

Understanding the Excel Interface

Moving Around in a Worksheet

Changing the Structure of a Worksheet

Formatting Cells

Entering Formulas and Functions

Creating Charts

Working with Data Tables

Spreadsheets help us to organize, calculate, and make sense of numeric data. Like the orderly row-and-column format of ...

Get Computing Fundamentals: Introduction to Computers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.