The Most EXCELlent OER Spreadsheets Textbook Published (in 2025)

"The Most Excellent OER Spreadsheets Textbook Ever Published (in 2025)" by Marcus Lacher is a comprehensive and accessible guide designed to empower students and professionals with the skills needed to master Microsoft Excel. This textbook is meticulously crafted to be concise, effective,...

Full description

Saved in:
Bibliographic Details
Main Author: Lacher, Marcus (Author)
Format: Electronic eBook
Language:English
Published: Minnesota Minnesota State Colleges and Universities 2025.
Series:Open textbook library.
Subjects:
Online Access:Access online version
Tags: Add Tag
No Tags, Be the first to tag this record!
Table of Contents:
  • Introduction
  • Disclaimer
  • I. Chapter 1 - Fundamental Skills
  • An Overview of Microsoft® Excel®
  • Entering, Editing, and Managing Data
  • Formatting and Data Analysis
  • Printing
  • II. Chapter 2 - Mathematical Computations
  • Formulas
  • Statistical Functions
  • Functions for Personal Finance
  • Chap 2 Sample Exercise
  • III. Chapter 3 - Logical and Lookup Functions
  • Logical Functions & Conditional Formatting
  • Statistical IF Functions
  • Data Validation
  • Lookup Functions
  • IV. Chapter 4 - Presenting Data with Charts
  • Choosing a Chart Type
  • Formatting Charts
  • Scatter Charts
  • Using Charts with Microsoft® Word® and PowerPoint®
  • V. Chapter 5 - Tables and PivotTables
  • Creating an Excel Table
  • Sorting and Filtering Data
  • Filtering Data
  • Subtotals
  • PivotTables and PivotCharts
  • Importing Data into Excel
  • VI. Chapter X - What’s New and Overlooked in Excel?
  • Artificial Intelligence in Excel
  • Solver
  • Power, Power, Power – Oh, so much power!!!
  • 3-D References
  • Chap X Quiz (H5P Activity)
  • Appendix