Browse reusable Agent Skills, each with a clear purpose and practical guidance.
Guides the user through calculating days inventory in stock and goodwill ratios in Excel, grouping data by business sectors derived from SIC codes.
提供VBA宏代码，用于批量转换Excel超链接（绝对转相对）或基于单元格内容原地批量创建指向文件/文件夹的超链接，支持自定义路径及存在性检查。
Extracts unique, non-blank values from a specific column in a source sheet based on a ComboBox selection, displaying them vertically in a destination sheet.
根据用户指定的三步流程生成Excel VBA宏代码，包括筛选首行、删除空白行、清洗指定列数据并求和。
使用Python pandas或Java POI将Excel文件中的多个Sheet合并到一个Sheet中，并新增一列记录数据来源的Sheet名称。
使用Python和openpyxl遍历Excel表格的指定列，筛选包含特定关键词的行，并将匹配到的关键词添加到输出行的最前面。
Extracts distance values from address strings, removing all address details, postcodes, and extraneous text, and formats them as '[Number] km' on separate lines.
Extracts complete quotes from a transcript that are specifically directed at homeowners during a door-to-door solar sales pitch, excluding any content meant for video viewers.
Identifies and lists all subject, relation, and object triplets from a provided sentence, handling complex clauses and missing objects, formatted as 'Subject - Relation - Object'.