What you will learn What people mean by AI today, and how it differs from search. You need to know nothing going in. If you finish this chapter thinking "ah, so that's what it is," that is enough.
In the previous chapter we saw that today's AI is a different kind of thing from AlphaGo. So what exactly is it?
If you were expecting something grand, this may be a small letdown. The definition is this:
A program that read an enormous amount of human writing and got very good at guessing what word comes next.
That is all. It is not conscious and it does not think for itself. But when you get extremely good at "guessing the next word," the result looks like writing, summarising, translating, and answering questions.
The fastest way to understand is to ask search and AI the same question.
You are working with a staff roster in Excel. You want to type an employee number and have that person's department appear automatically. You do not know how.
You type this into the search box:
You get back something like:
Now your work begins. Open the links, read the explanations, and adapt them to your own sheet. The example table has its columns in different places than yours.
You write this in a chat box. There is no need to compress it into keywords.
The answer comes back like this:
| Search | AI | |
|---|---|---|
| What it gives you | where the material is | an answer fitted to your situation |
| Your job | read, choose, adapt | check and use |
| How you ask | short, like keywords | long, like talking to a person |
| Can you follow up? | no, you search again | yes — "but what if numbers repeat?" |
In one line:
Search finds. AI makes.
Picture a library.
The librarian is not always right. Memories blur; they misspeak. That is why there is a separate chapter on things to watch out for. The point is that a catalogue and a librarian are for different things.
Search is strong at "things where the answer already exists somewhere." Someone has to have written it down for search to find it.
AI can also answer "things that are only true of your situation." Nobody on earth has written about your staff roster, but AI builds an answer around the situation you described.
How that plays out at work is the next chapter.
No. They are for different things.
If anything, the opposite. Being usable without knowing computers is this tool's defining feature. There are no commands or menu paths to memorise. You write what you want in plain language.
Until now, making a computer do something meant learning its way of doing things — menus, functions, commands. That has been reversed.
There are free options and paid ones. While you are learning, free is plenty.
1. State the biggest difference between search and AI in one sentence.
Search finds where the answer is; AI makes an answer that fits your situation. That is why it can answer about things nobody has ever written about — your sheet, your document, your circumstances.
2. Why do you lose out by writing keyword-style questions to AI?
AI builds its answer around the situation you gave it. Give it no situation and it can only give a generic answer — roughly what search would have given you. "Column A has the employee number, B the name, C the department…" produces a far more useful answer than "excel vlookup."
3. Why is asking AI for today's exchange rate risky?
Because AI may not know current information. Values that change by the minute, and facts about today, belong to search. We cover this limit in detail in things to watch out for.
Next we look at what this tool actually does in a working day, with examples → What gets better
HyperTeamsexcel vlookup how to1. VLOOKUP explained completely — blog2. Excel VLOOKUP from basics to practice — YouTube3. 7 ways to fix VLOOKUP errors — forum post...I'm managing a staff roster in Excel.Column A has the employee number, B the name, C the department.On another sheet I want to type an employee number and have thedepartment appear automatically. How do I do that?=VLOOKUP(A2, Roster!A:C, 3, FALSE)Put that in. What each part means:- A2 : the cell holding the employee number to look up- Roster!A:C : the range to search (employee number through department)- 3 : take the 3rd column of that range (department)- FALSE : only accept an exact matchIf the number isn't found you'll get #N/A. To show a blank instead:=IFERROR(VLOOKUP(A2, Roster!A:C, 3, FALSE), "")