# Overview

Coherent Assistant is an Excel add-in designed to integrate the capabilities of Spark directly into Excel. It enables users to connect to their Spark instance, upload and download Spark services as Excel files, and create testbeds within Excel. Additionally, users can establish live connections to external APIs and Spark services directly from Excel, among many other features.

The add-in can be installed from Microsoft AppSource Marketplace or with a manifest file. Follow the steps in [Installation](/assistant/get-started/installation.md) to have the add-in appear in Excel.

## Applications

Coherent Assistant offers a suite of applications designed to enhance your daily workflow. Below, you will find a list of these applications accompanied by brief descriptions of their functionalities. We are committed to continuously expanding this suite with new applications and enhancing the features of existing ones.

<table data-column-title-hidden data-view="cards" data-full-width="false"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Connect</strong></td><td>Establish a direct connection to Spark to unlock features that seamlessly integrate with Spark.</td><td><a href="/files/qXH1jxQKFGOWedMl5PV4">/files/qXH1jxQKFGOWedMl5PV4</a></td><td><a href="/pages/YOBRoAtAJyw2TCVkEDPU">/pages/YOBRoAtAJyw2TCVkEDPU</a></td></tr><tr><td><strong>Agent</strong></td><td>Use AI to understand, audit, and update workbooks with guided approvals.</td><td><a href="/files/dceh9jV7sypFO3P8dQAP">/files/dceh9jV7sypFO3P8dQAP</a></td><td><a href="/pages/hxfuuAtg9lKPcCGIph7e">/pages/hxfuuAtg9lKPcCGIph7e</a></td></tr><tr><td><strong>Mapper</strong></td><td>Mapping the inputs and outputs of your model is now easier than ever.</td><td><a href="/files/lnTWLn6AudxNo4UYJhe1">/files/lnTWLn6AudxNo4UYJhe1</a></td><td><a href="/pages/t3UOrlLIB19R8PCVQJ6f">/pages/t3UOrlLIB19R8PCVQJ6f</a></td></tr><tr><td><strong>Services</strong></td><td>Browse, create, and update Spark services directly from Excel.</td><td><a href="/files/2m3sH9lnfrqtlD9dCGFM">/files/2m3sH9lnfrqtlD9dCGFM</a></td><td><a href="/pages/GHFoSeYaqfvvlfyk2YAl">/pages/GHFoSeYaqfvvlfyk2YAl</a></td></tr><tr><td><strong>Solver</strong></td><td>Performs a What-if analysis similar to Goal Seek with each API call.</td><td><a href="/files/oMuvXpKMQZApoFWgjGGa">/files/oMuvXpKMQZApoFWgjGGa</a></td><td><a href="/pages/VMTCL70F0Gqt2Pu8koUM">/pages/VMTCL70F0Gqt2Pu8koUM</a></td></tr><tr><td><strong>Shell</strong></td><td>Obfuscate the logic of your Excel models to simplify collaboration.</td><td><a href="/files/Vf2CLyn0ugRXayELpU8x">/files/Vf2CLyn0ugRXayELpU8x</a></td><td><a href="/pages/nXp1U0dJdrVPKVtPan8U">/pages/nXp1U0dJdrVPKVtPan8U</a></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.coherent.global/assistant/overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.