1K skills ・ Works with: Excel · sorted by popularity
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.
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.
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.
Analyze Excel data using custom categories, count distributions, and compare groups with charts. Score text using its length, technical terms, numbers, and selected complex concepts, then visualize difficulty levels and the relationship between text length and scores.
Combine selected columns from multiple Excel sheets, fill blank category cells with the preceding value, and rank records by a chosen metric. Export the top results to an Excel report with headings, borders, and formatted numbers.
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.
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.
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.
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 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.
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.
Extract coefficients associated with a chosen label across Excel sheets and check them against a standard value. Create a comparison workbook showing each value, its source sheet, and red highlighting for rows that fail the check.
Analyze Excel datasets totaling at least 10,000 rows using an existing Parquet file, a column-based data format. Extract a chosen metric, identify the category with the highest value, and export an Excel summary with that row highlighted.
Analyze trends and group performance in Excel data, clean percentage values, and calculate projections using growth rates assigned by performance tier. Produce comparison charts and a summary of current totals, projected totals, and growth.
Extract and analyze text, tables, numbers, and charts from Word, PDF, and PowerPoint documents. Process complete files or document collections, aggregate findings, and verify counts, calculations, and units before presenting answers.
Clean category data in Excel, group entries, and calculate counts, totals, and shares. Create a summary spreadsheet with a total row and highlighted maximum values, alongside a bar chart for comparing groups.
Extract key metrics from spreadsheet data, check whether recorded values match calculations after unit conversion, and rank selected metrics from highest to lowest. Export the ranking or validation results to an Excel file for download.
Organize Excel analysis from reading multiple sheets through cleaning, filtering, aggregation, and export. Choose processing methods based on row counts, and use supporting skills to produce tables, charts, and Excel or CSV reports.
Analyze Excel files with 10,000 or more rows using reading methods suited to their size. Convert data to Parquet, a column-based storage format, reduce memory use, and prepare summaries, charts, or filtered exports.
Combine selected data from multiple Excel sheets, clean numeric values, and extract the highest entries for a chosen metric. Create a ranked Excel report with highlighted columns, borders, column widths, and number formats for easier comparison.
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.
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.
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.