584 skills · sorted by relevance
Update or create Excel workbooks with checks against the requested structure. Identify the correct file before editing, then reread the saved workbook to verify sheet names, populated columns, row counts, and selected sample counts.
Build complex Excel files in four stages: extraction, preparation, calculation, and formatted output. Intermediate CSV files let agents and reviewers inspect data, validate forecasts, locate errors, and rerun individual stages without repeating the entire workflow.
Scan multiple Excel sheets for rows with missing or invalid entries in a target column. Combine matching records with their source sheet names, then export an Excel file with every extracted data row filled red for review.
Calculate averages for selected groups in Excel and sum items extracted from specified row ranges after removing duplicates. Save filtered records, summary statistics, and item totals as Excel files with local download links.
Clean a target Excel column, convert its values to numbers, and compare the calculated total with a summary sheet. Export the totals, match status, and difference in Excel and CSV files.
Compare counts and shares for two categories in Excel data. The skill cleans the selected columns, calculates differences and percentages, and produces a summary spreadsheet plus bar and pie charts.
Analyze a selected entity’s time series in Excel, calculate its average, and export a formatted report showing differences from that average. Rows below the average are highlighted in green for easy comparison.
Create and edit Excel workbooks, analyze spreadsheet data, and visualize results. Preserve existing formatting, use formulas that update when inputs change, and recalculate workbooks to identify formula errors before delivering the finished files.
Read, create, and edit Excel workbooks, including formulas, formatting, charts, and multiple sheets. Clean CSV or TSV tables and prepare spreadsheet deliverables, with guidance on choosing fixed calculated values or formulas that update later.
Generate an Excel workbook file in an agent session without an open Office app. Use Python and openpyxl to organize inputs, formulas, and checks, then save the .xlsx file and return its relative path.
Create, inspect, and update Excel workbooks, including CSV imports, formulas, charts, and pivot tables that summarize data. Build budgets, dashboards, or trackers with readable formatting, input validation, and checks for formula errors.
Create or modify Excel workbooks, then independently check the saved file with Python. Verify required sheets, columns, populated cells, row counts, and sample selections against the requested structure before reporting the work as complete.
Create formatted Excel files when sandbox code execution fails by running Python through the shell. Uses openpyxl to add styled headers, alternating row colors, borders, alignment, and adjusted column widths.
Create Excel files with openpyxl, a Python spreadsheet library, by switching to shell execution when sandbox tools fail. Examples cover cell styling, formulas, merged cells, multiple sheets, error reporting, and checking that the output file exists.
Combine data from multiple Excel sheets, clean inconsistent labels and merged cells, and summarize counts by category. Create Excel summary tables with percentages and totals, plus labeled bar charts for comparing categories.
Filter Excel rows using conditions across several numeric columns. Count rows across sheets, convert selected fields to numbers, remove duplicate rows and records with missing identifiers, then export the filtered results to a new workbook.
Prepare large Excel datasets by combining sheets, using Parquet, a format for efficient table storage, and cleaning a selected text column to retain only Chinese characters. Export the cleaned data as an Excel file with a local download link.
Analyze Excel workbooks across multiple sheets, locate matching fields, clean values, and compare groups. Produce counts, cross-tabulations that compare categories, charts, and an Excel report with a download link.
Clean categorical Excel data and compare counts and percentage shares across groups. Create cross-tabulation tables, heatmaps that show differences through color, and category rankings, then export the analysis to a workbook with multiple sheets.
Extract text and data from images of charts, tables, interfaces, and diagrams using a vision model, an AI that reads images. Turn the results into structured tables, recreate charts, or export data to Excel and CSV.
Check Excel measurements against limits written in the sheet, highlight rows exceeding those limits and cells containing division errors, and export a summary showing structure names, measured values, limits, and differences.
Turn CSV, Excel, or JSON data into a complete HTML report with key metrics, multiple charts, written insights, and a data table. Embedded charts let readers open the report offline.
Build an Excel workbook linking the income statement, balance sheet, and cash flow statement. Populate historical figures, create formula-based forecasts, compare scenarios, and check that balances and cash totals agree across all three statements.
Analyze Excel and CSV files to summarize statistics, filter records, compare groups, and join data across sheets or files. Export results as CSV, JSON, or Markdown tables for further work or sharing.