This AI Cheatsheets article provides an extensive guide on leveraging AI GPT models and other AI tools to boost productivity across various domains. It covers essential AI prompts for writing, entertainment, academic life, programming, data science, and even foreign language learning. Discover how to effectively use AI for content creation, data analysis, and problem-solving, along with a curated list of new AI tools and their impact on different enterprise functions like finance, HR, marketing, and sales.
7 "Goals" To Be The Best Instructions When Asking It To Rewrite Something
- More persuasive: Ask ChatGPT to rewrite your text with powerful, convincing language that will leave your readers no choice but to take action.
- More informative: Ask ChatGPT to rewrite your text with rich, informative details that will leave your readers feeling educated and informed.
- More descriptive: Ask ChatGPT to rewrite your text with evocative, descriptive language that paints a vivid and unforgettable picture in your readers’ minds.
- More humorous: Ask ChatGPT to rewrite your text with clever, comedic touches that will leave your readers laughing and entertained.
- More action-oriented: Ask ChatGPT to rewrite your text with urgent, action-oriented language that will inspire your readers to take immediate action.
- More emphatic: Ask ChatGPT to rewrite your text with an emphasis on the emotions and feelings of the characters or subjects you’re writing about, making the reader feel and connect with the story more.
- More concise: Ask ChatGPT to rewrite your text using more concise and to-the-point language, making it more direct and easy to understand for your readers.
Cheat sheet for different situations
Entertainment
Create X [element] considering [detail].
- Example: Create 5 jokes considering words like knowledge and money.
- Example: Create 5 pickup lines considering that you're a doctor.
Create a X-day [type of plan] for [detail].
- Example: Create a 7-day trip for our anniversary in September.
- Example: Create a 30-day workout for my arms and abs with no gym equipment.
- Example: Create a 5-day meal plan for a child who is lactose intolerant.
Provide X gift ideas for [type of people].
- Example: Provide 3 gift ideas for clients of a travel agency.
- Example: Provide 4 gift ideas for business partners in a healthcare company.
- Example: Provide 5 gift ideas under $100 for a teenager who loves football.
Act as a [type of person] that is [behavior]. [Action].
- Example: Act as a customer support assistant that is empathetic and polite. Now answer this email.
- Example: Act as a salesperson that is very persistent. Imagine we're on a phone call and try to sell a pen to me.
- Example: Act as my personal chef. I'll tell you about my dietary preferences and allergies, and you'll suggest recipes for me to try.
- Example: Act as a film critic. You'll review a movie and provide both positive and negative feedback about the plot, direction, and music.
Writing
Write a [adjective] [type of content] on [goal]. Explain why: [topic 1, topic 2...]
- Example: Write a friendly blog post on why people should lose weight. Explain why obesity is a problem, how people can lose weight, and why being healthy is important.
- Example: Write a humorous essay on how not to prepare for an exam.
Can you [action] my text [adjective]?
- Example: Can you make my paragraph less formal?
- Example: Can you make my sentence easier to read?
- Example: Can you complete my sentence? [insert sentence]
- Example: Can you continue my paragraph? [insert paragraph]
Write a [type of content] for [subject] showcasing the [benefit1, benefit2,...].
- Example: Write a social media ad for a productivity tool showcasing its simplicity and design.
- Example: Create a sales copy for a travel agency showcasing the price, destinations, and commitment.
Reply to this email: [insert email]. Be [behavior] and say [ideas].
- Example: Reply to this email. Be polite and say that I accept the offer if...
- Example: Reply to this email. Be friendly and say that I don't have time for the meeting.
Create X [type of content] for [platform] [details].
- Example: Create 5 hashtags and a caption for a picture on Instagram of a cute cat.
- Example: Create 2 bios for LinkedIn highlighting my work achievements.
Academic Life
Provide X ways to improve [subject].
- Example: Provide 3 ways to improve my resume summary: [insert text].
- Example: Provide 2 ways to improve my essay: [insert essay].
- Example: Provide 5 ways to improve the title of my article: [insert title].
Provide step-by-step instructions on how to [subject].
- Example: Provide step-by-step instructions on how to increase my vocabulary.
- Example: Provide step-by-step instructions on how to prepare for a job interview.
- Example: Provide step-by-step instructions on how to become a software engineer.
Suggest a [adjective] name for my [type] using the words [word1, word2...].
- Example: Suggest funny names for my college team using the words flawless and brain.
- Example: Suggest a catchy name for my website using the words artificial and age.
- Example: Suggest a simple name for my startup using the word cloud.
- Can you summarize [title]?Example: Can you summarize the book The Little Prince?
- Example: Can you summarize World War II in 400 words
- Example: Can you summarize this article? [insert text].
Spreadsheet
Create a formula to [goal] in cell [range of cells].
- Example: Create a formula to calculate the sum in cells A1 to A10.
- Example: Create a formula to calculate the average in cells H10 to H20.
- Example: Create a formula that sums only the expenses that have the status "No" in column C.
Explain the meaning of the formula [formula].
- Example: Explain the meaning of the formula SUM(A1:A10).
- Example: Explain the meaning of the formula AVERAGE(H10:H20).
- Example: Explain the meaning of the formula SUMIF(C1:C13, "No", B1:B13).
- I have a table with phone numbers in column A that have the format: (xxx) xxx-xxxx. Extract the numbers within parenthesis using Excel.
- Create a macro that calculates the average of cells B1 to B10 and inserts the result in cell C1.
- Create a macro that sorts sheets by tab name using VBA.
Create a formula to [goal] in cell [range of cells].
- Example: Create a formula in Google Sheets to calculate the sum in cells A1 to A10.
- Example: Create a formula in Google Sheets that puts data from one sheet into the current sheet.
- Explain this Google Sheet command: [insert command].
Programming
How to [action] in [programming language]
- Example: How to merge dictionaries in Python
- Example: How to join two datasets in Python?
What's the difference between [concept1] and [concept2] in [language]
- Example: What's the difference between lists and dictionaries in Python
- Example: What's the difference between OOP and functional programming?
Explain the [concept] in [language].
- Example: Explain the while loop in Python.
- Example: Explain the try/except in Python to a child.
I want to learn [language] for [field]. Create a roadmap to learn [language].
- Example: I want to learn Python for data science. Create a roadmap to learn Python.
- Example: I want to learn JavaScript for web development. Create a roadmap to learn it.
I want to automate [app]. Provide steps to [task] with [language].
- Example: I want to automate Gmail. Provide steps to sending emails with Python.
- Example: I want to automate Tinder. Provide steps to swipe right with Python.
Simulate a job interview for a [position] by asking and answering questions as if you are a potential employer and I'm the candidate. Consider that [details].
I want to build a [type of website]. Can you generate some HTML for my website?
- Example: I want to build a job board website. Can you generate some HTML for my website?
- Example: I want to build a price comparison website. Can you generate some HTML for my website?
Act as a [type of person] that is [behavior]. [Action].
- Example: Act as a customer support assistant that is empathetic and polite. Now answer this email.
- Example: Act as a salesperson that is very persistent. Imagine we're on a phone call and try to sell a pen to me.
- Example: Act as my personal chef. I'll tell you about my dietary preferences and allergies, and you'll suggest recipes for me to try.
- Example: Act as a film critic. You'll review a movie and provide both positive and negative feedback about the plot, direction, and music.
Content Creation
Give me ideas for [type of content] about [subject], covering topics like [topic1, topic2...].
- Example: Give me ideas for a blog post about writing covering topics like writing tools and writer's block.
- Example: Give me ideas for a podcast about technology covering topics like AI and machine learning.
- Example: Give me ideas for a YouTube video about best books to read covering only self-help books.
Create an outline for [type of content].
- Example: Create an outline for a blog post about productivity.
- Example: Create an outline for a book "how to learn to learn a foreign language in 3 months".
- Example: Create an outline for a course "how to learn Python for data science".
Act as a prompt generator for Midjourney's AI. Your job is to describe [object] as concisely as possible. Always give 3 different and contrasting versions of a [object] and include any random artist name prefixed by "in the style of".
Choose X random contest winner(s) from a long list of names or emails: [insert names or emails].
Turn a [list] into [type of quiz].
- Example: Turn a list of facts about world history into a multiple-choice quiz.
- Example: Turn a list of facts about biology into true/false questions.
Tone Modifiers
| Tone Combo | Impact on Output | Use Case | Example |
|---|---|---|---|
|
Friendly + Professional |
Warm and approachable, yet knowledgeable and competent |
Sales emails, customer service, marketing copy |
Hi there! We’re excited to help you with your purchase. Our team of experts is here to ensure you have a seamless experience from start to finish. |
|
Authoritative + Informative |
Confident and knowledgeable, yet informative and helpful |
Thought leadership articles, industry reports |
As leaders in the field, we have conducted extensive research and analysis to provide you with the most up-to-date insights on the latest trends and best practices in the industry. |
|
Urgent + Persuasive |
High sense of urgency and importance, yet persuasive and convincing |
Limited time offers, promotional campaigns |
Act fast and don’t miss out on this exclusive deal! Our premium products are in high demand and we don’t want you to miss your chance to own them. |
|
Casual + Conversational |
Relaxed and friendly, yet conversational and engaging |
Social media posts, blog content, internal communications |
Hey there! We wanted to share some exciting news with you. Our team has been hard at work on a new product that we know you’re going to love. |
|
Professional + Trustworthy |
Reliable and dependable, yet professional and polished |
Business proposals, executive summaries, investor pitches |
Our team has a proven track record of delivering exceptional results for our clients. With our extensive expertise and commitment to excellence, you can trust us to deliver on our promises.
|
|
Humorous + Informal |
Entertaining and playful, yet relaxed and conversational |
Social media, blog content, internal communications |
Our office dog is our official mascot and brings joy to our team every day. Follow our social media to see more of his antics! |
|
Professional + Straightforward |
Direct and concise, yet professional and polished |
Business emails, formal communications, legal documents |
We appreciate your interest in our company and would be happy to provide additional information upon request. Please let us know if you have any questions. |
|
Serious + Empathetic |
Understanding and caring, yet serious and sincere |
Crisis communications, customer service, sensitive topics |
We understand the impact that recent events have had on our community, and we want you to know that we are here to support you in any way we can. |
|
Positive + Enthusiastic |
Optimistic and enthusiastic, yet positive and upbeat |
Sales pitches, customer service, motivational content |
Our products are designed to help you achieve your goals and reach new heights of success. We’re excited to be on this journey with you! |
|
Authoritative + Professional |
Confident and knowledgeable, yet polished and refined |
Executive communications, industry presentations, board meetings |
As industry leaders, we are committed to setting the standard for excellence and delivering exceptional results for our stakeholders |
|
Casual + Funny |
Relaxed and playful, yet humorous and entertaining |
Social media, brand personality, content marketing |
Did you hear the one about the marketer who walked into a bar? Neither did we, but we’re always up for a good laugh! |
|
Authoritative + Expert |
Confident and knowledgeable, yet authoritative and respected |
Thought leadership articles, industry reports, expert opinions |
As experts in the field, we have a deep understanding of the challenges and opportunities facing our industry. Our insights and recommendations are based on years of experience and rigorous analysis. |
Basic Analysis You Can Generate - Example Prompts:
- Data Manipulation: Filter the data to include only rows where the age is greater than 25, then sort by salary.
- Data Cleaning: Remove any duplicate entries and fill missing values in the ‘age’ column with the mean age.
- Generate insights: Run a basic analysis on the data and generate a list of insights.
- Apply Formulas and Functions: Create a custom formula and apply it to the data to generate total revenue by location.
- Automation and Scripting: Write a script to automate the monthly report generation process.
- Manipulate Styles and Formatting: Change the font color of the ‘total’ column to blue and apply conditional formatting to highlight values above 1000.
- Work with Multiple Sheets: Access the second sheet in the workbook and calculate the sum of the ‘expenses’ column.
- Save New Data: Save the modified data to a new CSV file.
Advanced Analysis:
- Machine Learning and Predictive Modeling: Train a linear regression model using the features ‘age’, ‘experience’, and predict the ‘salary’.
- Integrate with Databases: Import data from a SQL database and merge it with existing data in a spreadsheet.
- Location Analysis: Create a pivot table summarizing sales by region and apply data validation rules to ensure accuracy in the ‘quantity’ column.
- Time Series Analysis: Analyze the time series data for stock prices and identify the seasonal trends.
- Text Analysis: Extract and analyze customer reviews from a column, identifying common positive and negative sentiments.
- Conditional Operations: Apply a 10% discount to the ‘price’ column for products in the ‘electronics’ category.
- Integration with External APIs: Fetch weather data from an external API and integrate it with sales data to analyze weather-related sales trends.
- Batch Processing: Write a script to process multiple CSV files in a directory, summarizing the sales data.
- Data Transformation: Normalize the values in the ‘height’ and ‘weight’ columns using min-max scaling.
New AI Tools List
Research Tools:
Marketing Tools:
Music Tools:
Content Creation Tools:
Daily Life Tools: