From their FAQ “Claude doesn’t have advanced Excel capabilities including pivot tables, conditional formatting, data validation, data tables, macros, and VBA. We’re actively working on these features.”