Primary Navigation
Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.
Book Contents Navigation
Introduction
Disclaimer
1. An Overview of Microsoft® Excel®
2. Entering, Editing, and Managing Data
3. Formatting and Data Analysis
4. Printing
5. Formulas
6. Statistical Functions
7. Functions for Personal Finance
8. Chap 2 Sample Exercise
9. Logical Functions & Conditional Formatting
10. Statistical IF Functions
11. Data Validation
12. Lookup Functions
13. Choosing a Chart Type
14. Formatting Charts
15. Scatter Charts
16. Using Charts with Microsoft® Word® and PowerPoint®
17. Creating an Excel Table
18. Sorting and Filtering Data
19. Filtering Data
20. Subtotals
21. PivotTables and PivotCharts
22. Importing Data into Excel
23. Artificial Intelligence in Excel
24. Solver
25. Power, Power, Power – Oh, so much power!!!
26. 3-D References
27. Chap X Quiz (H5P Activity)
Appendix
Previous/next navigation
The Most EXCELlent OER Spreadsheets Textbook Ever Published (in 2025) Copyright © 2025 by Marcus Lacher is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.