Use AI With Spreadsheets

A sales summary says the second week improved by six point two five percent. The arithmetic looks neat, but the export contains a repeated order and an empty return count. Which result can the manager actually use? In this lesson, we will check the records, build a simple calculation and explain what the number counts. That turns a plausible spreadsheet answer into a conclusion someone else can inspect. This is Use AI With Spreadsheets, from Practical AI For Work, by Learn with Q. The main point is to check the data, formulas and units before trusting the conclusion. You will reconcile a verified duplicate, calculate weekly gross sales and percentage change,

and explain why the complete net-sales comparison remains unresolved. We will use a small fictional table and ordinary arithmetic. No coding, advanced spreadsheet experience or paid assistant is required. We will work in three stages. First, inspect the supplied records and their meanings. Second, calculate from the checked table and verify the result independently. Third, write a short business conclusion that preserves the missing information. An assistant can help propose a formula, explain its references or suggest checks.

You remain responsible for deciding whether those references and the conclusion match the task. Use the supplied fictional orders. For real work, check the information and account permissions before entering business data into an assistant. A spreadsheet assistant may work inside the file; another tool may receive only pasted values. Check what it can actually access and change. Keep a preserved source copy and review any proposed edits before applying them. A spreadsheet and calculator provide a complete manual route for this exercise. A cell reference is the address of a value, such as E thirteen.

A range is a group of cells, such as H thirteen through H sixteen. A formula calculates from specified inputs. Gross sales in this fixture means units sold multiplied by unit price, before returns. Our simplified net-sales measure subtracts the value of returned units at that same price. It excludes other costs, taxes and accounting adjustments. Use these definitions throughout this exercise. Open the raw export in the materials. It has nine rows of records and eight unique order identifiers.

Each record gives its week, region, product, units, unit price in US dollars and returned units. The export note confirms that the repeated O one hundred and seven row is the same order exported twice. O one hundred and eight has an unconfirmed returned-unit count. Its empty cell represents information we still need. Preserve the nine-row source. In the analysis copy, remove the one confirmed repeated export row and record why. Compare the remaining eight order identifiers with the source. Similar products or quantities alone would not establish a duplicate in another task.

Here the supplied export note gives us that evidence. Keep the O one hundred and eight return cell blank and flag it for clarification. A confirmed zero would mean no units returned; this blank does not establish that. Before calculating, inspect types and units. Units and returned units are counts; unit price is dollars per unit. Check that the numeric cells contain numbers and that week labels place each order in the right group. The fixture contains four unique orders in each week. A suggested formula can run successfully while using the wrong rows, counting the duplicate or multiplying by the wrong column.

Reading the inputs prevents those errors from hiding behind a tidy total. In the analysis sheet, the checked records occupy rows thirteen through twenty. Units are in column E, unit price in F, returned units in G and gross sales in H. For the first record, H thirteen equals E thirteen multiplied by F thirteen. Ten units at eight dollars each gives eighty dollars. Follow that same relationship for the other rows, and inspect one copied formula at the end to confirm it still uses its own row. Now total the gross-sales cells for each week. Week one uses H thirteen through H sixteen.

The four amounts are eighty, one hundred, sixty and sixty-four dollars. Their sum is three hundred and four dollars. Week two uses H seventeen through H twenty. Its amounts are ninety-six, seventy-five, seventy-two and eighty dollars, which sum to three hundred and twenty-three dollars. These are gross sales after the verified duplicate is removed. Check those results by another route. Multiply the original units and prices with a calculator or on the independent-check sheet, then add the four amounts for each week. Confirm that the total of sold units is forty-three in both weeks.

Compare your independent totals with the spreadsheet outputs. This check can reveal a missing row, a repeated order or a range that accidentally includes a different column. Investigate a disagreement before writing the conclusion. Percentage change needs a stated base. The difference is three hundred and twenty-three minus three hundred and four, or nineteen dollars. Divide nineteen by the first week's three hundred and four dollars. The ratio is zero point zero six two five; displayed as a percentage, that is six point two five percent. The denominator is the first week's gross sales because the question asks how the second week changed relative to the first.

