Claude Prompt Generator | Free AI tool

Sam Altwoman
6

Want to Generate the best prompt for Claude AI? Use this Tool to Instantly Create Professional Claude Prompts!

Chatbot

Introduction

Ultimate Claude Prompts Generator

Welcome to the Ultimate Claude AI Prompts Generator!

Introduction to Claude AI Prompting

Claude is an AI assistant created by Anthropic that is designed to be helpful, honest, and harmless. It communicates through natural language dialogue and can be instructed using regular conversational requests, similar to how you would make requests of a human. The quality of the instructions given to Claude can significantly impact the quality of its outputs, especially for complex tasks.

How to Write the Best Claude Prompt

What is a Prompt?

A prompt is the text given to Claude to elicit a relevant output, usually in the form of a question or instructions. For example:

User:

Why is the sky blue?

The text that Claude responds with is called a "response," sometimes also referred to as an "output" or "completion."

How Claude Works

Claude is a conversational assistant based on a large language model (LLM). It uses the text you have sent (your prompt) and the text it has generated so far to predict the next most helpful token. This means that Claude constructs its responses one set of characters at a time, in order, and cannot go back to edit its response after it has been written, unless given a chance to do so in a subsequent prompt.

Claude can only see and make predictions based on what is in its context window. It cannot remember previous conversations unless they are included in the prompt, and it cannot open links.

Prompt Length and Context Window

The maximum prompt length that Claude can process is determined by its context window size, which varies depending on the model being used. It's important to keep the prompt within the context window to ensure Claude can fully understand and respond to the input.

Prompt Engineering

Prompt engineering involves creating effective prompts to enhance Claude's performance. This includes following best practices, avoiding common pitfalls, and experimenting with different prompts and techniques to see how they impact Claude's responses. The Anthropic cookbook provides code examples with accompanying prompts for various use cases and capabilities.

Prompt Library and Metaprompt

Anthropic offers a prompt library featuring an extensive collection of prompts for various use cases, covering both work and play. This resource is helpful for exploring ideas and understanding how to use Claude to solve specific problems.

Additionally, an experimental helper metaprompt is available, which prompts Claude to create a prompt based on the guidelines you provide. While the metaprompt is experimental, it can be useful for drafting initial prompts or quickly creating many prompt variations.

Top 10 Best Claude AI Prompts:

Best Claude Prompt for Interview Questions

System Prompt:

Your task is to generate a series of thoughtful, open-ended questions for an interview based on the given context. The questions should be designed to elicit insightful and detailed responses from the interviewee, allowing them to showcase their knowledge, experience, and critical thinking skills. Avoid yes/no questions or those with obvious answers. Instead, focus on questions that encourage reflection, self-assessment, and the sharing of specific examples or anecdotes.

User Prompt:

You are interviewing a candidate for a marketing manager position at a well-established e-commerce company. The ideal candidate should have experience developing and executing multi-channel marketing campaigns, strong analytical skills, and the ability to collaborate effectively with cross-functional teams. They should also be passionate about staying up-to-date with the latest marketing trends and technologies.

Sample Output:

1. Can you walk me through a successful multi-channel marketing campaign you developed and executed in your previous role? What were the challenges you faced, and how did you overcome them?

2. How do you measure the success of your marketing campaigns, and what metrics do you focus on? Can you provide an example of how you used data and analytics to optimize a campaign's performance?

3. In your experience, what are the key elements of a successful e-commerce marketing strategy? How do you ensure that your strategies align with the company's overall business objectives?

4. Can you share an example of a time when you had to collaborate with a cross-functional team (e.g., product, sales, or customer service) to achieve a marketing goal? What challenges did you encounter, and how did you foster effective collaboration?

5. How do you stay informed about the latest marketing trends and technologies, and how have you applied this knowledge to improve your marketing strategies or campaigns?

6. Can you describe a time when a marketing campaign you were involved in didn't perform as expected? What did you learn from the experience, and how did you apply those lessons to future campaigns?

7. Our company values innovation and continuous improvement. Can you share an example of a time when you introduced a new marketing approach, tool, or technology that significantly impacted your team's performance or results?

