> ## Documentation Index
> Fetch the complete documentation index at: https://docs.simen.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Excel Case Studies
> Just say the word, and Bonnie will automatically generate and process spreadsheets, eliminating repetitive work.
export const PromptBlock = ({prompt, link, title = "task"}) => {
const handleCopy = () => {
navigator.clipboard.writeText(prompt).catch(err => {
console.error("Failed to copy text: ", err);
});
};
return ;
};
## One-Click Sum for Data with Units
In Excel, data with units cannot be directly summed using formulas. The [traditional method](https://www.bilibili.com/video/BV18q4y1j7xm) 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:
## 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](https://www.bilibili.com/video/BV1uq4y1b7gp) 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:
## 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](https://www.bilibili.com/video/BV1AHmGYPEEQ) 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:
## 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](https://www.bilibili.com/video/BV1oE421F7Sq) 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:
## 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](https://www.bilibili.com/video/BV1jK4y1U7Bi) 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:
## 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:
## 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](https://www.bilibili.com/video/BV1JCjGz8E6P), 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: