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.

• Comparing counts for two categories
• Visualizing category shares
• Cleaning merged-cell data before counting

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.

• Summarize Excel records using custom categories
• Compare category distributions across groups
• Score and grade text using adjustable rules

Count categories in a chosen data column after removing missing values and placeholder labels. Calculate each category’s share and create high-resolution charts combining counts, percentages, pie charts, and horizontal bars for distribution reports.

• Compare record counts across categories
• Show category shares with pie and bar charts
• Exclude placeholder labels before counting

Clean category and numeric fields in structured data, compare groups with counts and cross-tabulations, and produce charts, Excel results, and a Markdown report. Export visuals as high-resolution PNG and SVG files for use in reports.

• Compare category distributions across groups
• Clean category labels and fill merged-cell gaps
• Export analysis results to Excel

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.

• Filtering rows by RGB values or identifier prefixes
• Converting text to numbers and calculating totals or averages
• Extracting matching commands with their identifiers and descriptions

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.

• Count records containing a specified risk level by work category
• Calculate group shares among matching records
• Summarize large datasets already converted to Parquet