Sheets basics and NotebookLM.

Two very different tools in this lesson. Sheets is the everyday one, useful, but with a sharp warning attached. NotebookLM is the one most people haven't tried and the one that tends to make jaws drop, because it works from your documents, not the whole internet. If you only take one new thing from this course, make it NotebookLM.

Sheets: helpful, but check the numbers

Spreadsheets trip people up on the fiddly bits, the formula you half-remember, the data that's in the wrong shape. Gemini in Google Sheets helps with exactly those. You can ask it in plain English to write a formula ("sum column D where column B says Paid"), explain a formula someone else built, suggest how to organise a messy dataset, or draft a starting table from a description. For anyone who isn't a spreadsheet wizard, that removes a lot of friction.

Now the warning, and it matters more here than anywhere else in the course. With words, a slightly off draft is easy to spot and easy to fix. With numbers, a wrong formula looks exactly as confident as a right one, and a quiet error can flow into a quote, an invoice or a report before anyone notices. So treat Sheets help as a capable assistant, never an auto-pilot:

• Test a suggested formula on a few rows where you know the answer before you trust it across the sheet.
• Ask it to explain what a formula does, then sanity-check that against what you actually wanted.
• Keep anything that touches money or reporting under a human's eye. A confident formula can still be wrong.

NotebookLM: a researcher who's read your files

Here's the standout. A normal chatbot answers from its general training and the open web, which is why it can wander or make things up. NotebookLM flips that: you give it your own documents as sources, and it answers, summarises and briefs only from those. Picture a sharp assistant who has read your stack of files and will talk you through them, the difference being that it points back to where each answer came from.

The use that wins people over is the briefing. Drop in the things you'd otherwise have to plough through, a long contract, a set of meeting notes, a policy document, a few research PDFs, and ask plain questions: "what are the key obligations in this agreement?", "summarise these notes into a one-page brief", "what do these reports say about pricing?" Because the answers are grounded in your sources and cite back to them, you can verify them in seconds instead of taking them on faith. That citation trail is what makes it genuinely useful for work rather than just impressive.

Real jobs it's well suited to:

• Turning a pile of documents into a clear briefing before a meeting.
• Getting across a long report or contract fast, then checking the bits that matter against the source.
• Building a quick internal reference from your own policies and procedures.

Two caveats keep it honest. It works from what you give it, so the quality of the briefing tracks the quality of your sources. And because you're uploading your own documents, mind what's in them: this is business material, so use it within your proper Workspace setup and keep genuinely sensitive files in line with whatever rules you'll set in the next lesson.

The thread through both

Sheets and NotebookLM look unrelated, but they share the lesson of this whole course. The tool does the heavy lifting, drafting the formula, reading the documents, and you stay the one who checks. With Sheets that means testing the numbers. With NotebookLM it means using the citations to confirm the brief. Lean on them for the grind, keep your judgement on the output, and both become a real lift. Last lesson next: good prompts, safe use, and a plan to roll it out.