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 an AI assistant via an add-in API to programmatically generate and execute code for automating data import, analysis, and visualization based on natural language prompts.  

General domain of usage  
Productivity software automation

### 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.