Claude Prompts for AI Career coach

System Prompt:


Here are some important rules for the interaction:

- Always stay in character, as Joe, an AI from AI Career Coach Co.
- If you are unsure how to respond, say "Sorry, I didn't understand that. Could you rephrase your question?"

Here is the conversational history (between the user and you) prior to the question. It could be empty if there is no history:
<history>
User: Hi, I hope you're well. I just want to let you know that I'm excited to start chatting with you!
Joe: Good to meet you! I am Joe, an AI career coach created by AdAstra Careers. What can I help you with today?
</history>

User Prompt:

I keep reading all these articles about how AI is going to change everything and I want to shift my career to be in AI. However, I don't have any of the requisite skills. How do I shift over?

Sample Output:

I'm glad you're interested in shifting your career into the AI field. It's an exciting and rapidly growing area with a lot of opportunities.

Since you mentioned not having the requisite skills yet, my advice would be to start building them up through education and training. A few potential paths you could take:

1. Get a degree: Consider going back to school for a master's degree or even a second bachelor's in a field like computer science, data science, applied math or statistics. Having that foundational knowledge in areas like programming, algorithms, and machine learning will be invaluable.
2. Take online courses: If going back for a full degree isn't feasible, look into taking online courses or getting certifications through platforms like Coursera, Udacity, edX etc. Many top universities and companies offer AI/ML courses you can take remotely.
3. Get hands-on experience: Look for entry-level job opportunities, internships or freelance projects where you can start applying AI skills and techniques. Build a portfolio of projects to demonstrate your abilities.
Learn tools/libraries: Get familiar with common AI development tools and libraries like TensorFlow, PyTorch, scikit-learn, Spark MLlib and more. Hands-on experience is highly valued.
4. Join communities: Get involved in AI/data science meet-up groups and online communities where you can learn from others and network.

The transition won't be easy coming from an unrelated background, but with dedication to learning and upskilling, it's definitely possible. Start taking incremental steps in the direction you want to go. Let me know if you need any other specific advice!

Claude Prompt for Teachers to Give Grades

User Prompt:

Evaluate the following two texts based on the given criteria:

Text 1:
The sun was setting behind the mountains, casting a warm golden glow across the valley. The birds chirped their evening songs as the gentle breeze rustled through the leaves. It was a peaceful and serene moment, one that filled the heart with joy and contentment.

Text 2:
The sunset was pretty. The birds were singing and the wind was blowing. It made me happy.

Criteria:
1. Descriptive language and imagery
2. Sentence structure and variety
3. Emotional impact and engagement
4. Grammar and punctuation

Sample Output:

Based on the provided criteria, here is my evaluation of the two texts:

Text 1:

1. Descriptive language and imagery: The text uses vivid and evocative language to paint a picture of the setting. Phrases like "warm golden glow," "birds chirped their evening songs," and "gentle breeze rustled through the leaves" create a strong visual and auditory imagery, immersing the reader in the scene.

2. Sentence structure and variety: The text demonstrates a good mix of sentence structures, with both simple and compound sentences. This variety helps to maintain a smooth flow and keeps the reader engaged.

3. Emotional impact and engagement: The text effectively conveys a sense of peace, joy, and contentment, inviting the reader to share in the emotional experience of the moment. The description of the setting and the use of positive language create a strong emotional connection.

4. Grammar and punctuation: The text appears to be grammatically correct and well-punctuated, with no obvious errors or issues.

Text 2:

1. Descriptive language and imagery: The text lacks detailed descriptive language and imagery. While it mentions the sunset, birds, and wind, it does not provide any vivid or evocative details to help the reader visualize the scene.

2. Sentence structure and variety: The text consists of short, simple sentences with little variation in structure. This lack of variety can make the writing feel monotonous and less engaging.

3. Emotional impact and engagement: The text conveys a positive emotion by stating "It made me happy," but it does not provide a strong emotional connection or engagement due to the lack of descriptive language and imagery.

4. Grammar and punctuation: The text appears to be grammatically correct and well-punctuated, with no obvious errors or issues.

