Pick a depth. Each prompt opens in your AI pre-loaded with the lesson. Click a row to preview the prompt.
This is the moment analytics stops being theory and produces a number. Almost every answer you will ever compute comes from three moves in some combination: sort (order the rows), filter (keep only the rows that count), and total (SUM or COUNT them). Master these three and you can answer a startling share of business questions. The old barrier was writing the formula correctly - AVERAGEIFS with the right argument order is genuinely fiddly. AI erases that: you describe what you want in plain English and it hands you the exact formula to paste. Your job shifts to the part that was always the real skill - deciding what to filter and knowing the resulting number actually answers your question.
Let us answer the coffee shop question from earlier: 'Does Saturday bring in less average revenue than Wednesday, over the last three months?' Your sheet has columns Date (A), Weekday (B), Revenue (C). Move one, sort: select the data, Data > Sort range, sort by Revenue descending, just to see your biggest and smallest days - a quick feel for the range. Move two, filter: click Data > Create a filter, then use the funnel icon on the Weekday column to show only Saturday. Move three, total: you want the average, and you do not know the formula, so you ask AI: 'In Google Sheets, my data is in A2:C200 with Weekday in column B and Revenue in column C. Write a formula for the average Revenue where Weekday equals Saturday.' It returns =AVERAGEIF(B2:B200, "Saturday", C2:C200). Paste that into an empty cell, press Enter: it shows 380. Change "Saturday" to "Wednesday" in the same formula: it shows 540. There is your computed answer - Saturdays average 380 dollars, Wednesdays 540, so Saturdays are about 30 percent lower. That is a real number that settles the question. For a counting question instead of a summing one - 'how many orders were refunded?' - you would ask AI for =COUNTIF(Status_column, "refunded"). Same three moves, different totalizer. Keep a scratch area at the top of your sheet (say cells E1, E2) where you paste these formula results so you do not lose them.