Welcome to the Spreadsheet Basics book
📖 The full content is available in the Wiki of this repository. This README provides a general overview.
This book introduces the core principles of spreadsheet software using a platform-independent approach. Whether you use Excel, Google Sheets, or LibreOffice Calc, you’ll learn the skills needed to work with data confidently and clearly.
- What is a spreadsheet?
- Structure: cells, rows, columns, sheets
- Entering and formatting data
- Basic formulas and functions
- Sorting and filtering data
- Creating simple charts
- Applying your skills in practical tasks
This book is ideal for:
- Beginners starting with spreadsheet tools
- Students taking their first Office Productivity module
- Anyone looking to organize data and perform simple calculations
Use this book to:
- Follow in-class activities
- Practice at home or in self-paced sessions
- Prepare for more advanced spreadsheet levels
- Complete the final mini-project and present your results
All exercises are explained in the Wiki and can be practiced using any of the following tools:
Personal Budget Tracker
Create a spreadsheet that tracks a monthly budget, including:
- Categories (food, transport, etc.)
- Total and average formulas
- Conditional formatting for over-budget items
- One visual chart (bar or pie)
You will present your work, explain the structure, and reflect on what you learned.
"Learning to use spreadsheets isn't just about numbers — it's about organizing information, solving problems, and telling stories with data."
This book is licensed under the Creative Commons Attribution 4.0 International License.
You are free to use, adapt, and share this material with proper attribution.