excel-data-analysis-and-report-generation

To generate an Excel analysis report, this skill extracts multi-type spreadsheet data, performs keyword-based category mapping on a target column, and renders a pie chart for category share alongside an exported XLSX statistical table.

Yes, you can build a crosstab comparison by specifying a group column. The skill generates crosstab-style comparisons between the group column and derived categories, including totals for quick cross-dimension insight.

Threshold exceedance detection identifies rows where target values exceed assigned limits. It uses backward lookup tied to nearby limit and keyword markers to assign severity based on how far the exceedance goes.

You need an Excel dataset with a target column for category mapping, an optional group column for crosstab generation, and limit or keyword markers if you require threshold-based alerting and exceedance detection.

Yes, the tool supports exporting high-resolution chart images. It renders a pie chart for category distribution and exports the underlying statistical table as an analysis_result.xlsx file with sandbox download links.

The best way to analyze category distributions is using keyword-based category mapping on a target column. This process calculates counts, percentages, and a total row, then visualizes the share as a pie chart.