For Everyone | Delete Unused Installers in Downloads

Bulk Delete Installers
Delete all installer files in this folder, i.e., files with the .dmg extension

Bonnie is deleting installer files

Corporate Finance | Generate Individual Pay Stubs for Each Employee

Batch Generate Pay Stubs
Based on the data in this spreadsheet, create an individual Excel pay stub file for each person. Each pay stub should contain two rows: headers and content. The file name should be the person's name. Put all generated files into a single folder

Bonnie is generating pay stubs

Enterprise Finance | Summarize Invoice Data into an Excel Sheet in Bulk

Batch Invoice Data Summary
First, use a PDF reader to read the text content of these invoice PDF files. Then call OpenAI to recognize and understand the text. Finally, summarize the invoice information into an Excel sheet, keeping seller name, item name, total amount with tax, and issue date. Sort the rows by date

Bonnie is summarizing invoice data

Classify Invoices by Project Type
First, use a PDF reader to read the text content of these invoice PDFs. Then call OpenAI to recognize and understand the text. Finally, classify the invoices according to the detected project information, placing different types into different folders named after the project

Bonnie is classifying invoices by type

Summarize by Contract Filename Date
Summarize the dates contained in these contract file names into an Excel sheet with two columns: file name and date. Sort by date ascending

Bonnie is summarizing contract dates

Content Creators | Quickly Categorize by File Type

Quickly Categorize by File Type
Categorize these files by type, such as mp4, xlsx, png, etc. Put files of the same type into one folder, and name the folder after the file type

Bonnie is categorizing files by type

University Teachers | Rename and Consolidate Transcripts by Class

Rename Transcripts with Class Prefix and Consolidate
Add the class name as a prefix to all Excel file names in this folder; for example, rename 'Cao Kun.xlsx' to 'Class 2-6 - Cao Kun.xlsx'. Save the renamed Excel files to a new folder named 'All Transcripts for Class 2-6'

Bonnie is renaming and consolidating by class

Append Last Modified Date to Filename
Add the last modified date of these contract files to the filenames. For example, rename to '20250324- Simen Authorization Agreement.docx'

Bonnie is appending last modified dates

Content Creators | Batch Compress Images to a Consistent Size

Batch Compress Images to a Consistent Size
Compress these images so that each is around 50 KB. Save the compressed images to a new folder named 'Compressed Images'

Bonnie is batch compressing images

Content Creators | Batch Convert Image Formats

Batch Convert Image Formats
Convert all these images to the JPG format. Save the converted images to a new folder named 'New Images'

Bonnie is batch converting image formats

Office Staff | Merge Multiple Invoices into a Single PDF for Reimbursement

Merge Multiple Invoices into a Single PDF
Merge these invoice PDF files into one PDF and rename it to 'JD Invoices - April Summary.pdf'

Bonnie is merging invoice PDFs