Keep the two dollar amounts, nineteen-dollar difference and percentage distinct. A useful business sentence is: after removing the confirmed repeated export row, weekly gross sales increased from three hundred and four to three hundred and twenty-three US dollars, a six point two five percent increase. Both weeks contain forty-three sold units. The product mix changed. These records alone do not establish the cause of the change or a profit increase. The fixture records no new promotion decision, so do not invent a promotion effect. An assistant can help with a bounded request.

For example: use the checked analysis table, explain a formula for weekly gross sales, identify its exact row range and give one independent check. Ask it to state units and flag missing inputs. Current spreadsheet-assistant features depend on the product, account and file. Inspect every proposed formula in the actual sheet before accepting it. If the tool cannot access the file or provide an inspectable calculation, use the ordinary spreadsheet route. There is a real workplace example in Microsoft's September twenty twenty-six account of how its employees use AI. Microsoft describes a finance leader in Malaysia using Copilot in Excel to analyze and synthesize financial and business data, helping her explore questions about the figures.

This is the vendor's account of an employee workflow. We are using it as a documented example of analytical assistance. It supplies no independently measured saving or return on investment for our fictional Harbor team. Now inspect returns. For the first week, the return counts are known. One notebook returned at eight dollars and one desk mat returned at twelve dollars remove twenty dollars from the three hundred and four dollars of gross sales. Our defined net-sales measure is therefore two hundred and eighty-four dollars for week one.

You can reproduce that by calculating each row's gross sales minus returned units multiplied by unit price, then summing the four rows. The full second-week net sales cannot yet be calculated from this table. O one hundred and eight has an unconfirmed returned-unit count. Keep that unknown visible in the net calculation and the summary. The value for a row with missing returns should remain unresolved until the input is confirmed. Adding the known rows gives only a known subset. Presenting that subset as the whole week, or silently treating the blank as zero, would overstate what the records establish. Record the calculation and the remaining action together.

Your check sheet should name the source version, the duplicate treatment, formula or arithmetic, cell range, units, denominator and independent result. The business conclusion can state the verified gross-sales comparison while assigning a follow-up to confirm the missing return count. After that information is obtained, update the input and review the recalculated result. Keep the original source and the reason for the change so the update is traceable. For practice, use the fictional orders table and the formula-and-independent-check sheet. Reconcile the export, complete the gross-sales calculations and verify them with separate arithmetic. Write a two-sentence conclusion that states the gross result and the unresolved net-sales comparison. Explain the base used for percentage change.

Attempt the work before opening the separate explanation. If you use an assistant, log the time spent preparing the table, inspecting formulas, checking outputs and correcting them. Here is the first learning check. After the verified duplicate is removed, week one gross sales are three hundred and four US dollars and week two gross sales are three hundred and twenty-three US dollars. What is the percentage change relative to week one, and what does it measure? Pause and calculate. Subtract three hundred and four from three hundred and twenty-three to obtain nineteen dollars.

Divide nineteen by the first week's three hundred and four dollars. The percentage increase is six point two five percent. It measures the change in this fixture's gross sales before returns. Both weeks have forty-three sold units. Keep that scope in the answer and avoid adding an unsupported explanation for why the mix changed. Here is the second learning check. The gross-sales calculations are correct, but the returned-unit count for O one hundred and eight is still blank. Can you report complete second-week net sales under our stated definition?

What should the result and follow-up say? Pause and decide. Keep complete second-week net sales unresolved. The missing returned-unit count is needed for the calculation. Confirm it through the appropriate source, then update the analysis and check the result. A known subtotal can be labeled as a subtotal, with its excluded order identified. It cannot establish the full-week total. The manager can still use the verified gross-sales comparison while the returns question remains open.

A useful spreadsheet result has an inspectable path from records to formula to conclusion. Preserve the source, resolve verified duplicates, keep missing values visible and check the units and base. Recalculate the arithmetic independently before using the result. In the next lesson, we will turn checked information into a clear presentation, using charts and short messages that preserve the same qualifications.