The spreadsheet contains monthly sales data for January to June. Total sales were £124,500. March was the strongest month with £26,400 in sales, while January had the lowest result at £15,800. Product A was the best-performing product, generating 38% of total revenue. Sales increased steadily between January and March, declined slightly in April, and recovered in May and June.

Summary  
This chapter demonstrates integrating a conversational AI add-in to generate and manipulate structured code constructs—such as spreadsheet formulas and presentation slide layouts—via natural language prompts, follow-up clarifications, and direct insertion into the host application.

General domain of usage  
Automating spreadsheet and presentation tasks.

### Claude for Microsoft 365

Claude integrates directly with **Excel** and **PowerPoint** through the **Claude for Microsoft 365** add-in. Once installed from the Microsoft Marketplace, Claude appears in a sidebar within supported Microsoft applications.

### Claude in Excel

Claude can help you:

* **Import and format data** from CSV files
* **Explain complex formulas** in plain English
* **Create formulas** based on natural language requests
* **Analyse spreadsheet data** and identify trends

Think of Claude as a combination of a spreadsheet tutor and data analyst.

### Claude in PowerPoint

Claude can help you:

* **Restructure rough slide content**
* **Create presentation outlines**
* **Generate slide text**
* **Suggest charts and data visualisations**
* **Adapt presentations for specific audiences**

Claude can build a strong first draft, but you'll usually want to review and refine the final presentation.

> ### Task
>
> - Analyze monthly sales, identify the best-performing product, and highlight any noticeable trends.

Learn how to get the most out of Claude for work, study, and everyday tasks. This course covers everything from writing better prompts and analysing documents to using advanced features such as Projects, Artifacts, Memory, Skills, and Connectors. You'll also explore how Claude integrates with tools like Chrome, Slack, Excel, PowerPoint, and mobile devices. By the end of the course, you'll be able to use Claude confidently to save time, improve productivity, and solve real-world problems more effectively.

Learn the fundamentals of Claude, including account setup, the interface, plans, and core capabilities.