AI Tools For Excel is an AI-powered Microsoft Excel add-in built to make spreadsheet work faster, easier, and more controlled inside Microsoft Excel. It helps users bulk fill cells, run bulk commands, review suggested changes before applying them, generate formulas from plain-English requests, explain formulas, clean messy data, review duplicates, and scan for spreadsheet errors.

AI Spreadsheet Agent is a key feature inside AI Tools For Excel that adds a more guided Excel formula bot and ChatGPT for Excel experience inside Microsoft Excel. Users can start from the current selection, choose a prompt starter or feature example, and get help with formula work, spreadsheet cleanup, duplicate review, error fixing, and bulk sheet tasks from one pane.

Its main features are Bulk Fillout, Bulk Commands, and Preview Before Apply. These features help users complete repetitive spreadsheet work across many cells from a single prompt while keeping control over every suggested update. Instead of making changes one by one, users can review results first and then choose whether to apply changes cell by cell or in bulk.

To make prompting easier, the add-in also includes bulk prompt examples, prompt starters, and example sheet data. This helps users get started faster, write better prompts, and understand how results may look before applying changes to their own worksheet.

📌 Key Features

Bulk Fillout: Fill multiple cells at once from a single prompt to save time on repetitive spreadsheet work.

Bulk Commands: Run worksheet tasks across many cells with one instruction instead of editing cell by cell.

Preview Before Apply: Review suggested changes before anything is written to the sheet, then apply updates cell by cell or in bulk.

Interactive Preview: Select or unselect individual suggested changes before applying them.

Prompt Starters and Feature Examples: Start faster with guided prompt ideas built into the add-in.

Bulk Prompt Examples: Includes ready-to-use prompt examples to help users write instructions faster.

Example Sheet Data: Provides sample sheet data so users can test prompts and understand how results can look before using their own worksheet.

Excel Formula Generator: Describe what you need in plain English and generate formulas instantly.

Explain Excel Formula: Understand how a complex calculation works with a clear, easy-to-read explanation.

Function By Color: Sum, count, average, and analyze values by background color, font color, or both.

Smart Data Cleanup: Standardize dates, currencies, phone numbers, text casing, whitespace, and numbers stored as text in Excel.

AI Duplicate Detection: Review and remove duplicate or near-duplicate data with more confidence.

Fix Excel Errors: Detect and help resolve #N/A, #VALUE!, #REF!, and other spreadsheet issues faster.

Scope Control: Run tools on a selected range or the entire worksheet.

⭐ Main Features

Bulk Fillout: Generate or update multiple cell values at once from one prompt.

Bulk Commands: Perform spreadsheet actions across a range without repeating the same task manually.

Preview Before Apply: Review results before applying them, then choose to keep, unselect, or apply changes cell by cell or in bulk.

These core features make AI Spreadsheet Agent more practical for everyday spreadsheet work. Users can complete bulk tasks faster while still reviewing and controlling each suggested change before it is applied.

📝 Easier Prompting

AI Spreadsheet Agent helps users get started faster inside AI Tools For Excel. Built-in prompt starters, bulk prompt examples, and example sheet data make it easier to write clear instructions, test ideas, and use the add-in with less trial and error.

Function By Color

Function By Color is a new feature in AI Tools For Excel for users who need to calculate values based on cell colors in Microsoft Excel. It helps users create color-based formulas for common spreadsheet tasks such as sum by color in Excel, count cells by color, count colored cells, sum colored cells, sum cells by fill color, sum by font color, count cells by fill color, and count cells by font color.

Users can select a source range, choose a result cell, choose the calculation function, and match cells by Background Color, Font Color, or both. The add-in can also load the selected background and text color from the active cell, making it easier to build a formula from the same color pattern already used in the worksheet.

Function By Color uses the existing add-in formula logic and inserts formulas such as AITOOLS.CELLSVALUEBYCOLOR into the worksheet. This allows users to return or aggregate values that match selected fill and font colors, then use Excel functions such as SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN, MAX, PRODUCT, MODE, STDEV, VAR, or MEDIAN.

Calculate by background color: Sum, count, average, or analyze cells that match a selected fill color.

Calculate by font color: Work with values that match a selected text color.

Match background and font together: Use both color conditions when the worksheet uses more detailed color coding.

Use active cell colors: Pick the fill and font color from the active cell instead of entering color values manually.

Editable result cell: Choose where the generated formula should be inserted.

Result-cell color option: Optionally apply the selected fill and text color to the result cell.

Refresh color formulas: Recalculate Function By Color formulas after cell color formatting changes when needed.

This feature is useful for color-coded budgets, sales sheets, status reports, task trackers, inventory lists, review workflows, and any spreadsheet where fill color or text color is used as part of the data review process.