Comparative Analysis:
Based on the evaluation, Text 1 performs significantly better than Text 2 in terms of descriptive language, imagery, sentence structure, variety, and emotional impact. Text 1 creates a vivid and immersive experience for the reader and demonstrates a higher quality of writing based on the given criteria, with its strong descriptive language, varied sentence structures, and effective emotional engagement. Text 2, while grammatically correct, lacks the descriptive richness and emotional impact present in Text 1.


Best Claude Prompt for Sentiment Analysis

System Prompt:

Your task is to analyze the provided tweet and identify the primary tone and sentiment expressed by the author. The tone should be classified as one of the following: Positive, Negative, Neutral, Humorous, Sarcastic, Enthusiastic, Angry, or Informative. The sentiment should be classified as Positive, Negative, or Neutral. Provide a brief explanation for your classifications, highlighting the key words, phrases, emoticons, or other elements that influenced your decision.

User Prompt:

Sample Tweet: Wow, I'm so impressed by the company's handling of this crisis. 🙄 They really have their priorities straight. #sarcasm #fail

Example Output:

Tone: Sarcastic
Sentiment: Negative

Best Claude Prompt for SQL:

System Prompt:

Transform the following natural language requests into valid SQL queries. Assume a database with the following tables and columns exists:

Customers:
- customer_id (INT, PRIMARY KEY)
- first_name (VARCHAR)
- last_name (VARCHAR)
- email (VARCHAR)
- phone (VARCHAR)
- address (VARCHAR)
- city (VARCHAR)
- state (VARCHAR)
- zip_code (VARCHAR)

Products:
- product_id (INT, PRIMARY KEY)
- product_name (VARCHAR)
- description (TEXT)
- category (VARCHAR)
- price (DECIMAL)
- stock_quantity (INT)

Orders:
- order_id (INT, PRIMARY KEY)
- customer_id (INT, FOREIGN KEY REFERENCES Customers)
- order_date (DATE)
- total_amount (DECIMAL)
- status (VARCHAR)

Order_Items:
- order_item_id (INT, PRIMARY KEY)
- order_id (INT, FOREIGN KEY REFERENCES Orders)
- product_id (INT, FOREIGN KEY REFERENCES Products)
- quantity (INT)
- price (DECIMAL)

Reviews:
- review_id (INT, PRIMARY KEY)
- product_id (INT, FOREIGN KEY REFERENCES Products)
- customer_id (INT, FOREIGN KEY REFERENCES Customers)
- rating (INT)
- comment (TEXT)
- review_date (DATE)

Employees:
- employee_id (INT, PRIMARY KEY)
- first_name (VARCHAR)
- last_name (VARCHAR)
- email (VARCHAR)
- phone (VARCHAR)
- hire_date (DATE)
- job_title (VARCHAR)
- department (VARCHAR)
- salary (DECIMAL)

Provide the SQL query that would retrieve the data based on the natural language request.

User Prompt:

Get the list of customers who have placed orders but have not provided any reviews, along with the total amount they have spent on orders.

Example Output:

SQL Code Per Requested.

SELECT c.first_name, c.last_name, SUM(o.total_amount) AS total_spent
FROM Customers c
INNER JOIN Orders o ON c.customer_id = o.customer_id
LEFT JOIN Reviews r ON c.customer_id = r.customer_id
WHERE r.review_id IS NULL
GROUP BY c.customer_id, c.first_name, c.last_name;

Best Claude AI Prompt for Web Design

System Prompt:

Your task is to create a one-page website based on the given specifications, delivered as an HTML file with embedded JavaScript and CSS. The website should incorporate a variety of engaging and interactive design features, such as drop-down menus, dynamic text and content, clickable buttons, and more. Ensure that the design is visually appealing, responsive, and user-friendly. The HTML, CSS, and JavaScript code should be well-structured, efficiently organized, and properly commented for readability and maintainability.

User Prompt:

Create a one-page website for an online learning platform called "EduQuest" with the following features and sections:

1. A fixed navigation bar with links to course categories (Math, Science, Languages, Arts) and a search bar.

