Prompt: 我需要一個旅遊花費的表格，需要的欄位包括日期、花費項目、金額、各自的費用（有四人分別為老強、小蘋、小剛及小葉的花費）、 小計（把左邊四人的花費加起來）。 以下是按照您的需求設計的旅遊花費表格範本，包含日期、花費項目、金額、四人分攤費用及自動計算的小計欄位： 旅遊花費記錄表 日期 花費項目 金額（元） 老強 小蘋 小剛 小葉 小計（元） 2023-10-01 高鐵票 2000 500 500 500 500 2000 2023-10-01 午餐 600 150 150 150 150 600 2023-10-02 景點門票 800 200 200 200 200 800 2023-10-02 民宿住宿 3200 800 800 800 800 3200 總計 6600 1650 1650 1650 1650 6600 表格說明 金額：該項目的總花費金額。… Continue reading Create travel expense table in Excel
Tag: AI-MS-Excel
Create an excel application with Deepseek
Prompt: Create data entry in excel userform with 4 textboxes and 4 buttons save edit search and delete and add listview with Ivwrepbrt and gridlines.to DeepSeek-AI
Plot LLC distinct family name counts chart via Excel AI
Prompt: How to split column A to be two columns; one column contains the Chinese first name; the other column contains the remaining Chinese name? to Excel inside AI Copilot To split column A into two columns, where one column contains the Chinese first name and the other column contains the remaining Chinese name, you… Continue reading Plot LLC distinct family name counts chart via Excel AI
Use AI in Excel to analyze LLC data
Click to view LLC_2025_Students_info.xlsx file Prompt: I have an Excel sheet of student dataset. Column A is “Student Name”, column D is “Student Lifetime Member Flag”, column F is “College Name”, column G is “Group Leader Name”. The first row is used for each column title. From row 2 to row 711 contains student dataset.… Continue reading Use AI in Excel to analyze LLC data