1K skills ・ Works with: Excel · sorted by popularity
Create, edit, and analyze spreadsheets with formulas, formatting, and visualizations. Preserve existing workbook conventions, keep calculations responsive to input changes, and use formula recalculation and error checks to verify the resulting files.
Bring articles, YouTube videos, documents, and other sources into NotebookLM to create audio, slides, reports, and study materials. It also supports deeper analysis through a series of questions, with optional export to 飞书 documents.
Check whether tools for mathematical modeling, numerical analysis, charts, and paper compilation are installed. Get a report separating required and optional dependencies, platform-specific installation commands, and a follow-up check after approved installation.
Develop and fix Nexent features by connecting written specifications, acceptance criteria, implementation, and verification evidence. Plan unit tests and appropriate staged checks, maintain their links to requirements, and fill confirmed test gaps after development.
Organize Nexent test assets into a traceable chain from requirements and bugs to cases, scripts, and results. Review existing coverage, maintain execution settings, and generate a registry and Excel views for formal testing.
Turn research results into figures and tables for papers using pubfig and pubtab. Choose an appropriate presentation, convert Excel tables to LaTeX, export assets, and check readability, labels, and consistency before submission.
Extract keyword-matched entries from an Excel sheet, clean whitespace and empty values, and count distinct entries by category. Export separate Excel files containing summary counts and detailed lists for review.
Clean Excel columns by removing unwanted prefixes from numeric values and extracting Chinese characters from text. Add the cleaned results as new columns, then save an Excel file and provide a download link.
Filter rows from Excel or previously converted Parquet files, a format designed for efficient data storage. Summarize matching records by group with counts, percentages, and totals, then export the summary to Excel.
Clean numeric columns in Excel, filter records above a chosen threshold, and count matching rows. The skill also covers checking row totals across sheets and marking qualifying cells with formatting for export.
Filter rows from a selected Excel sheet, summarize category counts and percentages, and export the required columns to a new workbook. The workflow also cleans filter values, renames columns, and provides a download link.
Inspect multi-sheet Excel files, use Parquet, a column-based file format, for larger datasets, and clean text before analysis. Produce category summaries, identify maximum values, and export formatted reports or scatter plots with fitted straight trend lines.
Count rows across Excel sheets to assess data size, then analyze an existing Parquet file, a format for storing tabular data. Calculate category counts and percentages, and save the results as an Excel summary and a pie chart.
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.
Extract selected ranges from Excel workbooks with multiple sheets, check missing values, and clean numeric data. Fit a straight trend line, save charts and CSV results, and convert larger tables to Parquet for subsequent analysis.
Analyze one Excel worksheet by cleaning column names, extracting numbers, and handling gaps from merged cells. Create category counts, percentages, cross-tabulations comparing groups, high-resolution charts, and CSV exports, with Parquet storage for the data.
Filter Excel data using candidate column names, RGB color values, text prefixes, and regular expressions, which match text patterns. Calculate totals and averages, then export results to Excel with highlighted rows and a download link.
Clean data across multiple Excel sheets, compare totals between sheets, and summarize categories and proportions. Create charts and export a formatted workbook with unusual values highlighted for review.
Clean Excel data, summarize groups, and examine relationships between numeric columns. Produce charts such as scatter plots with trend lines, calculate measures of fit and statistical significance, and export cleaned data and statistical summaries.
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.
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.
Find key figures in tabular data using column names or row keywords, calculate category averages and percentages, and export the results as a structured Excel report and a pie chart.
Clean Excel data and group records with similar numerical features. Produce a combined view of indicator trends, value distributions, category shares, and grouped data, then export the charts as an image and cleaned records as Excel.
Analyze large Excel workbooks by totaling values by category and identifying the highest result. The workflow can convert data to Parquet, a column-based storage format, and export a styled Excel report with highlighted results.