Media & documents
9,982 rows, by stacks then stars
103 of these skill files have been read, by 99 distinct authors, and what they tell an agent counted. What Media & documents authors agree on, and what they forbid
XiaoMaColtAI/math-modeling-skill/tools/xlsx Skill
no license677★ repo读取、创建、修改和验证 XLSX,支持模板保留、公式重算和错误检查。
The same file is in 1 other repository
Ecommerce social media marketing
nexscope-ai/eCommerce-Skills/ecommerce-social-media-marketing Skill
675★ repoSocial media marketing strategy for ecommerce brands. Content calendar planning, platform-specific strategies, social commerce optimization, influencer collaboration, and community building. Use when the user asks about social media marketing, social commerce, content strategy, or social media for ecommerce.
nexscope-ai/eCommerce-Skills/ecommerce-video-marketing Skill
675★ repoE-commerce skills for AI agents — product research, marketing automation, supply chain optimization, and business analytics for online sellers across Amazon, Shopify, Etsy, TikTok Shop, and all platforms.
nexscope-ai/eCommerce-Skills/etsy-social-media-marketing Skill
675★ repoSocial media marketing for Etsy — Pinterest, Instagram, TikTok strategies to drive shop traffic
nexscope-ai/eCommerce-Skills/shoppable-video Skill
675★ repoE-commerce skills for AI agents — product research, marketing automation, supply chain optimization, and business analytics for online sellers across Amazon, Shopify, Etsy, TikTok Shop, and all platforms.
nexscope-ai/eCommerce-Skills/social-media-monitor Skill
675★ repoMonitor social media mentions, trends, and competitor activity for e-commerce brands. Set up listening workflows across Reddit, TikTok, Instagram, Twitter/X, and YouTube.
staruhub/ClaudeSkills/lab/Geek-skills-podcast-generator Skill
672★ repo用火山引擎 Podcast AI 模型生成中文双人对话播客。当用户要把文章、报告、话题文本转成播客音频、生成对话式音频内容时使用,需要环境具备火山引擎 APP_ID 和 ACCESS_KEY。支持 mp3/ogg_opus/pcm/aac、语速调节、自定义音色、断点续传。不用于:单人朗读式 TTS(用普通语音合成)、英文播客(模型主要优化中文)、播客文稿本身的撰写(先用写作类 skill 产出文本再来)。
mhattingpete/claude-skills-marketplace/visual-documentation-plugin/skills/architecture-diagram-creator Skill
663★ repoCreate comprehensive HTML architecture diagrams showing data flows, business objectives, features, technical architecture, and deployment. Use when users request system architecture, project documentation, high-level overviews, or technical specifications.
The same file is in 12 other repositories
mhattingpete/claude-skills-marketplace/visual-documentation-plugin/skills/flowchart-creator Skill
663★ repoCreate HTML flowcharts and process diagrams with decision trees, color-coded stages, arrows, and swimlanes. Use when users request flowcharts, process diagrams, workflow visualizations, or decision trees.
The same file is in 8 other repositories
lawve-ai/awesome-legal-skills/skills/docx-processing-anthropic Skill
no license641★ repoUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of "Word doc", "word document", ".docx", or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a "report", "memo", "letter", "template", or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.
lawve-ai/awesome-legal-skills/skills/docx-processing-openai Skill
no license641★ repoToolkit for comprehensive document reading, editing, and creation with visual quality control. Use to work with Word documents (.docx files) for: (1) Reading or extracting content from existing DOCX files, (2) Creating new Word documents with professional formatting, (3) Editing documents requiring precise typography and layout, or any other DOCX reading or generation tasks.
The same file is in 1 other repository
lawve-ai/awesome-legal-skills/skills/docx-processing-superdoc Skill
no license641★ repoEdit, query, and transform Word documents with the SuperDoc CLI v1 operation surface. Use when the user asks to read, search, modify, comment, or review changes in .docx files.
Mandarinat christophe quezel ambrunaz
lawve-ai/awesome-legal-skills/skills/mandarinat-christophe-quezel-ambrunaz Skill
no license641★ repoAssistant académique pour enseignants-chercheurs en droit. Six tâches : (1) recherche juridique approfondie avec accent doctrinal, (2) relecture de documents avec vérification des références, commentaires Word, détection d'indices de plagiat/IA et cohérence argumentative, (3) création de sujets et corrigés d'exercices juridiques universitaires, (4) mise à jour de cours, ouvrages et documents juridiques, (5) création de cours avec support docx et PPTX, (6) préparation de fiches de TD. MCP : OpenLegi, Themia, LegalDataHunter. Déclencher pour toute demande liée à l'enseignement ou la recherche en droit : cours, TD, fiches de TD, examens, sujets, corrigés, relecture, mise à jour, recherche doctrinale. NE PAS déclencher pour les QCM (utiliser qcm-generator).
lawve-ai/awesome-legal-skills/skills/pdf-processing-anthropic Skill
no license641★ repoUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill.
The same file is in 1 other repository
lawve-ai/awesome-legal-skills/skills/pdf-processing-openai Skill
no license641★ repoToolkit for comprehensive PDF reading, reviwing, and creation with visual quality control. Use to work with PDFs (.pdf files) for: (1) Reading or extracting content from existing PDFs, (2) Creating new PDF documents with professional formatting, (3) Generating reports, documents, or layouts that require precise typography and design, or any other PDF reading or generation tasks.
The same file is in 1 other repository
lawve-ai/awesome-legal-skills/skills/pptx-processing-anthropic Skill
no license641★ repoUse this skill any time a .pptx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates, layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx filename, regardless of what they plan to do with the content afterward. If a .pptx file needs to be opened, created, or touched, use this skill.
The same file is in 1 other repository
lawve-ai/awesome-legal-skills/skills/tabular-review-lawvable Skill
no license641★ repoGuide to analyze multiple documents (PDF, DOCX) against user-defined columns and produce a structured Excel output with citations. Use when the user wants to: (1) Extract specific information from multiple documents into a table, (2) Compare clauses or provisions across contracts, (3) Create a document review matrix with source citations. Triggers on: 'tabular review', 'document matrix', 'extract from documents', 'compare across documents', 'review multiple contracts'.
lawve-ai/awesome-legal-skills/skills/xlsx-processing-anthropic Skill
no license641★ repoUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
The same file is in 1 other repository
lawve-ai/awesome-legal-skills/skills/xlsx-processing-manus Skill
no license641★ repoProfessional Excel spreadsheet creation with a focus on aesthetics and data analysis. Use when creating spreadsheets for organizing, analyzing, and presenting structured data in a clear and professional format.
The same file is in 1 other repository
lawve-ai/awesome-legal-skills/skills/xlsx-processing-openai Skill
no license641★ repoToolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control. Use to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing tabular data, (3) Modifying existing spreadsheets while preserving formulas, (4) Building financial models with proper formatting, (5) Data visualization with in-sheet charts, or any other spreadsheet tasks.
The same file is in 1 other repository
minhnv0807/ai-business-skills/modules/personal-branding/en/25-voice-clone-podcast-global Skill
641★ repoAudio AI for global personal brand — voice clone (ElevenLabs, Murf, PlayHT), podcast, audiobook, voiceover. 3 use cases: short voiceover (TikTok/Reels), podcast 30-60min, audiobook. 1:10 repurpose (1 podcast → 10 short clips). English (US/UK/AU/SG accents available). Trigger: 'voice clone global', 'ElevenLabs', 'podcast AI', 'audiobook AI', 'voiceover AI'.
minhnv0807/ai-business-skills/modules/personal-branding/vi/25-voice-clone-podcast Skill
641★ repoAudio AI cho personal brand — voice clone (ElevenLabs/HeyGen Voice/Vbee), podcast workflow, audiobook, voiceover video. 3 use case: voiceover ngan TikTok/Reels (energetic), podcast 30-60 phut (conversational), audiobook (mid-tempo). Repurpose 1:10 (1 podcast → 10 short clip). Trigger: 'voice clone', 'ElevenLabs giong noi', 'podcast AI', 'audio AI', 'Descript voice', 'Riverside podcast', 'voiceover AI'.
minhnv0807/ai-business-skills/skills/en/04-script-video-global Skill
641★ repo138 bilingual AI marketing skills (69 VN + 69 Global) for Claude Code, OpenCode, Codex, VS Code. Four role SOP packs — content, design, performance, leader ops — plus strategy, personal brand, AI avatar, dropshipping, design master, knowledge library. 4 regions (US/EU/SEA/LATAM) + Vietnam 2025-2026. Companion: opa-kit.
The same file is in 1 other repository
minhnv0807/ai-business-skills/skills/vi/04-script-video Skill
641★ repoViet script video ngan cho TikTok, Reels, YouTube Shorts — 2 ban A/B, co hook, CTA, huong dan quay chi tiet
minhnv0807/ai-business-skills/skills/vi/29-xuat-khau-b2b Skill
641★ repoChien luoc marketing xuat khau B2B cho doanh nghiep Viet Nam — tao ho so nha xuat khau, lap ke hoach trien khai thi truong nuoc ngoai, viet pitch deck va email chao hang quoc te, chuan bi cho hoi cho thuong mai. Triggers: "xuat khau", "B2B nuoc ngoai", "thi truong quoc te", "pitch khach nuoc ngoai", "ho so cong ty bang tieng Anh", "email chao hang export", "tham du hoi cho", "buyer nuoc ngoai", "company profile", "export marketing"
worldwonderer/video-recap-skills/skills/video-recap Skill
637★ repo从输入视频端到端生成中文解说成片。用户提供 .mp4 / .mov / .mkv / .webm,并要求添加旁白、 配音、总结、短剧/电视剧/电影/纪录片/科普解说时使用。负责编排 video-* 技能链:视频理解 → Agent 制定故事与视听方案 → 剪辑 → 配音 → 合成。触发词:视频解说、视频旁白、生成解说、 视频 recap、video recap、voiceover、narration、auto-dub、recap。
worldwonderer/video-recap-skills/skills/video-script Skill
637★ repo对已完成分析的视频进行导演与剪辑策划,再写带时间戳的中文解说并校验。work_dir 已包含 agent_narration_brief.md 与 vlm_analysis.json 时使用。适用于故事方向、片段选择、画面/原声/旁白分工、 解说写作与复核。输入 work_dir 中的理解索引;输出 recap_story_plan.json、visual_audio_board.json、 cut 模式需要的 clip_plan.json,以及通过校验的 narration.json。触发词:解说词、写解说、视频旁白、 narration script、写稿、解说文案、剪辑思路、导演思路。
worldwonderer/video-recap-skills/skills/video-understanding Skill
637★ repo把视频分析为结构化理解索引:场景检测、ASR 转写、逐场景 VLM 观察、静音窗口、融合时间线和写作 brief。 用于理解、索引或总结视频,也作为后续创作前的分析阶段。输入视频文件;输出 scenes.json、 asr_result.json、vlm_analysis.json、silence_periods.json、timeline_fusion.json、agent_narration_brief.md。 触发词:视频理解、视频分析、视频索引、video understanding、analyze video、看懂视频。
worldwonderer/video-recap-skills/skills/video-voiceover Skill
637★ repo把带时间戳的 narration.json 合成为中文解说音频。使用 MiMo TTS(mimo-v2.5-tts)逐段生成语音, 按时间窗动态适配语速并处理响度;输入输出时间线上的旁白,产出 tts_segments 与 tts_meta.json。 旧版直接剪辑路径也可显式传入 narration_mapped.json。触发词:配音、语音合成、TTS、解说配音、 voiceover、text to speech、旁白配音。
nWave-ai/nWave/nWave/skills/nw-diagram Skill
636★ repoGenerates C4 architecture diagrams (context, container, component) in Mermaid or PlantUML. Use when creating or updating architecture visualizations.
sparklabx/drawio-ai-kit/skills/drawio-databricks Skill
626★ repoUse when the user asks for a Databricks lakehouse architecture diagram — medallion architecture (Bronze/Silver/Gold), Delta Lake, Unity Catalog, workspace deployment, data-plane/control-plane, or any diagram built with Databricks icons. Builds with the declarative layout engine using ground-truth stencils, validates (stencils/colors/nesting/geometry), runs a render-based vision self-check. Default output is .drawio; PNG/SVG only on request.
sparklabx/drawio-ai-kit/skills/drawio-gcp Skill
626★ repoUse when the user asks for a GCP or Google Cloud architecture diagram — VPC/networking, GKE, Cloud Run, landing zone, multi-region, or any diagram built with GCP service icons. Builds with the declarative layout engine using ground-truth GCP stencils, validates (stencils/colors/nesting/geometry), runs a render-based vision self-check. Default output is .drawio; PNG/SVG only on request.
rshankras/claude-code-apple-skills/skills/growth/press-media Skill
621★ repoGet press coverage and media attention for your indie app. Covers press kit preparation, finding journalists/bloggers/YouTubers, pitch timing, embargo strategy, and story angles that get coverage. Use when user wants press coverage, is preparing for a launch, or wants to build a media kit.
linzzzzzz/openclip/.trae/skills/video-clip-extractor Skill
580★ repoProcesses videos to identify engaging moments, generate transcripts, and create highlight clips with artistic titles and custom cover images. Use when user needs to: extract highlights from long videos or livestreams, clip or cut best moments from videos, cut video highlights, process Bilibili/YouTube URLs or local video files, generate transcripts via Whisper, analyze content for engaging moments, create short-form clips with styled titles and covers, adjust cover text position and colors, find and export memorable scenes from recordings, burn subtitles into clips (with optional translation), guide clip selection with user intent, or identify speakers in multi-person conversations.
product-on-purpose/pm-skills/skills/discover-journey-map Skill
559★ repoMaps a customer journey across stages, touchpoints, emotional curve, pain points, and moments of truth into a markdown artifact with an optional mermaid timeline or flowchart. Use when synthesizing existing research into the shape of a customer's experience, end-to-end or for one phase. Without research signal yet, run discover-interview-synthesis or measure-survey-analysis first; refuses to fabricate emotional or behavioral data.
The same file is in 1 other repository
ECNU-ICALK/AutoSkill/SkillBank/Common/anthropics-skill/docx Skill
no license551★ repoUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.
ECNU-ICALK/AutoSkill/SkillBank/Common/anthropics-skill/pdf Skill
no license551★ repoUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill.
ECNU-ICALK/AutoSkill/SkillBank/Common/anthropics-skill/pptx Skill
no license551★ repoUse this skill any time a .pptx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates, layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx filename, regardless of what they plan to do with the content afterward. If a .pptx file needs to be opened, created, or touched, use this skill.
ECNU-ICALK/AutoSkill/SkillBank/Common/anthropics-skill/xlsx Skill
no license551★ repoUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
ECNU-ICALK/AutoSkill/SkillBank/Common/baoyu-skills/baoyu-slide-deck Skill
no license551★ repoGenerates professional slide deck images from content. Creates outlines with style instructions, then generates individual slide images. Use when user asks to "create slides", "make a presentation", "generate deck", "slide deck", or "PPT".
ECNU-ICALK/AutoSkill/SkillBank/Common/remotion-de-skills/remotion Skill
no license551★ repoBest practices for Remotion - Video creation in React
Typescript 인터페이스 순서 기반 xlsx 엑셀 다운로드 구현
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/Korean/typescript-인터페이스-순서-기반-xlsx-엑셀-다운로드-구현 Skill
no license551★ repo사용자가 정의한 TypeScript 인터페이스의 속성 순서를 기준으로 데이터 배열을 변환하고, xlsx 라이브러리를 사용하여 엑셀 파일로 다운로드하는 함수를 작성합니다.
Ferramenta python de divisão de áudio com gui e ffmpeg local
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/Portuguese/ferramenta-python-de-divisão-de-áudio-com-gui-e-ffmpeg-local Skill
no license551★ repoCria um script Python completo com interface gráfica (Tkinter) para dividir arquivos de áudio em segmentos, utilizando um executável FFmpeg localizado na mesma pasta do script.
Генерация pdf из markdown с точным академическим форматированием
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/Russian/генерация-pdf-из-markdown-с-точным-академическим-форматированием Skill
no license551★ repoНавык по созданию PDF-документов из Markdown с соблюдением строгих академических требований (шрифт 14 пт, межстрочный интервал 1.5, формат А4) с использованием Pandoc и пользовательского шаблона LaTeX для сохранения стилей и цветов.
Configuración y edición de video vertical en adobe premiere cs6
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/Spanish/configuración-y-edición-de-video-vertical-en-adobe-premiere-cs6 Skill
no license551★ repoGuía especializada para configurar secuencias verticales, corregir la orientación de clips en masa, aplicar efectos dinámicos y exportar videos optimizados para Instagram utilizando exclusivamente funciones de Adobe Premiere CS6.
Extraer números y texto iniciales en excel con separador punto y
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/Spanish/extraer-números-y-texto-iniciales-en-excel-con-separador-punto-y Skill
no license551★ repoGenera fórmulas de Excel para separar el número inicial del texto restante en celdas donde el número está pegado al texto, utilizando obligatoriamente el separador de punto y coma (;).
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/chinese_gpt3.5_8/excel-vba-在每行数据上方插入表头 Skill
no license551★ repo编写VBA代码,在Excel工作表的每一行非空数据上方插入指定的表头行,支持动态获取行数并通过按钮触发。
Excel vba batch hyperlink processor
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/chinese_gpt3.5_8/excel_vba_batch_hyperlink_processor Skill
no license551★ repo用于编写VBA宏,批量处理Excel中的超链接。支持将绝对路径转换为相对路径以解决共享问题,或根据文件夹名称批量创建指向本地文件夹的超链接,并自动校验文件存在性。
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/chinese_gpt3.5_8/python-ffmpeg-图片序列合并与拆分工具 Skill
no license551★ repo生成Python脚本,利用FFmpeg将图片序列按3x3布局合并,或将合并图拆分。要求使用subprocess模块执行命令,并支持用户交互式输入路径。
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/chinese_gpt4_8_GLM4.7/excel_chinese_text_clustering Skill
no license551★ repo从Excel读取中文文本,支持基于句法树结构(如深度、词性)或语义向量(如TF-IDF、SentenceTransformer)的特征提取,执行聚类分析(如K-Means、DBSCAN),并将结果导出回Excel。
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/chinese_gpt4_8_GLM4.7/ocr_medical_receipt_extractor Skill
no license551★ repo从OCR识别后的医疗单据文本中提取日期、医生姓名、患者姓名、诊断和总消费金额,具备文本矫正和关键字识别能力,并以JSON格式输出。
Batch transcript q a with completion trigger
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/batch-transcript-q-a-with-completion-trigger Skill
no license551★ repoAccumulate content provided in multiple batches and wait for a specific completion phrase before answering questions or analyzing the text.
Clean database output for excel
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/clean-database-output-for-excel Skill
no license551★ repoTransforms raw database query results into professional, Excel-ready tables by removing metadata and rounding numbers.
Excel date filter and concatenate formula generator
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-date-filter-and-concatenate-formula-generator Skill
no license551★ repoGenerates Excel formulas to filter rows based on a date offset from today, format the date, and concatenate values from adjacent columns with specific spacing.
Excel date proximity comparison formula
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-date-proximity-comparison-formula Skill
no license551★ repoGenerates an Excel formula to compare a date cell against two text-based day/month references to determine if the date is closer to the previous or next month, including handling for empty date cells.
Excel date range parsing formulas
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-date-range-parsing-formulas Skill
no license551★ repoGenerates Excel formulas to extract and format start and end dates from a string formatted as 'Day DD Mon YYYY - Day DD Mon YYYY' into 'dd mm yyyy' format.
Excel financial analysis inventory days and goodwill by sector
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-financial-analysis-inventory-days-and-goodwill-by-sector Skill
no license551★ repoGuides the user through calculating days inventory in stock and goodwill ratios in Excel, grouping data by business sectors derived from SIC codes.
Excel merging and transformation pipeline
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-merging-and-transformation-pipeline Skill
no license551★ repoMerges multiple Excel files selected via GUI, applies specific column transformations (filename extraction, pipe-delimited splitting, arithmetic calculation, renaming), and enriches data using a mapping file.
Excel to word vba data transfer
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-to-word-vba-data-transfer Skill
no license551★ repoGenerates VBA code for Microsoft Word to automatically pull data from an active Excel workbook into a Word table when the document opens.
Excel vba composite key duplicate prevention
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-vba-composite-key-duplicate-prevention Skill
no license551★ repoGenerates a VBA Worksheet_Change macro to prevent duplicate entries based on two columns (e.g., Company Name and Invoice Value). It triggers on entry in the second column, checks for existing matching pairs, alerts the user with the row number of the duplicate, and clears the new entry.