Workplace Productivity and Office Skills
AI assistants in the office
An AI assistant can now draft the memo, summarise the thread and suggest the formula, which moves the skill from producing work to judging it. Copilot inside Outlook, Word, Excel and PowerPoint, Gemini in Workspace and ChatGPT in the browser each answer differently depending on what data they can see. This page covers prompting for office tasks, checking the output, and the data protection questions a careful user asks before pasting anything in.
Why this topic exists: Copilot in Word, Excel, PowerPoint and Outlook, Gemini in Workspace, ChatGPT for everyday work, and the questions of grounding and data protection: the Applied Skills business-user lab, ICDL AI Essentials, DigComp 2.2's AI examples.
Office AI assistants come in two forms. Some sit inside the applications: Copilot in Outlook, Word, Excel and PowerPoint, Gemini in Gmail, Docs and Sheets. Others live in a browser tab, like ChatGPT, and know only what the user pastes or uploads. The difference matters more than the brand. An assistant connected to your organisation's tenant can work from your own mail and files, while a general chatbot answers from its training and your prompt.
What the skill actually is
Writing prompts is the visible part. A useful office prompt names the task, the audience, the material and the shape of the answer: summarise this thread for a manager who missed it, in five bullet points, open decisions last. The harder part is checking. Assistants produce fluent text that can be wrong exactly where a reader is least likely to look, in a figure, a date, a name or the range a formula covers.
Assistants pay off where there is clear source material and a reader who can check the result: condensing a long thread, turning meeting notes into actions, rewriting a draft for a different audience, proposing a formula or chart for a table you already understand. They help least when the answer depends on facts nobody supplied, such as a customer's history or a rule that exists only in a colleague's head.
Microsoft's Applied Skills lab, Streamline business workflows with AI chat, puts the same pairing to work in a lab: browser tasks using Microsoft 365 Copilot, drafting in Word, building slides in PowerPoint, handling mail in Outlook and exploring data in Excel. It is aimed at business users and assessed in an interactive lab rather than by questions. ICDL has added AI Essentials to its CORE programme, and DigComp 2.2 threads examples involving AI through its existing competences instead of creating a new area. Before sending anything an assistant wrote, four checks are worth making.
- Trace every number to its source. A figure you cannot find in the material should be deleted.
- Read names, dates and commitments twice. These are the details that cause real trouble when they are wrong.
- Test formulas on a case you can work out by hand.
- Match the tone to the reader. A summary written for you may not suit a client or a board.
Data protection comes first
Before pasting a contract, a customer list or a salary table into any assistant, find out what your organisation allows. The same assistant can come under quite different terms depending on whether you sign in with a work account or a personal one, and your IT or data protection team can say which applies. Configuring those controls, and the AB-900 exam on administering Copilot and agents, belong to IT. Building agents that carry out steps on their own sits with workplace automation.
A citation is not a check
An assistant that links its answer to your own files can still misread them. Treat a cited source as the place to verify the claim, not as evidence that the summary is right.
Next to this topic
- Digital literacy and computer essentialsFiles and folders, the browser, accounts and passwords, safety habits and typing: DigComp 2.2's information, safety and problem-solving areas and ICDL's Computer & Online Essentials; the entry point of the whole field.
- SpreadsheetsCells, ranges, tables, formulas and charts in Excel and Google Sheets: the MO-210 blueprint's five areas and ICDL Spreadsheets; the single most examined office skill.
- Documents and word processingStyles, sections, references, tables and document collaboration in Word and Google Docs: the MO-110 blueprint and ICDL Documents; mail merge and templates are the daily craft the exam leaves out, and the skill hiring managers assume and rarely test.
- PresentationsSlide masters, layouts, themes, notes, transitions and export in PowerPoint, Google Slides and Keynote: the MO-310 exam and ICDL Presentation; design taste is the part no exam covers.
- Email and calendarRules, folders and labels, shared mailboxes, delegation, scheduling and etiquette in Outlook and Gmail: DigComp's communication area and the MO-400 Outlook exam that still counts towards MOS Associate.
- Collaboration, file sharing and meetingsCo-authoring, version history, sharing and permissions, channels, document libraries and online meetings in Teams, SharePoint, OneDrive, Drive and Meet: DigComp 2.2's communication and collaboration area (six competences) and ICDL's Teamwork module.
- Notes and personal knowledge managementNotebooks, tags, links and search in OneNote, Loop, Notion, Evernote and Obsidian: DigComp's managing of data, information and content; a field with practices and products but no examining body, an honest gap.
- Workplace automation: Power Automate and Power AppsFlows, triggers, connectors, approvals and canvas apps built by the people who use them, plus Copilot Studio agents: the PL-900 blueprint's five areas; robotic process automation for the desktop belongs here too.
- Enterprise systems for end users: SAP and OracleModules, transactions, master data and the daily screens of SAP S/4HANA, Oracle E-Business Suite and Fusion, Dynamics 365 and Workday: SAP Learning's certifications name the consultant behind each module; the end user is who this topic serves.
Concepts to know
Glossary entries with the reason each one matters here.
- Sensitivity label
How labels limit what Copilot returns.
Certifications that test it
Vendor exams and free certificates; facts, cost and the preparation path are on each page, and the certifications hub has them all.
- Microsoft · Lab-based assessment · freeMicrosoft Applied Skills: Streamline business workflows with AI chatThe business-user lab on Copilot in the Office applications.
- Microsoft · AB-900Microsoft 365 Certified: Copilot and Agent Administration FundamentalsThe administrator's side of the same assistant; cross-linked, not an end-user exam.
Tools of the trade
- ChatGPT
The assistant most office workers met first.
Frequently asked
- Is a certificate needed to use AI at work?
- No. Most employers care that you use it carefully and productively. If you want evidence, the Applied Skills assessment Microsoft runs on AI chat and ICDL's AI Essentials module are the two examined options aimed at end users.
- Copilot or ChatGPT: which suits office work?
- They suit different jobs. An assistant inside your organisation's apps can work with your own documents and mail; a general chatbot is often quicker for drafting from scratch or explaining a concept. Many workplaces permit only one, which settles the question.
- What should I never paste into an AI assistant?
- Anything your organisation classes as confidential, personal data about customers or colleagues, and passwords or access keys, unless you are using a tool your employer has approved for that data. When unsure, ask first.
Courses in the directory
46 courses are filed here; the top 6 by our ranking, details and the provider link on each course page.
Last reviewed 26 September 2026 · Getting Digital