ExcelAI

Formula Helper

Ask AI to get the formula you need and apply it directly to Excel.

Ways to generate formulas in Formula Helper:

Natural Language Dialogue:

Please calculate the total sales of vegetables in the category and place the result in F2.

Using Column Titles:

Calculate the total [Sales] in the [Category] for 'Fruits'.

Using Cell Ranges:

Please calculate the average of the range C2:C6

Ways to generate formulas in Chat:

Using column titles:

Calculate the total [Sales] in the [Category] for "Fruits".
Please calculate the median of the [Sales] in the table.

Using cell ranges

Please calculate the average of the range C2:C6

Generate Table

Enter the table requirements in the dialog box, and the AI generates the table and automatically applies it to the current table, for example:

Please generate a table with 'Category', 'Food', and 'Sales' columns, containing 5 rows of data 

Extract ID Information

Specify the information to be extracted and placed in the target area, for example:

IDs are from A1 to A20, please calculate the age and place the result in B1

Batch Insert Images

Batch insert images, align them with cells, and keep the image size consistent. For example:

    Please insert images and place them in cell B1. Image requirements are as follows:
    Initial size of the image: Cell size
    Fit image to cell: Yes
    Display comments: Yes
    Comment display position: Left

One-Click Set Cell Size

Directly adjust the column width and row height of cells at one time, no need to manually adjust left and right. For example:

Set the height of the selected cells to 50 and the width to 25

Extract Unique Data

Extract unique data from one or more columns and place it in new cells. For example:

Please extract the unique data from A1 to B10 and place it in cell C1.

Sum, Average, Maximum, Minimum

Perform statistical operations such as sum, average, maximum, and minimum on cells. For example:

Please calculate the sum of the data from A1:A10 and place the result in cell C1.

Quick Data Formatting

Quickly set data to commonly used data types, such as units in ten thousand, display in Chinese numerals, etc.

Last modified: 22 八月 2024