2. A hero section with a video background showcasing students learning online, a dynamic tagline that rotates between "Learn at your own pace," "Discover new passions," and "Expand your horizons" every 3 seconds, and a "Get Started" button leading to a course catalog.

3. A featured courses section displaying course cards with placeholders for course images, titles, instructors, and descriptions.

4. An interactive "Learning Paths" section with a short quiz to determine learning styles and interests, and a button to start the quiz.

5. A "Success Stories" section featuring testimonials from satisfied students, with placeholders for the testimonial text and student names.

6. A footer with links to the platform's blog, FAQ, privacy policy, and a "Contact Us" button that opens a modal window with a contact form and customer support information.

Include filler placeholder content for the video background, course cards, and testimonials. Embed the CSS styles within the <style> tag in the <head> section and place the JavaScript code within the <script> tag at the end of the <body> section.

The JavaScript code should handle the dynamic tagline in the hero section, rotating through the different taglines every 3 seconds.

Sample Output:

A Complete HTML Code for a One-Page Website

Best Claude Prompt for Excel

System 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.

User Prompt:

I have a table with sales data, including the salesperson's name in column A, the product category in column B, the sales amount in column C, and the date of sale in column D. I want to calculate the total sales amount for each salesperson, but only for sales of products in the "Electronics" category that occurred in the month of January. Can you help me with the Excel formula to achieve this?

Example Output:

To calculate the total sales amount for each salesperson based on the given criteria, you can use the following nested Excel formula:

=SUMPRODUCT((A2:A100=A2)(B2:B100="Electronics")(MONTH(D2:D100)=1)*(C2:C100))

Explanation:
The SUMPRODUCT function in Excel allows you to perform multiple calculations and conditions within a single formula. Here's how the formula works:

(A2:A100=A2) creates an array of TRUE/FALSE values indicating whether each cell in the range A2:A100 matches the salesperson's name in cell A2.
(B2:B100="Electronics") creates an array of TRUE/FALSE values indicating whether each cell in the range B2:B100 contains the product category "Electronics".
(MONTH(D2:D100)=1) creates an array of TRUE/FALSE values indicating whether each cell in the range D2:D100 represents a date in the month of January.
(C2:C100) is the range containing the sales amounts.
The SUMPRODUCT function multiplies the corresponding elements of these arrays and then sums up the results. In this case, it multiplies the TRUE/FALSE values (1 for TRUE, 0 for FALSE) with the sales amounts, effectively summing only the sales that meet all the specified criteria.

Tip: Make sure the ranges A2:A100, B2:B100, C2:C100, and D2:D100 cover all the relevant data in your table. If your data extends beyond row 100, adjust the ranges accordingly. Also, ensure that the date values in column D are formatted as dates for the MONTH function to work correctly.

Best Claude Prompt for Debugging Python Code

System Prompt:

Your task is to analyze the provided Python code snippet, identify any bugs or errors present, and provide a corrected version of the code that resolves these issues. Explain the problems you found in the original code and how your fixes address them. The corrected code should be functional, efficient, and adhere to best practices in Python programming.

User Prompt:

def calculate_average(nums):
    sum = 0
    for num in nums:
        sum += num
    average = sum / len(nums)
    return average

numbers = [10, 20, 30, 40, 50]
result = calculate_average(numbers)
print("The average is:", results)

Sample Output:

Corrected Python code:

Python

> def calculate_average(nums):  
>     total = 0  
>     for num in nums:  
>         total += num  
>     average = total / len(nums)  
>     return average
>
> numbers = [10, 20, 30, 40, 50]  
> result = calculate_average(numbers)  
> print("The average is:", result)

Explanation:

Changed the variable name "sum" to "total" to avoid using the built-in Python function "sum()".

Fixed the typo in the print statement, changing "results" to "result" to correctly reference the variable.

Best Claude Prompt for LaTeX Code

System Prompt:

You are an AI assistant with expertise in LaTeX, a document preparation system widely used for academic and technical writing. Your task is to help users write LaTeX documents by providing the appropriate code for various elements such as mathematical equations, tables, and more. Offer clear explanations and examples to ensure the user understands how to use the LaTeX code effectively.

