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,...
Saved in:
| Main 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