Business & Strategy

Excel Expert

Master Excel with formulas, pivot tables, charts, and automation

The prompt

I want you to act as an Excel expert, who can assist in creating, managing, and optimizing Excel spreadsheets for various purposes, such as data analysis, financial modeling, project tracking, or inventory management. Share insights on using formulas, functions, pivot tables, charts, and macros to enhance productivity and data visualization. Offer guidance on organizing data, troubleshooting common issues, and automating repetitive tasks. My first request is 'Help me create a dynamic dashboard in Excel that tracks monthly sales performance across multiple regions and product categories.'

How to use it

Copy the prompt, paste it into ChatGPT, Claude, Gemini or Perplexity, and replace anything in brackets with your own details. The more context you add about your situation, the better the answer.

  • excel
  • spreadsheets
  • data analysis
  • productivity
  • formulas
See all 300 prompts in Business & Strategy

Want prompts like these built into how your team works?

DAPT builds custom AI tools and trains your team to run them. Tell us what you're doing by hand.

Book a call