AI Prompt Library

Current Category:
Analysis
Category Name
Analyze a Wardley Map
Apply the Jobs-To-Be-Done (JTBD) to user calls
Apply the Smart Brevity framework
Brainstorm programming strategies
Build awareness for a TV show
Clean Communication: Feelings & Needs
Clean Communication: Levels of Conversation
Compile Customer Feedback for Executive Summary
Comprehensive grammar and proofreading check
Conduct a SWOT analysis + get insights
Conduct a category analysis
Conduct a landscape analysis
Craft a detailed book review
Craft compelling stakeholder updates
Create Facebook ads ideas
Create SMART goals
Create a marketing campaign mad-libs style
Create a product roadmap
Create a training document based on your content
Create an excel formula
Create company memos
Create customer followup emails
Create marketing campaigns using various frameworks
Create social media campaign ideas
Critique and Improve my content
Determine how well content matches a style guide
Distill insights into key messages
Executive Summary + Top 10 Improvement Tips
Find customer pain points
Find hidden insights in my data
Find the best answer + alternatives
Generate Targeted Interview Questions
Generate a Meeting Summary
Generate a blog post from a technical documentation
Generate a blog post from a technical documentation
Generate a marketing one-pager
Generate a product technical documentation
Generate an AI prompt
Generate an executive business review + SWOT analysis
Generate an investment proposal
Generate development plans for employees
Generate product feedback based on customer calls
Generate webinar ideas
Get action items from a meeting

Create an excel formula

Use this prompt

What this prompt can help you accomplish

This prompt is designed to assist you in creating advanced Excel formulas by guiding you on how to create formulas in Excel to perform complex calculations or data manipulations. It ensures that the formulas provided are tailored to your specific needs and are accompanied by detailed explanations. Whether you need to add a formula in Excel or tackle more intricate tasks, this tool supports you in writing formulas that accurately meet your requirements.

What content you'll need to provide

To use this prompt effectively, you need a clear description of the desired outcome or operation in Excel. Before crafting the formula, gather all necessary information, including relevant cell ranges, specific conditions, multiple criteria, or desired output formats. This will help you in the process of creating formulas in Excel that are both precise and effective. Understanding how to write a formula in Excel, based on this detailed information, will facilitate achieving the results you seek.

Here's the prompt

As an Excel Formula Expert, your task is to provide advanced Excel formulas that perform the complex calculations or data manipulations described by the user. If the user does not provide this information, ask the user to describe the desired outcome or operation they want to perform in Excel. Make sure to gather all the necessary information you need to write a complete formula, such as the relevant cell ranges, specific conditions, multiple criteria, or desired output format. Once you have a clear understanding of the user’s requirements, provide a detailed explanation of the Excel formula that would achieve the desired result. Break down the formula into its components, explaining the purpose and function of each part and how they work together. Additionally, provide any necessary context or tips for using the formula effectively within an Excel worksheet.

Copy Prompt

Learn how to get more in-depth answers:

  • Getting the answer you need from SmartChat™ often means going deeper into the content after your first prompt above, which you can accomplish by:
    • Choosing the "Go Deeper" functionality on any part of Storytell's response
    • Asking followup questions (we'll provide you with some suggested followup prompts)

On this page

Use this prompt