AI for Spreadsheets: Formulas, Cleanup and Analysis
How to use AI with Excel and Google Sheets: writing and explaining formulas, cleaning messy data, summarising tables and checking results, with prompts to copy.
How AI coding assistants work, from autocomplete to coding agents, what they do well, the security and quality risks, and habits for reliable code.

AI coding assistants have become part of everyday software work: they finish lines as you type, explain unfamiliar code, write tests and, increasingly, make changes across whole projects. Used well, they remove drudgery and speed up learning. Used carelessly, they produce code that looks right, passes a quick glance and fails in production. The difference comes down to how you work with them.
| Type | What it does | Best for |
|---|---|---|
| Inline autocomplete | Suggests the next line or block as you type | Boilerplate, repetitive patterns |
| Chat assistant | Answers questions and writes code in a conversation, often inside the editor | Explanations, snippets, debugging |
| Coding agent | Plans a task, edits multiple files, runs commands and tests, then reports back | Well-defined changes across a codebase |
Agents are the fastest-moving category. They follow the pattern described in our explainer on AI agents: a model that plans, uses tools and checks results in a loop. That power makes review and permissions even more important.
It depends on the task and the developer. A 2022 GitHub experiment found developers using Copilot finished a set programming task considerably faster than those without it. A 2025 randomised study by the research group METR, however, found experienced open-source developers working on their own familiar projects took longer with AI tools, even though they believed they were faster. The lesson: gains are largest on unfamiliar or repetitive work, and time spent reviewing and fixing output is easy to underestimate. Measure on your own work.
Our prompt engineering guide covers techniques that transfer well to coding prompts.
Most developers settle on an assistant built into their editor plus a general chatbot for questions. Try two or three on real tasks from your own codebase, and compare the quality of suggestions, how well each tool understands project context, privacy terms and cost. Our ChatGPT vs Claude vs Gemini comparison covers the underlying models.
They are changing the job, shifting time from typing code to specifying, reviewing and testing it. Understanding systems and judging quality matter more, not less.
Not automatically. It can contain the same vulnerabilities as human code, and sometimes more. Review it, test it and run security scanning.
Yes, as a tutor that explains, but write code yourself as you learn. Relying on generated code too early makes it hard to spot mistakes.
Every article is edited by a human and checked against our editorial policy. Spotted a mistake? Tell us.
How to use AI with Excel and Google Sheets: writing and explaining formulas, cleaning messy data, summarising tables and checking results, with prompts to copy.
How to use AI to summarise PDFs, reports and contracts accurately: prompts, checking for missed or invented details, privacy settings and what to never upload.
How AI meeting note-takers work, how accurate they are, the consent and privacy rules to follow, and a workflow for turning transcripts into useful notes.