> ## Documentation Index
> Fetch the complete documentation index at: https://anaconda.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Anaconda Assistant

Anaconda Toolbox Excel add-in has reached [end of life](https://anaconda.com/docs/reference/policies-practices/software-version-support.md#end-of-life-eol) and is no longer supported. Cells using `=ANACONDA.CODE()` will stop working on April 30, 2027. Python in Excel's `=PY()` formulas are unaffected by this retirement.

Dismiss banner

The Anaconda Assistant is an intuitive chat interface to help you generate, explain, and debug code, learn new topics, and more.

To access the Assistant, click **Chat-based Python help** under **Anaconda Assistant**.

## Ask the Assistant

Use the Assistant to create Python code for analyzing your data.

1. Under **Help with coding tasks**, click **Generate python code to…**.
2. Pose prompts to the Assistant for guidance on analyzing the data in your workbook.
3. When provided code to run, set the placement in your workbook and click **Run**.

## Generate a chart

Use the Assistant to create Python code for rendering charts.

1. Under **Work with Tables and Ranges**, click **Generate a chart from a table or range**.

2. Click the input cell that appears, then, in the dropdown, select a specific sheet or manually select a range of cells.

3. The Assistant provides a list of possible charts it can generate Python code for. Use the text box to choose which chart you would like generated or to ask for a new set of possibilities. Type something like the following:

   * 1
   * Generate the second idea
   * chart #3, please
   * Give me new options!

4. Once the Assistant has provided the code, click the **Placement in Workbook** cell and select a cell in your workbook to render the code.

5. Click **Run**.

   ![](https://mintcdn.com/anaconda-29683c67/Jbxn1KJ0XaeZeGhX/images/excel/assistant_chart.png?fit=max\&auto=format\&n=Jbxn1KJ0XaeZeGhX\&q=85\&s=65d8b0f7bf163eb4dd173981eee206c5)

6. The chart renders in the cell you set under **Output**. To view an enlarged copy of the chart, select the cell, then click **Create Reference**.

   ![](https://mintcdn.com/anaconda-29683c67/Jbxn1KJ0XaeZeGhX/images/excel/assistant_chart_render.png?fit=max\&auto=format\&n=Jbxn1KJ0XaeZeGhX\&q=85\&s=7958ca104a5b7d8d60961fca0aa1d72f)

## Aggregate or summarize a table or range

Use the Assistant to create Python code to aggregate your data.

1. Under **Work with Tables and Ranges**, click **Aggregate or summarize a table or range**.

2. Click the input cell that appears, then, in the dropdown, select a specific sheet or manually select a range of cells.

3. The Assistant provides a list of possible calculations it can generate Python code for. Use the text box to choose which chart you would like generated or to ask for a new set of possibilities. Type something like the following:

   * 1
   * Generate the second idea
   * calculation #3, please
   * Give me new options!

4. Once the Assistant has provided the code, click the **Placement in Workbook** cell and select a cell in your workbook to render the code.

5. Click **Run**.

   ![](https://mintcdn.com/anaconda-29683c67/Jbxn1KJ0XaeZeGhX/images/excel/aggregate_render.png?fit=max\&auto=format\&n=Jbxn1KJ0XaeZeGhX\&q=85\&s=70e012a65d6e6227a7261dbb2cfe9ebd)

6. The results render in the cell you set under **Output**.

   > [!NOTE]
   >
   > If the results shows up in the Diagnostics pane, manually remove the `print(` and closing `)` from the formula bar above the sheet.

## Start a new chat

To start a new chat, click **New Chat**.

![](https://mintcdn.com/anaconda-29683c67/r-i16GgDcvoHQ-Uq/images/excel/new_chat.png?fit=max\&auto=format\&n=r-i16GgDcvoHQ-Uq\&q=85\&s=64388903b504e742ecef925183910d66)