Video Workbuddy Lesson24 Salary Data Boundaries is an English video tutorial note from Hooosberg. It keeps the Bilibili lesson link, cleaned-up course structure, prompts, and workflow notes together.
The original Chinese note is tagged with video tutorial, WorkBuddy, Excel, build note, build note, build note, build note. The goal is not a transcript, but a clearer companion note for people who want slides, prompts, and repeatable steps.
Future course updates can add the episode URL at the top, then summarize the goal, materials, prompts, checks, and reusable workflow.
Lesson approach
This companion note follows the same order as the video: understand the work problem first, prepare the files and rules, run the prompts in sequence, then verify the output before treating it as usable.
The Chinese source lesson covers 如何使用这篇教程笔记, 三层文件边界, Word 课件已写入的提示词 1, 本地公式工作簿的验收, 知识点与结果核对, 课后总结. It is designed as a practical workflow note, not a detached summary: the reader should be able to pause the video, complete one step, and return to the next step with evidence of what changed.
How to study with the video
On the first pass, watch for the inputs, constraints, and expected outputs. On the second pass, reproduce the workflow in a separate test folder. Keep source files unchanged and save generated reports, cleaned data, drafts, or exports in the designated output location.
Do not treat an AI response as a final decision. Check whether the task was fully specified, whether uncertain values were labelled, whether the result can be traced back to source material, and whether a human approval is needed before any submission, purchase, application, or external action.
Copy-ready source prompts
The original prompts are kept below in Chinese so that the operational meaning used in the video is not weakened by translation. Replace every sample file name, person, company, amount, rule, and destination with verified information from your own task.
02_AI可读数据_脱敏模板 根据脱敏模版我们开始设计一个工资数据展示展示，因为这个原始数据是脱敏的，所以我们设计的时候公式模版需要可以根据输入信息灵活统计。脱敏模版在后期我们替换真实信息后，其他的统计公司表格可以同步更新。Knowledge points and checks
The transferable skill is not a single prompt. It is the ability to turn scattered materials into a repeatable system: inputs have fixed locations, rules are written down, intermediate work is separated from final deliverables, and exceptions are visible instead of silently invented.
Before closing the task, verify four things: the input set is complete; unknown information is marked rather than guessed; the output is saved where the workflow expects it; and a small sample can be checked against the original files. High-impact decisions always remain subject to human review.
Wrap-up
Reuse the structure rather than copying the example blindly: define the objective and boundary, organize files and rules, run the steps in order, verify the result, and keep the workflow for the next similar task.
That is the central lesson behind this WorkBuddy series: AI becomes more reliable when work is expressed as a clear, inspectable process instead of a vague request for a finished answer.