​
One-Click Sum for Data with Units

In Excel, data with units cannot be directly summed using formulas. The traditional method requires entering formulas first, extracting numbers, then replacing them—multiple steps to complete. But now, simply input the following prompt to Bonnie for one-click summation:
Sum Values with Units
Calculate the total sales amount for each product in the table, place it in the Total column, keep other columns unchanged, and save as a new workbook

Bonnie is quickly summing data with units

​
Quickly Split One Master Table into Multiple Sub-tables

Splitting an Excel master table into multiple sub-tables by department, month, or other dimensions is a common office requirement. Using pivot tables for this task is not only cumbersome but also prone to formatting issues like inconsistent column widths and blank rows. Now with Bonnie, simply upload your master table and tell it your splitting requirements for one-click completion:
Quick Split Master Table into Sub-tables
Split @/SalesTable.xlsx by product name into multiple worksheets, use product names as sheet names, rename and save as a new workbook file

Bonnie is splitting the master table by product

​
Generate Pay Stubs for 10,000 People in 10 Seconds

Creating individual pay stubs for tens of thousands of employees is one of HR’s most dreaded monthly tasks. Using traditional formulas is not only operationally complex but also extremely error-prone. Now, hand over your payroll table to Bonnie—with just one sentence, it can generate any number of pay stubs with one click:
Quick Payroll Table to Pay Stubs Conversion
Convert the payroll table into individual pay stubs for each person, with each pay stub containing two rows: headers and content, separated by one blank row between different people's pay stubs, save as a new workbook

Bonnie is converting the payroll table into pay stubs

​
Batch Insert 1000 Images of Various Sizes in 10 Seconds

Batch inserting hundreds of images into Excel is a nightmare for anyone. Manual insertion is too slow, and using the batch insert feature results in images that are either stretched and distorted or inconsistently sized, making the spreadsheet look terrible. Now leave this challenge to Bonnie—with just one sentence, it can handle any number of images and arrange them neatly:
Quick Batch Image Insertion
Insert all images into the Excel table, adjust the image display ratio in the table to ensure consistent and clear image display effects, save as a new workbook

Bonnie is batch inserting images

​
Merge Data Across Multiple Worksheets

When we need to consolidate data from different worksheets, we often fall into an inefficient and tedious predicament: copying and pasting one by one. This method is not only time-consuming and labor-intensive but also error-prone, especially when dealing with worksheets of varying formats and complex styles. For Excel beginners, complex formulas and tools are difficult to learn, and once not used regularly, they are quickly forgotten. But with Bonnie, everything becomes simple—just follow the prompts and state your requirements, and it can easily help you complete tasks or use different tools for merging:
Cross-Sheet Merging
Merge the contents of three worksheets (April Salary, May Salary, June Salary) in the file into a new worksheet 'sheet4'. The merged master table should include columns for 'Name', 'April', 'May', 'June', and 'Total'

Bonnie is merging data across sheets

​
Quick Comparison of Two Excel Tables for Consistency

In daily work, we often need to verify whether the contents of two Excel tables are consistent. This sounds simple, but in practice, it’s incredibly frustrating. Imagine facing two dense data tables, comparing row by row, column by column—one small oversight could miss subtle differences, and you might spend hours without being able to determine the results. But with Bonnie, everything is different. Upload the tables you need to compare, simply state your requirements, and Bonnie can quickly help you complete the table content verification:
Quick Table Content Comparison
Compare the product quantities on the left and right sides, highlight inconsistencies in red

Bonnie is highlighting inconsistent data in red

​
Create Progress Bars with Percentages in Excel

When using Excel for project management and progress tracking, you need to visually display task completion status. However, creating a progress bar in Excel that is both attractive and functional often requires complex operations and tedious settings, such as manually adjusting cell formats, entering formulas, setting conditional formatting, etc. Bonnie can help you achieve this in one step, quickly creating percentage progress bars that display task completion in real-time:
Quick Creation of Percentage Progress Bars
Add a new column: Completion Progress. This column's cells should display green progress bars and percentages. The progress bar length and percentage size should be based on the ratio of actual sales to target sales

Bonnie is creating percentage progress bars