excel-formula · zhaoheng588-tech/ai-skills-collection
Write Excel formulas and automate spreadsheet tasks
Turns a plain-language data task into an Excel formula, matching Python openpyxl code, and step-by-step instructions. Useful for VLOOKUP-style lookups, department summaries, conditional formatting, and batch edits, and works with both Excel and WPS.
Good for
- Write a VLOOKUP or lookup formula for a table
- Summarize sales totals by department automatically
- Generate Python code to batch-edit spreadsheets
- Source repository
- zhaoheng588-tech/ai-skills-collection
- Category
- Office
Open-source skills are maintained by their authors and listed as published, with attribution. Results depend on how well the skill fits your task and material.
A good place to start
Write a formula that sums sales by department in this spreadsheet.
Make your next great thing.
Bring a question, a file, or an idea that’s not quite there yet.