‹‹ All zyBooks

Spreadsheets Essentials


Matthew Liberatore

Professor of Chemical Engineering
University of Toledo


  • Formulas and functions
  • Creating a chart
  • Trendlines
  • Solver and least squares fits
  • Error and statistics
  • Interpolation
  • Integration and numerical integration
  • Matrices and solving problems of linear equations


  • A breakthrough primer on using spreadsheets in any discipline
  • More than 40 animations demonstrate simple to advanced functions
  • Over 120 auto-graded questions provide students practice with spreadsheets

The zyBooks Approach

This zyBook provides an exceptionally-interactive introduction to Spreadsheets, with numerous embedded learning questions, animations, and auto-graded exercises. Unlike many books on the topic, this material emphasizes high-level skills, like applying concepts and analyzing systems, that are crucial for students to succeed in science, engineering, and related disciplines. This material does so through matching and multiple choice questions that apply definitions and demonstrate the utility of a spreadsheet. Spreadsheets are common across platforms, devices, operating systems, etc., so this material was created to provide a general overview of skills that translate across Microsoft Excel, Google Sheets, Apple Numbers, and other spreadsheet programs.

As with other zyBooks, a key benefit of such interactivity is that students learn more, and come to class more engaged when points are given for completing the interactive activities beforehand. Instructors can quickly see which activities have been completed by students.