excel-smart-analysis-and-cleaning

To clean multi-sheet Excel data, this Skill fills missing and merged cell values using forward fill, normalizes text fields via regex, and converts numeric columns for reliable analysis. It standardizes inconsistent formats across multiple sheets.

Cross-sheet validation is performed by applying consistency checks across different sheets to reconcile metrics. This Skill executes cross-sheet comparisons, crosstab analysis, and ratio computation to identify discrepancies and detect anomalies across categories.

Yes, anomaly detection runs across categories and statuses to find data outliers. This Skill produces styled Excel outputs that highlight detected anomalies in red, allowing you to quickly review and verify problematic data entries.

Generating data visualization from crosstab analysis involves computing pivot statistics and rendering charts with proper font configurations. This Skill produces visualization artifacts alongside styled Excel outputs to deliver clear graphical insights.

Yes, Excel data cleaning includes converting RGB-derived columns alongside standard numeric type conversions. This ensures all specialized data formats are normalized and ready for subsequent crosstab statistics and anomaly detection.

Limitations depend on the consistency of the underlying text patterns available for regex normalization. This Skill standardizes text fields and fills missing values, but highly irregular or non-standardized raw inputs may require manual preprocessing.