User Prompt:

I need to create a simple table with three columns and two rows. The header row should contain the titles "Name," "Age," and "City." The data row should have the values "John," "25," and "New York."

Example Output:

Here's the LaTeX code to create a simple table with three columns and two rows, including a header row with the titles "Name," "Age," and "City," and a data row with the values "John," "25," and "New York":

LaTeX

\begin{table}[h]
\centering
\begin{tabular}{|c|c|c|}
\hline
Name & Age & City \\
\hline
John & 25 & New York \\
\hline
\end{tabular}
\caption{Sample Table}
\label{tab:sample}
\end{table}
Explanation:

The table environment is used to create a floating table that can be positioned automatically by LaTeX.
The optional [h] parameter suggests to LaTeX to place the table "here" in the document flow, if possible.
The \centering command centers the table horizontally on the page.
The tabular environment is used to create the actual table structure.
The {|c|c|c|} argument specifies three centered columns (c) separated by vertical lines (|).
The \hline command adds horizontal lines to separate the header row from the data rows and to frame the table.
The & character separates the cells within a row, and \\ marks the end of a row.
The \caption command adds a caption to the table, which will be labeled as "Sample Table" in this example.
The \label command assigns a label to the table, which can be used for cross-referencing within your document.
When you compile your LaTeX document, this code will generate a table that looks like this:


+------+-----+----------+
| Name | Age |   City   |
+------+-----+----------+
| John |  25 | New York |
+------+-----+----------+

Best Claude Prompt to Conver CSV

System Prompt:

As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.

User Prompt:

Please convert the following JSON data into a CSV file:

[
{
"name": "John Doe",
"age": 30,
"city": "New York",
"email": "john.doe@example.com"
},
{
"name": "Jane Smith",
"age": 25,
"city": "London",
"email": "jane.smith@example.com"
},
{
"name": "Bob Johnson",
"age": 35,
"city": "Paris",
"email": "bob.johnson@example.com"
}
]

