Description
Cells & Secrets: The Art of Spreadsheets
Teacher: Anna Knaub
Course: Self Paced
Ready to level up your organization skills and discover the power of data? In Spreadsheet Basics, you’ll learn how to use spreadsheets for everything from tracking expenses to organizing projects. We’ll cover essential skills like formulas, sorting, and data visualization, making it easy to stay organized and work smarter. Each week, you’ll complete hands-on projects that show you the real-world applications of spreadsheets—from managing budgets to analyzing data trends.
Whether you’re planning to ace school projects, prepare for future careers, or just keep your life organized, Spreadsheet Basics will give you the skills to do it all with confidence!
Topics Covered:
Intro Basics
Spreadsheet Operations
Formulas & Functions
Advanced Functions
Data Management & Techniques
Charts & Graphs
Conditional Formatting
Data Validation & Protection
PivotTables
Advanced Charting Techniques
Macros
Collaboration & Sharing
Advanced Data Analysis
Resources:
Students will not need to purchase external resources, but they must have access to Google Sheets and/or Excel.
Classes that pair well with Cells & Secrets:
Entrepreneurship I, Entrepreneurship II, Personal Finance, or Biz Talk
Semester Completion Policy
All self-paced courses must be completed within the semester in which the student is enrolled. While students may work through the material at their own pace, access does not extend beyond the active semester. This policy helps students stay on track, maintain academic momentum, and ensures coursework aligns properly with transcript and credit requirements. We encourage families to plan ahead and schedule consistent time each week for successful completion.
Kathy (verified owner) –
My boys INHALED this class! Ms. Knaub makes spreadsheets really engaging and fun. The workload was light and the concepts applicable and memorable. She uses Google Sheets (free) so no software purchase was necessary. My husband was talking about a spreadsheet he was making for work and the boys chimed in, talking about some of the functions they had learned in class and how they could be useful. I’d like to put my request in for an advanced class!