Ablebits AI Assistant for Excel

Select the range of customer data.

Launch 'Fuzzy Match' from the Ablebits tab.

Set similarity threshold to 85%.

Use AI Assistant to standardize names (e.g., 'J. Doe' to 'John Doe').

Execute 'Remove Duplicates' based on semantic similarity.

Open the financial ledger sheet.

Ask AI Assistant: 'Calculate YoY growth comparing Column C and Column D, handle #DIV/0 errors'.

Review the generated IFERROR(formula) logic.

Apply to the entire column with one click.

Highlight the description column.

Select 'Translate' in the AI sidebar.

Choose target languages.

Set the output range to adjacent columns.

Run the batch process.

Select the text column.

Prompt the AI: 'Extract the 10-digit invoice number and the date format DD/MM/YYYY'.

The tool creates two new columns with the extracted data.

Verify accuracy using the 'Extract' preview pane.

Use 'Merge Two Sheets' tool.

Select the AI-suggested matching columns (e.g., 'SKU' vs 'Product ID').

Select which columns to update or add.

Run the consolidation for all five files.

Select the feedback column.

Open AI Assistant.

Input: 'Analyze the sentiment of these cells and write the result in the next column'.

Wait for batch processing to complete.

Select the cell containing the error.

Ask AI Assistant: 'Explain what this formula does and why it returns an error'.

Review the AI's step-by-step breakdown.

Click 'Fix Formula' to apply the suggested correction.