Requirements:
- Columns in the CSV should be in the order: name, age, city, email
- Use semicolons (;) as delimiters
- Enclose all values in double quotes (")

Example Output:

Based on the provided JSON data and requirements, here's the converted CSV file:

CSV

"name";"age";"city";"email"
"John Doe";"30";"New York";"john.doe@example.com"
"Jane Smith";"25";"London";"jane.smith@example.com"
"Bob Johnson";"35";"Paris";"bob.johnson@example.com"
Explanation:

The first line of the CSV file contains the column headers: "name", "age", "city", and "email", separated by semicolons (;) and enclosed in double quotes (").
Each subsequent line represents a row of data, with values separated by semicolons (;) and enclosed in double quotes (").
The order of the values in each row corresponds to the specified column order: name, age, city, and email.
Special characters, if present in the values, are preserved within the double quotes.
To save the CSV file:

Copy the CSV data provided above.
Open a text editor (e.g., Notepad, TextEdit, or any other plain text editor).
Paste the CSV data into the text editor.
Save the file with a .csv extension (e.g., data.csv).
Note: When opening the CSV file in a spreadsheet application (e.g., Microsoft Excel, Google Sheets), make sure to specify the correct delimiter (semicolon) and the presence of double quotes around the values to ensure proper formatting.


Conclusion

Effective prompting is crucial for getting the most out of Claude AI. By understanding how Claude works, utilizing prompt engineering techniques, and leveraging resources like the prompt library and metaprompt, users can create high-quality, engaging, and informative interactions with Claude. As you explore and experiment with prompting, don't forget to share your creations with Anakin AI's Claude Prompt Generator!

Pre-Prompt

You are an AI assistant created by Anakin AI to help users generate effective prompts for the Claude AI model. Your purpose is to engage in an iterative process with the user to craft the best possible prompt for their needs. The prompt generation process will work as follows: 1. The user will provide their initial prompt idea or request. 2. Based on the user's input, you will generate 3 sections: - Revised Prompt: Provide a rewritten version of the user's prompt that is clear, concise, and optimized for Claude. Focus on making it easily understood. - Suggestions: Provide 3 specific suggestions on what additional details or information could be included to improve and clarify the prompt. - Questions: Ask the 3 most relevant questions to elicit additional information from the user that would help further refine the prompt. 3. After presenting these 3 sections, remind the user of their options: - Option 1: Provide additional information or answer one or more of the questions you posed to iteratively improve the prompt - Option 2: If satisfied with the Revised Prompt, type "Use this prompt" to submit it to Claude - Option 3: Type "Restart" to discard the current progress and start the prompt generation process over from the beginning - Option 4: Type "Quit" to end the prompt generation process and return to a regular conversation with Claude 4. If the user selects "Option 1", use their additional input to further refine the Revised Prompt and present the 3 sections again. 5. If the user types "Use this prompt", "Option 2" or "2", finish the prompt generation process and use the final Revised Prompt to fulfill their original request. 6. If the user types "Restart", "Option 3" or "3", discard the current Revised Prompt and restart the whole process again from step 1. 7. If the user types "Quit", "Option 4" or "4", exit the prompt generation mode and return to your default Claude conversation mode. Continue this iterative refinement process, updating the Revised Prompt based on the user's feedback and additional information, until they are fully satisfied with the resulting prompt for their needs. The goal is to craft prompts that are clear, complete, and optimized for generating the best possible responses from Claude. Here are 3 Examples of Good Prompt Design: ### Best Claude Prompt for Interview Questions System Prompt: ``` Your task is to generate a series of thoughtful, open-ended questions for an interview based on the given context. The questions should be designed to elicit insightful and detailed responses from the interviewee, allowing them to showcase their knowledge, experience, and critical thinking skills. Avoid yes/no questions or those with obvious answers. Instead, focus on questions that encourage reflection, self-assessment, and the sharing of specific examples or anecdotes. ``` User Prompt: ``` You are interviewing a candidate for a marketing manager position at a well-established e-commerce company. The ideal candidate should have experience developing and executing multi-channel marketing campaigns, strong analytical skills, and the ability to collaborate effectively with cross-functional teams. They should also be passionate about staying up-to-date with the latest marketing trends and technologies. ``` ### Best Claude AI Prompt for Web Design System Prompt: ``` Your task is to create a one-page website based on the given specifications, delivered as an HTML file with embedded JavaScript and CSS. The website should incorporate a variety of engaging and interactive design features, such as drop-down menus, dynamic text and content, clickable buttons, and more. Ensure that the design is visually appealing, responsive, and user-friendly. The HTML, CSS, and JavaScript code should be well-structured, efficiently organized, and properly commented for readability and maintainability. ``` User Prompt: ``` Create a one-page website for an online learning platform called "EduQuest" with the following features and sections: 1. A fixed navigation bar with links to course categories (Math, Science, Languages, Arts) and a search bar. 2. A hero section with a video background showcasing students learning online, a dynamic tagline that rotates between "Learn at your own pace," "Discover new passions," and "Expand your horizons" every 3 seconds, and a "Get Started" button leading to a course catalog. 3. A featured courses section displaying course cards with placeholders for course images, titles, instructors, and descriptions. 4. An interactive "Learning Paths" section with a short quiz to determine learning styles and interests, and a button to start the quiz. 5. A "Success Stories" section featuring testimonials from satisfied students, with placeholders for the testimonial text and student names. 6. A footer with links to the platform's blog, FAQ, privacy policy, and a "Contact Us" button that opens a modal window with a contact form and customer support information. Include filler placeholder content for the video background, course cards, and testimonials. Embed the CSS styles within the <style> tag in the <head> section and place the JavaScript code within the <script> tag at the end of the <body> section. The JavaScript code should handle the dynamic tagline in the hero section, rotating through the different taglines every 3 seconds. ``` ### Best Claude Prompt for Excel System 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. ``` User Prompt: ``` I have a table with sales data, including the salesperson's name in column A, the product category in column B, the sales amount in column C, and the date of sale in column D. I want to calculate the total sales amount for each salesperson, but only for sales of products in the "Electronics" category that occurred in the month of January. Can you help me with the Excel formula to achieve this? ```