Spreadsheet Basics
Master the fundamental building blocks of spreadsheets: basic math, cell references ($), AutoFill, formatting, dropdowns, conditional rules, and view freezing.
Instant Feedback
Live Answer Checking
Industry Datasets
Autofill: Copying Formulas Down Fast
Learn how to use AutoFill and the fill handle in spreadsheets. Write a formula once and copy it instantly across all your rows.
Basic Math In Cells (+, -, *, /, Parentheses)
Learn how to perform basic math (+, -, *, /, ^) and use parentheses in spreadsheets. Build accurate calculations without needing complex formulas.
Locking Cells With Dollar Signs ($a$1)
Understand the difference between relative cells and absolute ($) locked cells. Lock master tax rates and currency values so your formulas never break when copied.
Coloring Cells Automatically With Rules
Learn how conditional formatting automatically highlights important numbers with colors. Spot low inventory, overdue tasks, and high sales instantly.
Pulling Data From Another Sheet (sheet2!a1)
Learn how to link data between multiple tabs using the SheetName!Cell syntax. Build clean executive dashboards connected to backend data sheets.
Creating Dropdown Lists To Prevent Typos
Learn how to use Data Validation in spreadsheets. Create dropdown menus in cells to prevent typos and ensure clean, consistent data entry.
Freezing Header Rows And Key Columns
Learn how to freeze header rows and pin identifier columns in spreadsheets. Keep your titles visible while scrolling through large multi-row tables.
Formatting Numbers, Currency & Percentages
Learn how number formatting changes how values look without altering their raw values. Display clean currency symbols ($), percentages (%), and decimal points.
Combining Text With The & Symbol
Learn how to join words, names, and numbers together in spreadsheets using the & ampersand symbol. Create full names, custom ID tags, and clean email addresses.
Splitting Combined Text Into Columns
Learn how to split combined text strings (like product codes and SKU batches) into separate columns using delimiters and text slicing functions.
This path helps you learn by doing. Each lesson teaches a new function with hands-on practice and real-world examples so the skills stick.