Free preview lesson
Ask in a way AI can answer
What a formula is and how AI can help
A formula is an instruction you type into a cell that tells the spreadsheet to calculate something. It always starts with an equals sign. A cell is one box, named by its column letter and row number, like B2. A range is a block of cells, like B2:B50. A function is a ready-made tool inside a formula, like SUM.
=SUM(B2:B50)
This adds up every number from B2 down to B50.
You don't need to memorize hundreds of functions. You need to describe what you want clearly, and AI can suggest the formula. The problem is that a vague request gets a guess:
Weak: "formula for totals"
The AI doesn't know which column, which rows, or what kind of total. A clear request works much better:
Better: "In Google Sheets, column A has dates and column C has sale amounts in rows 2 to 200. Give me a formula for cell F2 that adds up all the sale amounts. Explain each part in one line."
This course works for Excel, Google Sheets and Numbers. Most simple formulas look the same in all three, but not every function exists everywhere, so always say which app you use.
One rule for the whole course: test every formula on a copy of your file first. A copy means a mistake costs you nothing.