AI Tools for Microsoft Excel
Formulas, VBA, Power Query, dashboards and analysis. Pick a tool below to generate a tailored prompt with examples, common mistakes to avoid, and best practices.
Create Formulas
Writes correct Excel formulas from a plain-English description.
Open toolFix Formulas
Diagnoses and repairs broken Excel formulas and errors.
Open toolVBA Generation
Generates VBA macros to automate repetitive Excel tasks.
Open toolPower Query
Builds Power Query (M) steps to clean and reshape data.
Open toolPivot Tables
Designs pivot tables and explains the field layout.
Open toolDashboards
Plans an interactive Excel dashboard layout and charts.
Open toolCharts
Recommends and configures the right chart for your data.
Open toolConditional Formatting
Creates conditional formatting rules to highlight data.
Open toolFinancial Models
Builds financial model structures and formulas.
Open toolData Cleaning
Cleans, standardizes and deduplicates messy datasets.
Open tool