P
📊Analyse de donnéesIntermediateAll AIs

Advanced Excel formulas for data analysis

Provides advanced Excel formulas tailored to specific analysis problems with explanations and variants.

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

Je travaille dans Excel [VERSION] et j'ai besoin de formules avancées pour analyser [DESCRIPTION_DONNEES]. Mon fichier contient [DESCRIPTION_STRUCTURE] (ex : données de ventes sur plusieurs feuilles, base clients avec historique).

Problèmes à résoudre :

  1. [PROBLEME_1] (ex : consolider des données de plusieurs onglets par critère)
  2. [PROBLEME_2] (ex : calculer un classement avec gestion des ex-æquo)
  3. [PROBLEME_3] (ex : extraire les N premières valeurs selon plusieurs critères)
  4. [PROBLEME_4] (ex : créer un tableau de bord dynamique avec filtres)

Fournis pour chaque problème :

  • La formule complète et directement utilisable
  • Une explication de la logique étape par étape
  • Les variantes pour différentes versions d'Excel (2019, 365, Mac)
  • Les erreurs courantes et comment les éviter
  • Une version alternative avec des formules plus simples si disponible

Inclus aussi des formules pour : SOMME.SI.ENS, NB.SI.ENS, RECHERCHEV vs XLOOKUP, LET pour la lisibilité, et les nouvelles fonctions de tableaux dynamiques (FILTRE, TRIER, UNIQUE).

Personalize this prompt with Léa

Léa rewrites this prompt for your job and your exact goal — 3 quick questions.

Why this prompt works

<p>The prompt is effective because it requests both the formulas, their logical explanation, and alternatives depending on the Excel version, covering all practical use cases encountered by analysts.</p>

Use Cases

Commercial data analysisMulti-source consolidationDynamic Excel dashboard

Expected Output

Complete Excel formulas for each problem with explanations, version variants, and simplified alternatives.

Improve this prompt

Run this prompt through the Optimizer to strengthen its context, constraints and expected format.

Improve this prompt with the Optimizer

Comments

  • LéaAI

    Utilisez la combinaison FILTRE + TRIER + UNIQUE pour générer des listes dynamiques sans formules matricielles. Par exemple, `=TRIER(UNIQUE(FILTRE

Glossary Terms

ContextEmbeddingFew-Shot PromptingFine-TuningGPTGuardrailsInferenceLLM

📬 Get new prompts every week

Join our newsletter and never miss a prompt.

Go further

Improve this prompt with the Optimizer

Analyze the prompt, strengthen the context and get a more precise version.

Prompt Engineering

Cross-model principles for writing more reliable prompts.

Similar Prompts

📊Analyse de donnéesIntermediateClaude

Prompt Claude to Analyze User Feedback

Analyzing user feedback is a strategic lever for any company looking to improve its products and services. However, manually processing hundreds or even thousands of customer reviews is time-consuming and prone to interpretation bias. Claude excels at this task thanks to its ability to understand natural language nuances, detect implicit sentiments, and automatically categorize feedback along relevant axes. Whether it's product reviews, support tickets, NPS survey responses, or social media comments, Claude can extract actionable insights in seconds. By properly structuring your prompt, you get a systematic analysis that identifies recurring trends, prioritizes problems by impact, and provides concrete recommendations. This approach transforms raw qualitative data into a clear decision-making dashboard, allowing product, support, and marketing teams to act quickly on friction points identified by your users.

0267
📊Analyse de donnéesIntermediateAll AIs

Extract and structure HTML content

Extract structured data from HTML pages

0214
📊Analyse de donnéesBeginnerAll AIs

Choose the right visualization for your data

Guide the choice of optimal chart type based on data, audience, and message to communicate.

0451
📊Analyse de donnéesIntermediateAll AIs

DALL-E Prompt for Analyzing User Feedback

DALL-E, OpenAI's image generation model, provides a unique visual approach for transforming user feedback into actionable graphical representations. Instead of limiting itself to text analysis, DALL-E enables the creation of infographics, sentiment maps, stylized word clouds, and visual dashboards that summarize customer feedback in an instantly understandable way. This approach is particularly valuable for product, UX, and marketing teams who need to communicate insights to non-technical stakeholders. By generating impactful visuals from qualitative data, you facilitate decision-making and make trends visible at a glance. Whether you want to illustrate sentiment distribution, highlight recurring friction points, or create an impactful presentation asset, DALL-E transforms your raw data into visual storytelling. This guide accompanies you with optimized prompts to fully leverage this capability, from simple word clouds to complete analytical infographics.

0259